RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 10 ✖

bioproject 1

  • PRJNA695273 · 10 ✖

analysis 1

  • blastn · 10 ✖

tax_kingdom 0

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
2457646 2457646 PRJNA695273_P_NODE_19922_length_629_cov_2.742806_g19173_i0 PRJNA695273 19922 629 2.742806 17.25224974 Bacteria 2 Bacteria Bacteria 979 0   NTclustered gi|563353835|gb|CP006915.1| 1394711 g19173 i0 95.581 96.7742448330684 611 27 97 0 1 611 448316 448926 Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome blastn 60871 979 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium RAAC3_TM7_1
3229858 3229858 PRJNA695273_P_NODE_74603_length_319_cov_4.630081_g73845_i0 PRJNA695273 74603 319 4.630081 14.76995839 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 1619070 Bacteria Bacteria 381 3.359999999999999e-101   NTclustered gi|837350690|gb|CP011211.1| 1619070 g73845 i0 92.481 80.8275862068966 266 20 83 0 49 314 850128 849863 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome blastn 25784 381 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6286764 6286764 PRJNA695273_P_NODE_39465_length_432_cov_1.518106_g38707_i0 PRJNA695273 39465 432 1.518106 6.55821792 Candidatus Nanosynbacter 2093823 Bacteria Bacteria 704 0   NTclustered gi|1842055115|gb|CP040000.1| 713059 g38707 i0 96.698 274.689814814815 424 13 98 1 1 424 147024 146602 Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome blastn 118666 704 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
12156574 12156574 PRJNA695273_P_NODE_152210_length_243_cov_0.905882_g151452_i0 PRJNA695273 152210 243 0.905882 2.20129326 Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 2056494 Bacteria Bacteria 331 2.51e-86   NTclustered gi|1340357306|gb|CP025011.1| 2056494 g151452 i0 92.609 125.115226337449 230 17 95 0 14 243 1286759 1286988 Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 chromosome, complete genome blastn 30403 331 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20
15979204 15979204 PRJNA695273_P_NODE_115073_length_262_cov_2.444444_g114315_i0 PRJNA695273 115073 262 2.444444 6.40444328 candidate division SR1 bacterium RAAC1_SR1_1 1394709 Bacteria Bacteria 222 1.72e-53   NTclustered gi|563351663|gb|CP006913.1| 1394709 g114315 i0 83.539 11.7748091603053 243 35 92 5 3 242 126171 126411 Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome blastn 3085 222 1 Bacteria Bacteria candidate phyla   Candidatus Absconditibacteriota         candidate division SR1 bacterium RAAC1_SR1_1
16486079 16486079 PRJNA695273_P_NODE_64353_length_342_cov_1.144981_g63595_i0 PRJNA695273 64353 342 1.144981 3.91583502 Candidatus Nanosynbacter 2093823 Bacteria Bacteria 627 4.22e-175   NTclustered gi|1842065531|gb|CP040002.1| 713059 g63595 i0 99.708 135.619883040936 342 1 100 0 1 342 150303 150644 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 46382 627 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
17254311 17254311 PRJNA695273_P_NODE_112034_length_266_cov_1.435233_g111276_i0 PRJNA695273 112034 266 1.435233 3.81771978 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 217 8.149999999999999e-52   NTclustered gi|1950821269|gb|CP066696.1| 2026720 g111276 i0 81.786 8.20676691729323 280 32 100 12 1 266 820101 819827 Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome blastn 2183 217 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
17256353 17256353 PRJNA695273_P_NODE_5674_length_1291_cov_3.630542_g5153_i0 PRJNA695273 5674 1291 3.630542 46.87029722 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 1851 0   NTclustered gi|1950821269|gb|CP066696.1| 2026720 g5153 i0 92.544 277.101471727343 1301 81 100 15 1 1291 800895 799601 Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome blastn 357738 1851 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
19804458 19804458 PRJNA695273_P_NODE_162256_length_233_cov_2.756250_g161498_i0 PRJNA695273 162256 233 2.75625 6.4220625 Candidatus Mycosynbacter amalyticus 2665156 Bacteria Bacteria 342 1.0999999999999999e-89   NTclustered gi|1799615131|gb|CP045921.1| 2665156 g161498 i0 93.133 137.317596566524 233 16 100 0 1 233 220162 219930 Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome blastn 31995 342 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Mycosynbacter Candidatus Mycosynbacter amalyticus
22861107 22861107 PRJNA695273_P_NODE_98658_length_281_cov_1.480769_g97900_i0 PRJNA695273 98658 281 1.480769 4.16096089 Candidatus Saccharimonas 1331051 Bacteria Bacteria 121 7.000000000000001e-23   NTclustered gi|499052612|gb|CP005957.1| 1332188 g97900 i0 100 4.11032028469751 65 0 23 0 1 65 327034 327098 Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome blastn 1155 121 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales Candidatus Saccharimonadaceae Candidatus Saccharimonas Candidatus Saccharimonas aalborgensis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;