contig_metadata
23 rows where bioproject = "PRJNA683902", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4493223 | 4493223 | PRJNA683902_S_NODE_24884_length_203_cov_4.903614_g24440_i0 | PRJNA683902 | 24884 | 203 | 4.903614 | 9.95433642 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 348 | 2.0100000000000006e-91 | NTclustered | gi|2874253760|emb|OY969701.1| | 2283092 | g24440 | i0 | 97.537 | 157.871921182266 | 203 | 5 | 100 | 0 | 1 | 203 | 3174662 | 3174460 | MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 | blastn | 32048 | 348 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 9593855 | 9593855 | PRJNA683902_S_NODE_19308_length_245_cov_3.326923_g18864_i0 | PRJNA683902 | 19308 | 245 | 3.326923 | 8.15096135 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 180 | 9.72e-41 | NTclustered | gi|2874253950|emb|OY970275.1| | 171953 | g18864 | i0 | 81.013 | 83.9387755102041 | 237 | 36 | 94 | 8 | 5 | 235 | 4267666 | 4267433 | MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1 | blastn | 20565 | 180 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 12144732 | 12144732 | PRJNA683902_S_NODE_34650_length_163_cov_1.507937_g34206_i0 | PRJNA683902 | 34650 | 163 | 1.507937 | 2.45793731 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 252 | 1.25e-62 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g34206 | i0 | 94.479 | 80.840490797546 | 163 | 9 | 100 | 0 | 1 | 163 | 4652136 | 4652298 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 13177 | 252 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 12144747 | 12144747 | PRJNA683902_S_NODE_36290_length_158_cov_4.074380_g35846_i0 | PRJNA683902 | 36290 | 158 | 4.07438 | 6.4375204 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 265 | 1.5399999999999998e-66 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g35846 | i0 | 96.835 | 1 | 158 | 5 | 100 | 0 | 1 | 158 | 635213 | 635056 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 158 | 265 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 12144772 | 12144772 | PRJNA683902_S_NODE_39410_length_151_cov_2.570175_g38966_i0 | PRJNA683902 | 39410 | 151 | 2.570175 | 3.88096425 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 200 | 4.16e-47 | NTclustered | gi|2874253760|emb|OY969701.1| | 2283092 | g38966 | i0 | 90.667 | 373.05298013245 | 150 | 14 | 99 | 0 | 2 | 151 | 3177076 | 3176927 | MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 | blastn | 56331 | 200 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 15968012 | 15968012 | PRJNA683902_S_NODE_27233_length_191_cov_1.214286_g26789_i0 | PRJNA683902 | 27233 | 191 | 1.214286 | 2.31928626 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 276 | 8.95e-70 | NTclustered | gi|76574293|gb|DQ139441.1| | 171953 | g26789 | i0 | 92.67 | 104.895287958115 | 191 | 14 | 100 | 0 | 1 | 191 | 607 | 797 | Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence | blastn | 20035 | 276 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 15968032 | 15968032 | PRJNA683902_S_NODE_30573_length_176_cov_2.273381_g30129_i0 | PRJNA683902 | 30573 | 176 | 2.273381 | 4.00115056 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 100 | 5.23e-17 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g30129 | i0 | 91.667 | 0.409090909090909 | 72 | 6 | 41 | 0 | 1 | 72 | 1676956 | 1677027 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 72 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 17243102 | 17243102 | PRJNA683902_S_NODE_13074_length_348_cov_3.318328_g12630_i0 | PRJNA683902 | 13074 | 348 | 3.318328 | 11.54778144 | Granulicella sp. 5B5 | 1617967 | Bacteria | Bacteria | 555 | 2.0599999999999994e-153 | NTclustered | gi|1886125103|gb|CP046444.1| | 1617967 | g12630 | i0 | 95.402 | 105.433908045977 | 348 | 16 | 100 | 0 | 1 | 348 | 2652411 | 2652758 | Granulicella sp. 5B5 chromosome, complete genome | blastn | 36691 | 555 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella sp. 5B5 | ||
| 17243114 | 17243114 | PRJNA683902_S_NODE_14034_length_326_cov_4.709343_g13590_i0 | PRJNA683902 | 14034 | 326 | 4.709343 | 15.35245818 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 484 | 2.5499999999999994e-132 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g13590 | i0 | 93.846 | 308.193251533742 | 325 | 15 | 98 | 4 | 1 | 321 | 634315 | 634638 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 100471 | 484 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 17243267 | 17243267 | PRJNA683902_S_NODE_30254_length_177_cov_3.885714_g29810_i0 | PRJNA683902 | 30254 | 177 | 3.885714 | 6.87771378 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 250 | 4.94e-62 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g29810 | i0 | 94.444 | 88.316384180791 | 162 | 9 | 92 | 0 | 1 | 162 | 634902 | 635063 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 15632 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 18517448 | 18517448 | PRJNA683902_S_NODE_32995_length_168_cov_1.511450_g32551_i0 | PRJNA683902 | 32995 | 168 | 1.51145 | 2.539236 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 215 | 1.7e-51 | NTclustered | gi|2874254057|emb|OY970381.1| | 194844 | g32551 | i0 | 90 | 168.904761904762 | 170 | 12 | 100 | 5 | 1 | 168 | 1657105 | 1657271 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 | blastn | 28376 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 19026860 | 19026860 | PRJNA683902_S_NODE_14375_length_318_cov_27.366548_g13931_i0 | PRJNA683902 | 14375 | 318 | 27.366548 | 87.02562264 | Chloracidobacterium | 458032 | Bacteria | Bacteria | 460 | 4.1799999999999997e-125 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g13931 | i0 | 93.016 | 191.12893081761 | 315 | 22 | 99 | 0 | 1 | 315 | 4231695 | 4231381 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 60779 | 460 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 20302247 | 20302247 | PRJNA683902_S_NODE_6956_length_685_cov_4.013889_g6583_i0 | PRJNA683902 | 6956 | 685 | 4.013889 | 27.49513965 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 750 | 0 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g6583 | i0 | 86.963 | 91.8262773722628 | 698 | 54 | 99 | 25 | 2 | 685 | 4840815 | 4840141 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 62901 | 756 | 0.992063492063492 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 21067724 | 21067724 | PRJNA683902_S_NODE_23057_length_214_cov_7.305085_g22613_i0 | PRJNA683902 | 23057 | 214 | 7.305085 | 15.6328819 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 307 | 3.6400000000000006e-79 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g22613 | i0 | 92.558 | 187.696261682243 | 215 | 14 | 100 | 2 | 1 | 214 | 635884 | 636097 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 40167 | 307 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 22342763 | 22342763 | PRJNA683902_S_NODE_8718_length_536_cov_4.278557_g8295_i0 | PRJNA683902 | 8718 | 536 | 4.278557 | 22.93306552 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 721 | 0 | NTclustered | gi|2874253760|emb|OY969701.1| | 2283092 | g8295 | i0 | 91.061 | 101.839552238806 | 537 | 42 | 100 | 5 | 1 | 536 | 3176628 | 3176097 | MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 | blastn | 54586 | 721 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 24891481 | 24891481 | PRJNA683902_S_NODE_35980_length_159_cov_2.213115_g35536_i0 | PRJNA683902 | 35980 | 159 | 2.213115 | 3.51885285 | uncultured Granulicella sp. | 1241325 | Bacteria | Bacteria | 115 | 1.66e-21 | NTclustered | gi|2626255659|emb|OY843766.1| | 1241325 | g35536 | i0 | 84.483 | 34.3584905660377 | 116 | 18 | 73 | 0 | 44 | 159 | 2043214 | 2043329 | MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1 | blastn | 5463 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | uncultured Granulicella sp. | ||
| 25401981 | 25401981 | PRJNA683902_S_NODE_27600_length_189_cov_1.532895_g27156_i0 | PRJNA683902 | 27600 | 189 | 1.532895 | 2.89717155 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.3 | 2.66e-15 | NTclustered | gi|94549081|gb|CP000360.1| | 204669 | g27156 | i0 | 90.278 | 46.7301587301587 | 72 | 7 | 38 | 0 | 18 | 89 | 1550070 | 1550141 | Candidatus Koribacter versatilis Ellin345, complete genome | blastn | 8832 | 95.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Korobacter | Candidatus Korobacter versatilis | ||
| 27335212 | 27335212 | PRJNA683902_S_NODE_31423_length_173_cov_2.860294_g30979_i0 | PRJNA683902 | 31423 | 173 | 2.860294 | 4.94830862 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 48.5 | 1.32e-4 | NR | MDX1998535.1 | 2651171 | g30979 | i0 | 52.9 | 2.65317919075145 | 51 | 24 | 88.4 | 0 | 19 | 171 | 477 | 527 | MDX1998535.1 tetratricopeptide repeat protein [Thermoanaerobaculia bacterium] | diamond | 459 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27714414 | 27714414 | PRJNA683902_S_NODE_36744_length_157_cov_3.575000_g36300_i0 | PRJNA683902 | 36744 | 157 | 3.575 | 5.61275 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 49.3 | 5.7e-5 | NR | HEY2819906.1 | 3069120 | g36300 | i0 | 51.1 | 1.91082802547771 | 47 | 21 | 89.8 | 1 | 1 | 141 | 95 | 139 | HEY2819906.1 winged helix-turn-helix domain-containing protein [Candidatus Acidiferrum sp.] | diamond | 300 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 31536144 | 31536144 | PRJNA683902_S_NODE_29276_length_181_cov_2.250000_g28832_i0 | PRJNA683902 | 29276 | 181 | 2.25 | 4.0725 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.2 | 5e-11 | NR | UCF68959.1 | 1978231 | g28832 | i0 | 54.2 | 1.87292817679558 | 59 | 27 | 97.8 | 0 | 3 | 179 | 29 | 87 | UCF68959.1 MAG: hypothetical protein JSV80_06650, partial [Acidobacteriota bacterium] | diamond | 339 | 63.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31599354 | 31599354 | PRJNA683902_S_NODE_34316_length_164_cov_1.228346_g33872_i0 | PRJNA683902 | 34316 | 164 | 1.228346 | 2.01448744 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 69.3 | 5.36e-12 | NR | MDJ0838682.1 | 1978231 | g33872 | i0 | 61.5 | 1.75609756097561 | 52 | 19 | 95.1 | 1 | 6 | 161 | 164 | 214 | MDJ0838682.1 AAA family ATPase [Acidobacteriota bacterium] | diamond | 288 | 69.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32358764 | 32358764 | PRJNA683902_S_NODE_27319_length_190_cov_2.594771_g26875_i0 | PRJNA683902 | 27319 | 190 | 2.594771 | 4.9300649 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 41.6 | 0.046 | NR | MBZ5660623.1 | 2081523 | g26875 | i0 | 43.8 | 0.757894736842105 | 48 | 23 | 69.5 | 1 | 161 | 30 | 22 | 69 | MBZ5660623.1 hypothetical protein [Terriglobia bacterium] | diamond | 144 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 32611409 | 32611409 | PRJNA683902_S_NODE_38460_length_153_cov_2.577586_g38016_i0 | PRJNA683902 | 38460 | 153 | 2.577586 | 3.94370658 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 71.2 | 9.85e-13 | NR | HEX7152041.1 | 2651171 | g38016 | i0 | 69.6 | 1.76470588235294 | 46 | 14 | 90.2 | 0 | 144 | 7 | 2666 | 2711 | HEX7152041.1 PKD domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 270 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium |
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);;