contig_metadata
11 rows where bioproject = "PRJNA630162" and tax_phylum = "Candidatus Falkowiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1878869 | 1878869 | PRJNA630162_P_NODE_83122_length_198_cov_1.865772_g81599_i0 | PRJNA630162 | 83122 | 198 | 1.865772 | 3.69422856 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 60.2 | 1.03e-4 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g81599 | i0 | 97.143 | 0.176767676767677 | 35 | 1 | 18 | 0 | 164 | 198 | 656063 | 656029 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 35 | 60.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 4429447 | 4429447 | PRJNA630162_P_NODE_149504_length_164_cov_3.400000_g147981_i0 | PRJNA630162 | 149504 | 164 | 3.4 | 5.576 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 169 | 1.3000000000000001e-37 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g147981 | i0 | 89.552 | 208.34756097561 | 134 | 13 | 81 | 1 | 6 | 138 | 656389 | 656256 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 34169 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 8254477 | 8254477 | PRJNA630162_P_NODE_101327_length_185_cov_1.257353_g99804_i0 | PRJNA630162 | 101327 | 185 | 1.257353 | 2.32610305 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 327 | 2.34e-85 | NTclustered | gi|2801818892|emb|OZ173682.1| | 2053554 | g99804 | i0 | 99.444 | 52.6054054054054 | 180 | 1 | 97 | 0 | 1 | 180 | 769416 | 769237 | Candidatus Falkowbacteria bacterium isolate Fred.cMAG.1 genome assembly, chromosome: 1 | blastn | 9732 | 327 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 13357015 | 13357015 | PRJNA630162_P_NODE_94391_length_189_cov_1.442857_g92868_i0 | PRJNA630162 | 94391 | 189 | 1.442857 | 2.72699973 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 183 | 5.509999999999999e-42 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g92868 | i0 | 85.027 | 155.306878306878 | 187 | 20 | 97 | 7 | 2 | 185 | 654990 | 655171 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 29353 | 183 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 14631760 | 14631760 | PRJNA630162_P_NODE_91932_length_190_cov_3.304965_g90409_i0 | PRJNA630162 | 91932 | 190 | 3.304965 | 6.2794335 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 302 | 1.47e-77 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g90409 | i0 | 95.722 | 23.3894736842105 | 187 | 8 | 98 | 0 | 1 | 187 | 654655 | 654841 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 4444 | 302 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 17179910 | 17179910 | PRJNA630162_P_NODE_165254_length_159_cov_2.190909_g163731_i0 | PRJNA630162 | 165254 | 159 | 2.190909 | 3.48354531 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 200 | 4.439999999999999e-47 | NTclustered | gi|2801818892|emb|OZ173682.1| | 2053554 | g163731 | i0 | 91.156 | 4.69182389937107 | 147 | 13 | 92 | 0 | 9 | 155 | 766742 | 766888 | Candidatus Falkowbacteria bacterium isolate Fred.cMAG.1 genome assembly, chromosome: 1 | blastn | 746 | 200 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 18454309 | 18454309 | PRJNA630162_P_NODE_41315_length_276_cov_4.396476_g39792_i0 | PRJNA630162 | 41315 | 276 | 4.396476 | 12.13427376 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 305 | 1.76e-78 | NTclustered | gi|2801818892|emb|OZ173682.1| | 2053554 | g39792 | i0 | 87.085 | 188.70652173913 | 271 | 33 | 98 | 2 | 1 | 270 | 769508 | 769239 | Candidatus Falkowbacteria bacterium isolate Fred.cMAG.1 genome assembly, chromosome: 1 | blastn | 52083 | 305 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 19728929 | 19728929 | PRJNA630162_P_NODE_48416_length_253_cov_3.671569_g46893_i0 | PRJNA630162 | 48416 | 253 | 3.671569 | 9.28906957 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 257 | 4.5300000000000005e-64 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g46893 | i0 | 85.772 | 86.774703557312293 | 246 | 31 | 96 | 4 | 2 | 245 | 655094 | 655337 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 21954 | 257 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 19729076 | 19729076 | PRJNA630162_P_NODE_60456_length_227_cov_1.730337_g58933_i0 | PRJNA630162 | 60456 | 227 | 1.730337 | 3.92786499 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 267 | 6.63e-67 | NTclustered | gi|1950824677|gb|CP066698.1| | 2053554 | g58933 | i0 | 88.889 | 5.54625550660793 | 216 | 24 | 95 | 0 | 2 | 217 | 655330 | 655545 | MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome | blastn | 1259 | 267 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 22279450 | 22279450 | PRJNA630162_P_NODE_45618_length_262_cov_1.295775_g44095_i0 | PRJNA630162 | 45618 | 262 | 1.295775 | 3.3949305 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 289 | 1.67e-73 | NTclustered | gi|2801818892|emb|OZ173682.1| | 2053554 | g44095 | i0 | 87.109 | 11.6335877862595 | 256 | 31 | 98 | 2 | 1 | 256 | 769219 | 768966 | Candidatus Falkowbacteria bacterium isolate Fred.cMAG.1 genome assembly, chromosome: 1 | blastn | 3048 | 289 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 28641037 | 28641037 | PRJNA630162_P_NODE_119127_length_175_cov_1.309524_g117604_i0 | PRJNA630162 | 119127 | 175 | 1.309524 | 2.291667 | Bacteria | 2 | Bacteria | Bacteria | 65.9 | 1e-10 | NR | PIR93709.1 | 1974565 | g117604 | i0 | 50.9 | 1.88571428571429 | 55 | 27 | 94.3 | 0 | 169 | 5 | 223 | 277 | PIR93709.1 MAG: hypothetical protein COT97_05225 [Candidatus Falkowbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_11] | diamond | 330 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_11 |
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);;