RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA682774", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA682774 · 4 ✖

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
28029784 28029784 PRJNA682774_P_NODE_485_length_621_cov_1.543796_g457_i0 PRJNA682774 485 621 1.543796 9.58697316 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 59.3 2.5e-6   NR MXX57127.1 2026742 g457 i0 46.7 0.579710144927536 60 32 29 0 614 435 744 803 MXX57127.1 hypothetical protein [Gemmatimonadota bacterium] diamond 360 59.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28282051 28282051 PRJNA682774_P_NODE_3966_length_250_cov_0.881356_g3937_i0 PRJNA682774 3966 250 0.881356 2.20339 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 156 5.24e-45   NR MCH8145609.1 2026742 g3937 i0 94 0.996 83 5 99.6 0 249 1 113 195 MCH8145609.1 alpha/beta hydrolase [Gemmatimonadota bacterium] diamond 249 156 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29418804 29418804 PRJNA682774_P_NODE_3409_length_253_cov_0.866667_g3380_i0 PRJNA682774 3409 253 0.866667 2.19266751 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 172 1.6399999999999997e-52   NR MCH7775244.1 2026742 g3380 i0 95.2 0.99604743083004 84 4 99.6 0 253 2 31 114 MCH7775244.1 OsmC family protein [Gemmatimonadota bacterium] diamond 252 172 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30555862 30555862 PRJNA682774_P_NODE_1853_length_329_cov_1.992188_g1824_i0 PRJNA682774 1853 329 1.992188 6.55429852 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 48.1 9.22e-4   NR MBK8060768.1 2026742 g1824 i0 33.3 0.765957446808511 84 53 73.9 1 281 39 142 225 MBK8060768.1 substrate-binding domain-containing protein [Gemmatimonadota bacterium] diamond 252 48.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;