RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA999747 · 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
26646395 26646395 PRJNA999747_S_NODE_1881_length_220_cov_3.518519_g1849_i0 PRJNA999747 1881 220 3.518519 7.7407418 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 95.5 1.1199999999999999e-23   NR NOZ88117.1 2026735 g1849 i0 60.6 2.89090909090909 71 28 96.8 0 214 2 2 72 NOZ88117.1 RNA-binding protein [Deltaproteobacteria bacterium] diamond 636 95.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29584097 29584097 PRJNA999747_S_NODE_1990_length_215_cov_3.576087_g1958_i0 PRJNA999747 1990 215 3.576087 7.68858705 Porphyromonas gingivalis F 837 Bacteria Bacteria 78.2 2.56e-17   NR ERJ68952.1 1227271 g1958 i0 100 3 35 0 48.8 0 110 214 1 35 ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570] diamond 645 78.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas gingivalis
30437540 30437540 PRJNA999747_S_NODE_1993_length_215_cov_2.869565_g1961_i0 PRJNA999747 1993 215 2.869565 6.16956475 Mangrovibacterium diazotrophicum 1261403 Bacteria Bacteria 42 0.0498   NR WP_170154523.1 1261403 g1961 i0 36.4 0.92093023255814 66 40 92.1 1 1 198 92 155 WP_170154523.1 G8 domain-containing protein [Mangrovibacterium diazotrophicum] diamond 198 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Marinilabiliales Prolixibacteraceae Mangrovibacterium Mangrovibacterium diazotrophicum
30664276 30664276 PRJNA999747_S_NODE_2253_length_204_cov_2.473988_g2221_i0 PRJNA999747 2253 204 2.473988 5.04693552 Prevotellaceae 171552 Bacteria Bacteria 43.9 0.00479   NR EFC67102.1 575615 g2221 i0 59 2.35294117647059 39 16 57.4 0 204 88 56 94 EFC67102.1 LOW QUALITY PROTEIN: hypothetical protein HMPREF0670_02906, partial [Prevotella sp. oral taxon 317 str. F0108] diamond 480 44.3 0.99097065462754 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp. oral taxon 317
32492776 32492776 PRJNA999747_S_NODE_2679_length_190_cov_1.729560_g2647_i0 PRJNA999747 2679 190 1.72956 3.286164 Bacteroidota bacterium 1898104 Bacteria Bacteria 43.5 0.00894   NR MEI9917451.1 1898104 g2647 i0 43.6 0.868421052631579 55 29 83.7 2 169 11 44 98 MEI9917451.1 DUF4114 domain-containing protein [Bacteroidota bacterium] diamond 165 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32618875 32618875 PRJNA999747_S_NODE_2600_length_192_cov_2.919255_g2568_i0 PRJNA999747 2600 192 2.919255 5.6049696 Novosphingobium sp. 1874826 Bacteria Bacteria 57 1.73e-7   NR MCK9544286.1 1874826 g2568 i0 42.6 0.84375 54 31 84.4 0 164 3 158 211 MCK9544286.1 peroxidase family protein [Novosphingobium sp.] diamond 162 57 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium 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);;