RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA846086", tax_phylum = "Synergistota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Synergistota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA846086 · 7 ✖

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
832882 832882 PRJNA846086_P_NODE_221_length_833_cov_2.605263_g166_i0 PRJNA846086 221 833 2.605263 21.70184079 Fretibacterium fastidiosum 651822 Bacteria Bacteria 1168 0   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g166 i0 92.188 573.501800720288 832 56 99 8 8 833 68618 69446 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 477727 1168 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
832913 832913 PRJNA846086_P_NODE_4181_length_246_cov_2.352601_g4115_i0 PRJNA846086 4181 246 2.352601 5.78739846 Fretibacterium fastidiosum 651822 Bacteria Bacteria 324 4.26e-84   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g4115 i0 90.65 535.439024390244 246 20 99 3 3 246 67852 68096 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 131718 324 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
5936076 5936076 PRJNA846086_P_NODE_5225_length_242_cov_0.911243_g5159_i0 PRJNA846086 5225 242 0.911243 2.20520806 Fretibacterium fastidiosum 651822 Bacteria Bacteria 283 7.1e-72   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g5159 i0 87.917 1.98347107438017 240 29 99 0 3 242 1101004 1100765 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 480 283 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
13586486 13586486 PRJNA846086_P_NODE_2251_length_273_cov_1.815000_g2185_i0 PRJNA846086 2251 273 1.815 4.95495 Fretibacterium fastidiosum 651822 Bacteria Bacteria 272 1.77e-68   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g2185 i0 84.871 59.6703296703297 271 39 99 2 4 273 69841 70110 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 16290 272 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
16135622 16135622 PRJNA846086_P_NODE_733_length_432_cov_1.334262_g667_i0 PRJNA846086 733 432 1.334262 5.76401184 Fretibacterium fastidiosum 651822 Bacteria Bacteria 481 4.49e-131   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g667 i0 86.946 45.7222222222222 429 54 99 2 1 428 69475 69902 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 19752 481 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
18684178 18684178 PRJNA846086_P_NODE_5615_length_241_cov_0.916667_g5549_i0 PRJNA846086 5615 241 0.916667 2.20916747 Fretibacterium fastidiosum 651822 Bacteria Bacteria 364 2.4499999999999993e-96   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g5549 i0 94.492 1.95850622406639 236 13 98 0 6 241 50422 50187 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 472 364 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
26706280 26706280 PRJNA846086_P_NODE_5261_length_242_cov_0.911243_g5195_i0 PRJNA846086 5261 242 0.911243 2.20520806 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 159 9.73e-45   NR WP_299299240.1 1678694 g5195 i0 95 0.991735537190083 80 4 99.2 0 241 2 125 204 WP_299299240.1 phosphomannomutase/phosphoglucomutase [uncultured Fretibacterium sp.] diamond 240 159 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.

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