RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA631119" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631119 · 5 ✖

analysis 1

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
27428787 27428787 PRJNA631119_P_NODE_38983_length_241_cov_1.375000_g38865_i0 PRJNA631119 38983 241 1.375 3.31375 Fibrobacteria bacterium 2725311 Bacteria Bacteria 70.1 8.35e-12   NR MCB9496670.1 2725311 g38865 i0 48.6 0.871369294605809 70 31 87.1 2 219 10 170 234 MCB9496670.1 family 16 glycosylhydrolase [Fibrobacteria bacterium] diamond 210 70.1 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria bacterium
30049084 30049084 PRJNA631119_P_NODE_12131_length_356_cov_1.632509_g12013_i0 PRJNA631119 12131 356 1.632509 5.81173204 Chitinivibrionales bacterium 2663014 Bacteria Bacteria 47 0.00441   NR MBD3420842.1 2663014 g12013 i0 50 0.387640449438202 46 22 38.8 1 195 58 24 68 MBD3420842.1 hypothetical protein [Chitinivibrionales bacterium] diamond 138 47 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia Chitinivibrionales     Chitinivibrionales bacterium
30934057 30934057 PRJNA631119_P_NODE_37854_length_243_cov_0.900000_g37736_i0 PRJNA631119 37854 243 0.9 2.187 Fibrobacterota bacterium 2052160 Bacteria Bacteria 42.7 0.0345   NR MDQ3002623.1 2052160 g37736 i0 34.7 0.604938271604938 49 27 60.5 1 165 19 3 46 MDQ3002623.1 TatD family hydrolase [Fibrobacterota bacterium] diamond 147 42.7 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
31471535 31471535 PRJNA631119_P_NODE_29776_length_254_cov_2.314917_g29658_i0 PRJNA631119 29776 254 2.314917 5.87988918 Fibrobacter sp. 35828 Bacteria Bacteria 44.3 0.0121   NR NLG16332.1 35828 g29658 i0 52.6 0.909448818897638 38 18 44.9 0 254 141 508 545 NLG16332.1 hydroxylamine reductase [Fibrobacter sp.] diamond 231 44.3 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
31787462 31787462 PRJNA631119_P_NODE_14577_length_333_cov_1.530769_g14459_i0 PRJNA631119 14577 333 1.530769 5.09746077 Fibrobacteria bacterium 2725311 Bacteria Bacteria 110 4e-27   NR MBF0431778.1 2725311 g14459 i0 55.3 1.7027027027027 94 41 84.7 1 6 287 167 259 MBF0431778.1 TatD family hydrolase [Fibrobacteria bacterium] diamond 567 110 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria       Fibrobacteria 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);;