RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA741997" 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

  • PRJNA741997 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
12677698 12677698 PRJNA741997_P_NODE_27430_length_421_cov_1.603448_g26310_i0 PRJNA741997 27430 421 1.603448 6.75051608 Fibrobacter 832 Bacteria Bacteria 154 1.27e-41   NR NLL12130.1 35828 g26310 i0 66.7 4.85273159144893 111 35 79.1 1 339 7 6 114 NLL12130.1 UDP-glucose 6-dehydrogenase [Fibrobacter sp.] diamond 2043 154 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
22398981 22398981 PRJNA741997_P_NODE_53138_length_294_cov_2.411765_g52018_i0 PRJNA741997 53138 294 2.411765 7.0905891 Candidatus Fibrimonadales bacterium 2604144 Bacteria Bacteria 149 1.4099999999999999e-40   NR MCL2282138.1 2604144 g52018 i0 71.6 12.6122448979592 95 27 96.9 0 290 6 185 279 MCL2282138.1 adenosylhomocysteinase [Candidatus Fibrimonadales bacterium] diamond 3708 149 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Candidatus Fibrimonadales     Candidatus Fibrimonadales bacterium
26735630 26735630 PRJNA741997_P_NODE_78941_length_247_cov_0.885057_g77821_i0 PRJNA741997 78941 247 0.885057 2.18609079 Fibrobacter sp. 35828 Bacteria Bacteria 78.6 9.47e-15   NR NLP03413.1 35828 g77821 i0 50.7 5.21052631578947 67 33 81.4 0 232 32 383 449 NLP03413.1 mucoidy inhibitor MuiA family protein [Fibrobacter sp.] diamond 1287 78.6 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
27305503 27305503 PRJNA741997_P_NODE_15343_length_610_cov_1.595903_g14243_i0 PRJNA741997 15343 610 1.595903 9.7350083 Chitinivibrionales bacterium 2663014 Bacteria Bacteria 208 2.36e-63   NR MBD3419113.1 2663014 g14243 i0 49.8 0.998360655737705 203 100 98.9 1 7 609 82 284 MBD3419113.1 phospholipase [Chitinivibrionales bacterium] diamond 609 208 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia Chitinivibrionales     Chitinivibrionales bacterium
32434087 32434087 PRJNA741997_P_NODE_41479_length_337_cov_1.719697_g40359_i0 PRJNA741997 41479 337 1.719697 5.79537889 FCB group 1783270 Bacteria Bacteria 57 1.04e-6   NR NLP03958.1 35828 g40359 i0 56 4.42433234421365 50 21 44.5 1 181 330 4 52 NLP03958.1 phosphoglycerate kinase [Fibrobacter sp.] diamond 1491 57 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter 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);;