RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA781196" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA781196 · 3 ✖

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
29011811 29011811 PRJNA781196_P_NODE_62608_length_245_cov_0.906977_g62231_i0 PRJNA781196 62608 245 0.906977 2.22209365 uncultured Gemmatimonadota bacterium 203437 Bacteria Bacteria 43.1 0.0281   NR CAA9314444.1 203437 g62231 i0 43.8 0.783673469387755 64 30 73.5 2 203 24 404 465 CAA9314444.1 MAG: hypothetical protein AVDCRST_MAG68-1478, partial [uncultured Gemmatimonadota bacterium] diamond 192 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         uncultured Gemmatimonadota bacterium
30969922 30969922 PRJNA781196_P_NODE_33634_length_305_cov_1.137931_g33257_i0 PRJNA781196 33634 305 1.137931 3.47068955 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 95.5 2.32e-21   NR HEX2217275.1 2448054 g33257 i0 47.1 1.00327868852459 102 53 99.3 1 2 304 135 236 HEX2217275.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium] diamond 306 95.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32370984 32370984 PRJNA781196_P_NODE_47419_length_260_cov_1.042781_g47042_i0 PRJNA781196 47419 260 1.042781 2.7112306 FCB group 1783270 Bacteria Bacteria 95.1 1.73e-20   NR MES2123634.1 2026742 g47042 i0 59.8 6.11538461538461 82 23 85.4 3 36 257 533 612 MES2123634.1 choice-of-anchor B family protein [Gemmatimonadota bacterium] diamond 1590 95.9 0.991657977059437 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);;