RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 8 ✖

analysis 1

  • blastn · 8 ✖

tax_clade 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
4137494 4137494 PRJNA1160211_S_NODE_61004_length_544_cov_40.645435_g59819_i0 PRJNA1160211 61004 544 40.645435 221.1111664 Fretibacterium fastidiosum 651822 Bacteria Bacteria 556 9.299999999999999e-154   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g59819 i0 86.588 77.6213235294118 507 65 96 3 39 544 70155 69651 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 42226 556 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
7963837 7963837 PRJNA1160211_S_NODE_56007_length_558_cov_13.435052_g54830_i0 PRJNA1160211 56007 558 13.435052 74.96759016 Fretibacterium fastidiosum 651822 Bacteria Bacteria 922 0   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g54830 i0 97.94 52.5627240143369 534 8 95 2 5 535 2281592 2282125 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 29330 922 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
15066600 15066600 PRJNA1160211_S_NODE_5292_length_935_cov_22.890951_g4711_i0 PRJNA1160211 5292 935 22.890951 214.03039185 Aminithiophilus 3029078 Bacteria Bacteria 78.7 1.56e-9   NTclustered gi|2041259188|gb|CP074691.1| 2268202 g4711 i0 91.379 0.777540106951872 58 4 6 1 369 425 1570370 1570427 Synergistota bacterium strain L-13 chromosome, complete genome blastn 727 78.7 1 Bacteria   Thermotogati Synergistota         Synergistota bacterium
15611999 15611999 PRJNA1160211_S_NODE_138413_length_392_cov_1.514107_g137181_i0 PRJNA1160211 138413 392 1.514107 5.93529944 Pyramidobacter sp. YE332 3068894 Bacteria Bacteria 411 5.369999999999999e-110   NTclustered gi|2601021520|gb|CP133038.1| 3068894 g137181 i0 86.968 73.2831632653061 376 35 94 10 23 390 1863252 1862883 Pyramidobacter sp. YE332 chromosome, complete genome blastn 28727 411 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter sp. YE332
15612212 15612212 PRJNA1160211_S_NODE_165353_length_353_cov_10.060714_g164120_i0 PRJNA1160211 165353 353 10.060714 35.51432042 Fretibacterium fastidiosum 651822 Bacteria Bacteria 296 1.4e-75   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g164120 i0 84.098 186.235127478754 327 31 91 14 3 324 68305 68615 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 65741 296 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
21987623 21987623 PRJNA1160211_S_NODE_89798_length_477_cov_19.210396_g88575_i0 PRJNA1160211 89798 477 19.210396 91.63358892 Fretibacterium fastidiosum 651822 Bacteria Bacteria 800 0   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g88575 i0 99.103 205.077568134172 446 3 93 1 10 454 69070 69515 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 97822 800 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
23262321 23262321 PRJNA1160211_S_NODE_260279_length_253_cov_9.966667_g259046_i0 PRJNA1160211 260279 253 9.966667 25.21566751 Fretibacterium fastidiosum 651822 Bacteria Bacteria 409 1.18e-109   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g259046 i0 98.696 28.4940711462451 230 3 91 0 1 230 69942 70171 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 7209 409 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
24535062 24535062 PRJNA1160211_S_NODE_115860_length_428_cov_7.295775_g114631_i0 PRJNA1160211 115860 428 7.295775 31.225917 Cloacibacillus porcorum 1197717 Bacteria Bacteria 431 4.539999999999999e-116   NTclustered gi|1050315908|gb|CP016757.1| 1197717 g114631 i0 85.888 83.0560747663551 411 51 95 6 1 406 3429126 3429534 Cloacibacillus porcorum strain CL-84 chromosome, complete genome blastn 35548 431 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Cloacibacillus Cloacibacillus porcorum

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