RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1120203", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_clade 1

  • delta/epsilon subdivisions · 5 ✖

bioproject 1

  • PRJNA1120203 · 5 ✖

analysis 1

tax_phylum 0

tax_kingdom 0

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
5378598 5378598 PRJNA1120203_P_NODE_86425_length_248_cov_0.880000_g85409_i0 PRJNA1120203 86425 248 0.88 2.1824 Deltaproteobacteria bacterium RBG_16_5 2026735 Bacteria Bacteria 155 1.29e-46   NR OGP73884.1 1797841 g85409 i0 92.7 0.991935483870968 82 6 99.2 0 246 1 54 135 OGP73884.1 MAG: 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Deltaproteobacteria bacterium RBG_16_50_11] diamond 246 155 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_50_11
27501918 27501918 PRJNA1120203_P_NODE_82203_length_250_cov_0.870056_g81187_i0 PRJNA1120203 82203 250 0.870056 2.17514 Acidobacteriota 57723 Bacteria Bacteria 103 1.23e-24   NR OGP88816.1 1797839 g81187 i0 92.5 1.272 53 4 63.6 0 3 161 223 275 OGP88816.1 MAG: nitrate transport permease nrtB [Deltaproteobacteria bacterium RBG_16_48_10] diamond 318 104 0.990384615384615 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_48_10
28586138 28586138 PRJNA1120203_P_NODE_103127_length_242_cov_0.911243_g102111_i0 PRJNA1120203 103127 242 0.911243 2.20520806 SAR324 cluster bacterium 2024889 Bacteria Bacteria 149 5.2e-45   NR MEC8685660.1 2024889 g102111 i0 98.8 0.991735537190083 80 1 99.2 0 242 3 5 84 MEC8685660.1 GDSL-type esterase/lipase family protein [SAR324 cluster bacterium] diamond 240 149 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30164659 30164659 PRJNA1120203_P_NODE_93632_length_245_cov_0.895349_g92616_i0 PRJNA1120203 93632 245 0.895349 2.19360505 SAR324 cluster bacterium 2024889 Bacteria Bacteria 86.3 1.36e-19   NR MEC8844862.1 2024889 g92616 i0 97.6 2.05714285714286 42 1 51.4 0 1 126 79 120 MEC8844862.1 inositol monophosphatase family protein [SAR324 cluster bacterium] diamond 504 86.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30859959 30859959 PRJNA1120203_P_NODE_90554_length_247_cov_0.867816_g89538_i0 PRJNA1120203 90554 247 0.867816 2.14350552 Deltaproteobacteria bacterium ADurb.Bin 2026735 Bacteria Bacteria 79 3.7e-15   NR OQC48741.1 1852864 g89538 i0 74.5 1.71255060728745 47 12 57.1 0 105 245 3 49 OQC48741.1 MAG: putative xanthine dehydrogenase subunit A [Deltaproteobacteria bacterium ADurb.Bin026] diamond 423 79 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin026

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);;