RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA998413 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
8632312 8632312 PRJNA998413_S_NODE_7587_length_242_cov_1.871508_g7556_i0 PRJNA998413 7587 242 1.871508 4.52904936 Flectobacillus roseus 502259 Bacteria Bacteria 156 4.51e-43   NR WP_283346397.1 502259 g7556 i0 100 0.991735537190083 80 0 99.2 0 242 3 381 460 WP_283346397.1 dihydroxy-acid dehydratase [Flectobacillus roseus] diamond 240 156 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus roseus
28605609 28605609 PRJNA998413_S_NODE_12307_length_212_cov_1.114094_g12276_i0 PRJNA998413 12307 212 1.114094 2.36187928 Petrimonas sp. 2023866 Bacteria Bacteria 79.7 8.69e-16   NR MDD3787514.1 2023866 g12276 i0 71.7 0.849056603773585 60 13 84.9 1 184 5 1 56 MDD3787514.1 TIM barrel protein [Petrimonas sp.] diamond 180 79.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Dysgonomonadaceae Petrimonas Petrimonas sp.
30626696 30626696 PRJNA998413_S_NODE_11073_length_216_cov_1.313725_g11042_i0 PRJNA998413 11073 216 1.313725 2.837646 Prevotella sp. tc2-28 1761888 Bacteria Bacteria 130 2.49e-34   NR WP_091958264.1 1761888 g11042 i0 87.3 7.90277777777778 71 9 98.6 0 215 3 9 79 WP_091958264.1 aminopeptidase C [Prevotella sp. tc2-28] diamond 1707 130 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp. tc2-28
32049556 32049556 PRJNA998413_S_NODE_11778_length_214_cov_0.887417_g11747_i0 PRJNA998413 11778 214 0.887417 1.89907238 Saprospiraceae bacterium 2202734 Bacteria Bacteria 42.7 0.0267   NR MBX2872287.1 2202734 g11747 i0 31.5 0.757009345794392 54 37 75.7 0 34 195 1077 1130 MBX2872287.1 carboxypeptidase-like regulatory domain-containing protein [Saprospiraceae bacterium] diamond 162 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
32650054 32650054 PRJNA998413_S_NODE_12420_length_212_cov_0.899329_g12389_i0 PRJNA998413 12420 212 0.899329 1.90657748 Bacteroidales bacterium 2030927 Bacteria Bacteria 109 1.16e-29   NR NLY23810.1 2030927 g12389 i0 89.8 2.50471698113208 59 6 83.5 0 1 177 14 72 NLY23810.1 hypothetical protein [Bacteroidales bacterium] diamond 531 109 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32902139 32902139 PRJNA998413_S_NODE_12060_length_213_cov_0.893333_g12029_i0 PRJNA998413 12060 213 0.893333 1.90279929 Bacteroidales bacterium 2030927 Bacteria Bacteria 45.8 0.00197   NR MFA6199038.1 2030927 g12029 i0 40.7 0.830985915492958 59 35 83.1 0 36 212 240 298 MFA6199038.1 hypothetical protein [Bacteroidales bacterium] diamond 177 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium

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