contig_metadata
8 rows where analysis = "blastn" and tax_phylum = "Candidatus Iainarchaeota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2871384 | 2871384 | PRJNA1193541_P_NODE_13583_length_246_cov_0.890173_g13445_i0 | PRJNA1193541 | 13583 | 246 | 0.890173 | 2.18982558 | Candidatus Iainarchaeum archaeon | 3101447 | Archaea | Archaea | 113 | 1e-20 | NTclustered | gi|1958045250|gb|CP064981.1| | 2026736 | g13445 | i0 | 89.011 | 0.369918699186992 | 91 | 10 | 37 | 0 | 2 | 92 | 540467 | 540557 | MAG: Candidatus Iainarchaeum archaeon isolate Fred_18-Q3-R57-64_BAT3C.431 chromosome, complete genome | blastn | 91 | 113 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Iainarchaeum | Candidatus Iainarchaeum archaeon | |||||
| 6506588 | 6506588 | PRJEB64798_P_NODE_233546_length_157_cov_6.231481_g231780_i0 | PRJEB64798 | 233546 | 157 | 6.231481 | 9.78342517 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 63.9 | 5.98e-6 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g231780 | i0 | 80.233 | 0.547770700636943 | 86 | 16 | 55 | 1 | 53 | 138 | 521163 | 521247 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 86 | 63.9 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum | |||||
| 7948053 | 7948053 | PRJNA1148190_P_NODE_392227_length_288_cov_1.130233_g381054_i0 | PRJNA1148190 | 392227 | 288 | 1.130233 | 3.25507104 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 466 | 8.03e-127 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g381054 | i0 | 95.833 | 1 | 288 | 12 | 100 | 0 | 1 | 288 | 324636 | 324349 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 288 | 466 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum | |||||
| 10394283 | 10394283 | PRJNA1074408_S_NODE_6029_length_189_cov_1.534247_g5899_i0 | PRJNA1074408 | 6029 | 189 | 1.534247 | 2.89972683 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 128 | 2.62e-25 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g5899 | i0 | 82.639 | 10.3544973544974 | 144 | 25 | 76 | 0 | 2 | 145 | 455925 | 455782 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 1957 | 128 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum | |||||
| 13515090 | 13515090 | PRJNA781427_P_NODE_65091_length_274_cov_1.149254_g64207_i0 | PRJNA781427 | 65091 | 274 | 1.149254 | 3.14895596 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g64207 | i0 | 100 | 0.105839416058394 | 29 | 0 | 11 | 0 | 4 | 32 | 494019 | 494047 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum | |||||
| 16703397 | 16703397 | PRJEB64798_P_NODE_125474_length_201_cov_7.513158_g123708_i0 | PRJEB64798 | 125474 | 201 | 7.513158 | 15.10144758 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 196 | 7.63e-46 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g123708 | i0 | 85.052 | 2.86069651741294 | 194 | 27 | 96 | 2 | 9 | 201 | 519318 | 519126 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 575 | 196 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum | |||||
| 21004141 | 21004141 | PRJNA630162_P_NODE_141517_length_166_cov_2.615385_g139994_i0 | PRJNA630162 | 141517 | 166 | 2.615385 | 4.3415391 | Candidatus Iainarchaeum archaeon | 3101447 | Archaea | Archaea | 110 | 8.13e-20 | NTclustered | gi|1958045250|gb|CP064981.1| | 2026736 | g139994 | i0 | 91.25 | 352.78313253012 | 80 | 7 | 48 | 0 | 83 | 162 | 658592 | 658671 | MAG: Candidatus Iainarchaeum archaeon isolate Fred_18-Q3-R57-64_BAT3C.431 chromosome, complete genome | blastn | 58562 | 110 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Iainarchaeum | Candidatus Iainarchaeum archaeon | |||||
| 21865384 | 21865384 | PRJNA1074407_P_NODE_129058_length_264_cov_0.926702_g125220_i0 | PRJNA1074407 | 129058 | 264 | 0.926702 | 2.44649328 | Candidatus Forterrea multitransposorum | 2107590 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|1770793198|gb|CP045477.1| | 2107591 | g125220 | i0 | 100 | 0.106060606060606 | 28 | 0 | 11 | 0 | 190 | 217 | 586102 | 586075 | MAG: Candidatus Forterrea multitransposorum CG_2015-17_Forterrea_25_41 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Forterrea | Candidatus Forterrea multitransposorum |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;