contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1677746 | 1677746 | PRJNA382357_P_NODE_147302_length_205_cov_3.861111_g146563_i0 | PRJNA382357 | 147302 | 205 | 3.861111 | 7.91527755 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 78.7 | 2.95e-10 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g146563 | i0 | 88.235 | 2.31219512195122 | 68 | 4 | 63 | 3 | 1 | 66 | 770718 | 770783 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 474 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 2349606 | 2349606 | PRJNA382357_P_NODE_100322_length_242_cov_1.077348_g99583_i0 | PRJNA382357 | 100322 | 242 | 1.077348 | 2.60718216 | Bacteria | 2 | Bacteria | Bacteria | 370 | 5.3e-98 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g99583 | i0 | 94.583 | 497.239669421488 | 240 | 12 | 99 | 1 | 3 | 242 | 851011 | 850773 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 120332 | 372 | 0.99462365591397806 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 8057596 | 8057596 | PRJNA382357_P_NODE_74087_length_276_cov_1.837209_g73348_i0 | PRJNA382357 | 74087 | 276 | 1.837209 | 5.07069684 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 159 | 1.4499999999999999e-34 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g73348 | i0 | 86.275 | 2.21376811594203 | 153 | 14 | 54 | 7 | 110 | 258 | 741096 | 741245 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 611 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 9332591 | 9332591 | PRJNA382357_P_NODE_84648_length_260_cov_4.512563_g83909_i0 | PRJNA382357 | 84648 | 260 | 4.512563 | 11.7326638 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 84.2 | 8.4e-12 | NTclustered | gi|1958075319|gb|CP064995.1| | 2026720 | g83909 | i0 | 83.516 | 0.35 | 91 | 13 | 35 | 2 | 137 | 226 | 321517 | 321606 | Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome | blastn | 91 | 84.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 14433169 | 14433169 | PRJNA382357_P_NODE_77312_length_271_cov_1.319048_g76573_i0 | PRJNA382357 | 77312 | 271 | 1.319048 | 3.57462008 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 78.7 | 4.1e-10 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g76573 | i0 | 100 | 0.623616236162362 | 42 | 0 | 25 | 0 | 226 | 267 | 703128 | 703169 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 169 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 16980481 | 16980481 | PRJNA382357_P_NODE_158514_length_198_cov_2.686131_g157775_i0 | PRJNA382357 | 158514 | 198 | 2.686131 | 5.31853938 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 139 | 1.2799999999999999e-28 | NTclustered | gi|2874253873|emb|OY969928.1| | 179883 | g157775 | i0 | 89.815 | 23.0858585858586 | 108 | 11 | 55 | 0 | 1 | 108 | 598617 | 598724 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1 | blastn | 4571 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 16981242 | 16981242 | PRJNA382357_P_NODE_4694_length_904_cov_6.502966_g4089_i0 | PRJNA382357 | 4694 | 904 | 6.502966 | 58.78681264 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 785 | 0 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g4089 | i0 | 89.1 | 2.88716814159292 | 633 | 68 | 99 | 1 | 239 | 870 | 547008 | 547640 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 2610 | 785 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 18255639 | 18255639 | PRJNA382357_P_NODE_60755_length_301_cov_1.625000_g60016_i0 | PRJNA382357 | 60755 | 301 | 1.625 | 4.89125 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 102 | 2.74e-17 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g60016 | i0 | 98.276 | 0.568106312292359 | 58 | 1 | 19 | 0 | 244 | 301 | 748075 | 748018 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 171 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 19530329 | 19530329 | PRJNA382357_P_NODE_82816_length_263_cov_1.509901_g82077_i0 | PRJNA382357 | 82816 | 263 | 1.509901 | 3.97103963 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 86.1 | 2.37e-12 | NTclustered | gi|1805658607|gb|CP047918.1| | 2572087 | g82077 | i0 | 82.474 | 0.847908745247148 | 97 | 17 | 37 | 0 | 1 | 97 | 771365 | 771269 | Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome | blastn | 223 | 86.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 23356572 | 23356572 | PRJNA382357_P_NODE_82479_length_263_cov_7.594059_g81740_i0 | PRJNA382357 | 82479 | 263 | 7.594059 | 19.97237517 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 287 | 6.05e-73 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g81740 | i0 | 94.149 | 291.456273764259 | 188 | 11 | 71 | 0 | 35 | 222 | 221023 | 220836 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 76653 | 287 | 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);;