akash query bank total.md

$ akash query bank total | jq -r '.supply[] | [.denom, .amount] | @tsv' | while read denom amount; do [ ${denom:0:3} = "ibc" ] && { buf=$(akash query ibc-transfer denom-trace ${denom:4}); r_denom=$(echo "$buf" | jq -r '.denom_trace.base_denom'); path=$(echo "$buf" | jq -r '.denom_trace.path'); } || r_denom=$denom; echo $r_denom $amount $path; done | column -t
uakt                                                                  1000000              transfer/channel-17/transfer/channel-192/transfer/channel-2
uakt                                                                  360234656            transfer/channel-17/transfer/channel-141/transfer/channel-1
ujuno                                                                 100000               transfer/channel-24/transfer/channel-14
uakt                                                                  10000000             transfer/channel-26/transfer/channel-1
ujuno                                                                 1128                 transfer/channel-35
uakt                                                                  373354               transfer/channel-37/transfer/channel-0/transfer/channel-184
uakt                                                                  1914376583           transfer/channel-5/transfer/channel-141/transfer/channel-1
uatom                                                                 10000                transfer/channel-7
uatom                                                                 10269437             transfer/channel-0
uatom                                                                 84557367             transfer/channel-17
uosmo                                                                 10000                transfer/channel-17/transfer/channel-141
ujuno                                                                 19998                transfer/channel-36
uakt                                                                  863573411            transfer/channel-9/transfer/channel-0/transfer/channel-184
uakt                                                                  1000000              transfer/channel-19/transfer/channel-1
poolDFB8434D5A80B4EAFA94B6878BD5B85265AC6C5D37204AB899B1C3C52543DA7E  400000               transfer/channel-17
uxprt                                                                 1145279              transfer/channel-20
uakt                                                                  50000                transfer/channel-9/transfer/channel-47/transfer/channel-2
uiris                                                                 10000                transfer/channel-17/transfer/channel-182
uregen                                                                115404               transfer/channel-21
uakt                                                                  70103348             transfer/channel-5/transfer/channel-184
uatom                                                                 100102               transfer/channel-24/transfer/channel-0
rowan                                                                 1100000000000000000  transfer/channel-24
uakt                                                                  101000               transfer/channel-17/transfer/channel-95
uion                                                                  1                    transfer/channel-9
uosmo                                                                 14322532             transfer/channel-9
ukava                                                                 1                    transfer/channel-37
uatom                                                                 9766500              transfer/channel-5
uatom                                                                 500                  transfer/channel-1
basecro                                                               97398750             transfer/channel-18
pool2B9C24833CAA268C9081EC251693A724E8D343FC25A841FF00FD37B047BA4DEA  92843                transfer/channel-17
pool32DD066BE949E5FDCC7DC09EBB67C7301D0CA957C2EF56A39B37430165447DAC  124                  transfer/channel-17
uiris                                                                 22945871             transfer/channel-16
xbtsg                                                                 11000000000          transfer/channel-24
xeth                                                                  415033               transfer/channel-24
uakt                                                                  179689785981121      transfer/channel-24

All open IBC channels from Akash

$ akash query ibc channel channels | jq -r '.channels[] | select(.state == "STATE_OPEN") | .channel_id' | sort -V | while read CHANNEL; do printf "%s," ${CHANNEL}; akash query ibc channel client-state transfer ${CHANNEL} | jq -r '[ .client_id, .client_state.chain_id ] | @csv'; done
channel-0,"07-tendermint-8","cosmoshub-4"
channel-1,"07-tendermint-9","cosmoshub-4"
channel-2,"07-tendermint-10","swap-testnet-2005"
channel-3,"07-tendermint-11","core-1"
channel-4,"07-tendermint-12","core-1"
channel-5,"07-tendermint-14","cosmoshub-4"
channel-6,"07-tendermint-15","core-1"
channel-7,"07-tendermint-16","cosmoshub-4"
channel-9,"07-tendermint-18","osmosis-1"
channel-10,"07-tendermint-31","cosmoshub-4"
channel-11,"07-tendermint-44","irishub-1"
channel-12,"07-tendermint-45","sentinelhub-2"
channel-13,"07-tendermint-47","regen-1"
channel-14,"07-tendermint-48","crypto-org-chain-mainnet-1"
channel-15,"07-tendermint-51","dig-testnet-1"
channel-16,"07-tendermint-52","irishub-1"
channel-17,"07-tendermint-53","cosmoshub-4"
channel-18,"07-tendermint-54","crypto-org-chain-mainnet-1"
channel-19,"07-tendermint-55","osmosis-1"
channel-20,"07-tendermint-56","core-1"
channel-21,"07-tendermint-57","regen-1"
channel-22,"07-tendermint-58","sentinelhub-2"
channel-23,"07-tendermint-59","iov-mainnet-ibc"
channel-24,"07-tendermint-61","sifchain-1"
channel-25,"07-tendermint-62","sifchain-1"
channel-26,"07-tendermint-18","osmosis-1"
channel-27,"07-tendermint-66","iov-mainnet-ibc"
channel-28,"07-tendermint-67","microtick-1"
channel-29,"07-tendermint-76","impacthub-3"
channel-30,"07-tendermint-77","emoney-3"
channel-33,"07-tendermint-82","juno-1"
channel-34,"07-tendermint-83","sifchain-1"
channel-35,"07-tendermint-84","juno-1"
channel-36,"07-tendermint-90","juno-1"
channel-37,"07-tendermint-91","kava-9"
channel-38,"07-tendermint-92","umee-1"
channel-39,"07-tendermint-93","omniflixhub-1"

source - target channels

$ akash query ibc channel channels | jq -r '.channels[] | select(.state == "STATE_OPEN") | [ .channel_id, (.counterparty | .port_id, .channel_id), .connection_hops[] ] | @csv' | sort -t "," -V -k1,1
"channel-0","transfer","channel-95","connection-2"
"channel-1","transfer","channel-97","connection-3"
"channel-2","transfer","channel-1","connection-4"
"channel-3","transfer","channel-3","connection-5"
"channel-4","transfer","channel-4","connection-6"
"channel-5","transfer","channel-116","connection-7"
"channel-6","transfer","channel-5","connection-8"
"channel-7","transfer","channel-121","connection-9"
"channel-9","transfer","channel-1","connection-11"
"channel-10","transfer","channel-165","connection-16"
"channel-11","transfer","channel-9","connection-19"
"channel-12","transfer","channel-6","connection-21"
"channel-13","transfer","channel-7","connection-22"
"channel-14","transfer","channel-21","connection-23"
"channel-15","transfer","channel-1","connection-27"
"channel-16","transfer","channel-11","connection-28"
"channel-17","transfer","channel-184","connection-29"
"channel-18","transfer","channel-24","connection-30"
"channel-19","transfer","channel-18","connection-31"
"channel-20","transfer","channel-20","connection-32"
"channel-21","transfer","channel-10","connection-33"
"channel-22","transfer","channel-10","connection-34"
"channel-23","transfer","channel-6","connection-35"
"channel-24","transfer","channel-2","connection-36"
"channel-25","transfer","channel-5","connection-37"
"channel-26","transfer","channel-33","connection-11"
"channel-27","transfer","channel-7","connection-39"
"channel-28","transfer","channel-5","connection-40"
"channel-29","transfer","channel-0","connection-50"
"channel-30","transfer","channel-3","connection-51"
"channel-33","transfer","channel-8","connection-56"
"channel-34","transfer","channel-20","connection-57"
"channel-35","transfer","channel-29","connection-58"
"channel-36","transfer","channel-30","connection-59"
"channel-37","transfer","channel-5","connection-60"
"channel-38","transfer","channel-5","connection-61"
"channel-39","transfer","channel-7","connection-62"