contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554400 | 554400 | PRJNA565584_P_NODE_112501_length_286_cov_2.370892_g111349_i0 | PRJNA565584 | 112501 | 286 | 2.370892 | 6.78075112 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 462 | 1.03e-125 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g111349 | i0 | 95.804 | 1 | 286 | 12 | 100 | 0 | 1 | 286 | 335679 | 335964 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 286 | 462 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 4383120 | 4383120 | PRJNA565584_P_NODE_170684_length_250_cov_2.288136_g169532_i0 | PRJNA565584 | 170684 | 250 | 2.288136 | 5.72034 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 407 | 4.1899999999999994e-109 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g169532 | i0 | 96 | 1 | 250 | 10 | 100 | 0 | 1 | 250 | 935406 | 935157 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 250 | 407 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 4383283 | 4383283 | PRJNA565584_P_NODE_180024_length_248_cov_2.274286_g178872_i0 | PRJNA565584 | 180024 | 248 | 2.274286 | 5.64022928 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 357 | 4.24e-94 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g178872 | i0 | 92.713 | 0.995967741935484 | 247 | 18 | 99 | 0 | 1 | 247 | 421490 | 421736 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 247 | 357 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 5659389 | 5659389 | PRJNA565584_P_NODE_169105_length_251_cov_0.865169_g167953_i0 | PRJNA565584 | 169105 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 459 | 1.1499999999999996e-124 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g167953 | i0 | 99.602 | 1 | 251 | 1 | 100 | 0 | 1 | 251 | 264019 | 263769 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 251 | 459 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 6933939 | 6933939 | PRJNA565584_P_NODE_187426_length_247_cov_0.885057_g186274_i0 | PRJNA565584 | 187426 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 167 | 7.64e-37 | NTclustered | gi|1805661181|gb|CP047921.1| | 713059 | g186274 | i0 | 79.253 | 4.39271255060729 | 241 | 48 | 97 | 2 | 2 | 241 | 247430 | 247191 | Candidatus Saccharibacteria bacterium oral taxon 488 strain FS05P-B chromosome, complete genome | blastn | 1085 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 9484330 | 9484330 | PRJNA565584_P_NODE_191988_length_246_cov_0.890173_g190836_i0 | PRJNA565584 | 191988 | 246 | 0.890173 | 2.18982558 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 185 | 2.1e-42 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g190836 | i0 | 80.645 | 356.487804878049 | 248 | 40 | 100 | 7 | 1 | 246 | 890690 | 890449 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 87696 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 10760861 | 10760861 | PRJNA565584_P_NODE_24289_length_633_cov_2.296429_g23156_i0 | PRJNA565584 | 24289 | 633 | 2.296429 | 14.53639557 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 71.3 | 1.74e-7 | NTclustered | gi|2814788338|emb|OY761159.2| | 2838779 | g23156 | i0 | 100 | 0.60347551342812 | 38 | 0 | 6 | 0 | 69 | 106 | 3588045 | 3588008 | MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1 | blastn | 382 | 71.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 13310073 | 13310073 | PRJNA565584_P_NODE_199811_length_244_cov_0.900585_g198659_i0 | PRJNA565584 | 199811 | 244 | 0.900585 | 2.1974274 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 135 | 2.1200000000000003e-27 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g198659 | i0 | 98.684 | 28.9959016393443 | 76 | 1 | 31 | 0 | 1 | 76 | 904486 | 904411 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 7075 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 14583167 | 14583167 | PRJNA565584_P_NODE_104112_length_292_cov_5.680365_g102960_i0 | PRJNA565584 | 104112 | 292 | 5.680365 | 16.5866658 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 468 | 2.27e-127 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g102960 | i0 | 95.548 | 1 | 292 | 13 | 100 | 0 | 1 | 292 | 27960 | 27669 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 292 | 468 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 14583331 | 14583331 | PRJNA565584_P_NODE_111672_length_287_cov_1.439252_g110520_i0 | PRJNA565584 | 111672 | 287 | 1.439252 | 4.13065324 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 531 | 2.799999999999999e-146 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g110520 | i0 | 100 | 1 | 287 | 0 | 100 | 0 | 1 | 287 | 800232 | 800518 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 287 | 531 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 18408275 | 18408275 | PRJNA565584_P_NODE_214835_length_241_cov_0.916667_g213683_i0 | PRJNA565584 | 214835 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 368 | 1.9e-97 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g213683 | i0 | 94.191 | 1 | 241 | 14 | 100 | 0 | 1 | 241 | 401224 | 400984 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 241 | 368 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 18409025 | 18409025 | PRJNA565584_P_NODE_50955_length_417_cov_0.988372_g49804_i0 | PRJNA565584 | 50955 | 417 | 0.988372 | 4.12151124 | Candidatus Southlakia epibionticum | 3043284 | Bacteria | Bacteria | 619 | 8.77e-173 | NTclustered | gi|2516687873|gb|CP124550.1| | 3043284 | g49804 | i0 | 93.525 | 126.280575539568 | 417 | 25 | 99 | 2 | 1 | 416 | 150939 | 151354 | Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome | blastn | 52659 | 619 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Southlakia | Candidatus Southlakia epibionticum | ||
| 19681952 | 19681952 | PRJNA565584_P_NODE_164316_length_253_cov_1.044444_g163164_i0 | PRJNA565584 | 164316 | 253 | 1.044444 | 2.64244332 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2621703606|emb|OY761465.1| | 2838779 | g163164 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 191 | 218 | 1862487 | 1862460 | MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 22233275 | 22233275 | PRJNA565584_P_NODE_207198_length_242_cov_2.603550_g206046_i0 | PRJNA565584 | 207198 | 242 | 2.60355 | 6.300591 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g206046 | i0 | 100 | 1 | 242 | 0 | 100 | 0 | 1 | 242 | 744639 | 744398 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 242 | 448 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 24780645 | 24780645 | PRJNA565584_P_NODE_109800_length_288_cov_1.534884_g108648_i0 | PRJNA565584 | 109800 | 288 | 1.534884 | 4.42046592 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 527 | 3.63e-145 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g108648 | i0 | 99.653 | 133.3125 | 288 | 1 | 100 | 0 | 1 | 288 | 222279 | 221992 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 38394 | 527 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus |
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);;