RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB17675", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_clade 1

  • delta/epsilon subdivisions · 7 ✖

bioproject 1

  • PRJEB17675 · 7 ✖

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
27690518 27690518 PRJEB17675_P_NODE_12384_length_239_cov_1.166667_g12080_i0 PRJEB17675 12384 239 1.166667 2.78833413 Bacteria 2 Bacteria Bacteria 61.6 8.02e-9   NR OGQ89419.1 1797895 g12080 i0 40.5 1.98326359832636 79 44 99.2 3 238 2 1162 1237 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 474 61.6 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28037577 28037577 PRJEB17675_P_NODE_21585_length_165_cov_2.761538_g21281_i0 PRJEB17675 21585 165 2.761538 4.5565377 Bacteria 2 Bacteria Bacteria 48.5 1.23e-4   NR OGQ89419.1 1797895 g21281 i0 47.8 1.67272727272727 46 22 83.6 1 153 16 1188 1231 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 276 48.5 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31038099 31038099 PRJEB17675_P_NODE_18875_length_181_cov_1.095890_g18571_i0 PRJEB17675 18875 181 1.09589 1.9835609 Bacteria 2 Bacteria Bacteria 45.8 0.00137   NR OGQ89419.1 1797895 g18571 i0 44.8 2.75138121546961 58 28 96.1 2 175 2 1168 1221 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 498 45.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31195384 31195384 PRJEB17675_P_NODE_3375_length_535_cov_1.758000_g3095_i0 PRJEB17675 3375 535 1.758 9.4053 Bacteria 2 Bacteria Bacteria 95.1 5.21e-19   NR OGQ89419.1 1797895 g3095 i0 40.8 2.4785046728972 125 67 67.9 3 376 14 1130 1251 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 1326 95.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31322190 31322190 PRJEB17675_P_NODE_11715_length_248_cov_1.502347_g11411_i0 PRJEB17675 11715 248 1.502347 3.72582056 Bacteria 2 Bacteria Bacteria 65.9 2.92e-10   NR OGQ89419.1 1797895 g11411 i0 41.5 1.98387096774194 82 42 99.2 3 246 1 1196 1271 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 492 65.9 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
32208100 32208100 PRJEB17675_P_NODE_8258_length_315_cov_1.428571_g7954_i0 PRJEB17675 8258 315 1.428571 4.49999865 Bacteria 2 Bacteria Bacteria 72.8 2.62e-12   NR OGQ89419.1 1797895 g7954 i0 47.5 1.52380952380952 80 36 74.3 4 309 76 1207 1282 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 480 72.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
32871001 32871001 PRJEB17675_P_NODE_9080_length_295_cov_1.846154_g8776_i0 PRJEB17675 9080 295 1.846154 5.4461543 Bacteria 2 Bacteria Bacteria 85.1 9.44e-17   NR OGQ89419.1 1797895 g8776 i0 41.1 1.93220338983051 95 54 95.6 2 294 13 1171 1264 OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 570 85.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15

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