RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB80557", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 6 ✖

tax_kingdom 1

  • Bacillati · 6 ✖

bioproject 1

  • PRJEB80557 · 6 ✖

analysis 1

tax_clade 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
7791431 7791431 PRJEB80557_S_NODE_3027_length_464_cov_3.248193_g2633_i0 PRJEB80557 3027 464 3.248193 15.07161552 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 90.5 8.34e-20   NR MFA5604492.1 2026733 g2633 i0 70.2 5.22413793103448 57 17 36.9 0 455 285 75 131 MFA5604492.1 IS200/IS605 family transposase [Dehalococcoidales bacterium] diamond 2424 90.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
27539897 27539897 PRJEB80557_S_NODE_1324_length_673_cov_4.448718_g947_i0 PRJEB80557 1324 673 4.448718 29.93987214 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 89.4 3.64e-17   NR MDP6783155.1 2026734 g947 i0 86 0.557206537890045 43 6 19.2 0 3 131 175 217 MDP6783155.1 4Fe-4S binding protein [Dehalococcoidia bacterium] diamond 375 89.4 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
29395419 29395419 PRJEB80557_S_NODE_11169_length_275_cov_1.309735_g10773_i0 PRJEB80557 11169 275 1.309735 3.60177125 FCB group 1783270 Bacteria Bacteria 199 3.11e-61   NR HQP46915.1 2017390 g10773 i0 96.7 2.97818181818182 91 3 99.3 0 275 3 101 191 HQP46915.1 glycoside hydrolase family 140 protein [Flexilinea sp.] diamond 819 200 0.995 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Flexilinea Flexilinea sp.
30666090 30666090 PRJEB80557_S_NODE_13053_length_257_cov_1.485577_g12657_i0 PRJEB80557 13053 257 1.485577 3.81793289 Chloroflexota bacterium 2026724 Bacteria Bacteria 173 4.36e-51   NR HEX2326864.1 2026724 g12657 i0 98.8 0.992217898832685 85 1 99.2 0 2 256 266 350 HEX2326864.1 ATP phosphoribosyltransferase [Chloroflexota bacterium] diamond 255 173 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31645949 31645949 PRJEB80557_S_NODE_4157_length_412_cov_1.991736_g3761_i0 PRJEB80557 4157 412 1.991736 8.20595232 Herpetosiphonaceae bacterium 2720503 Bacteria Bacteria 228 8.19e-71   NR HEX6289334.1 2720503 g3761 i0 73.7 0.997572815533981 137 36 99.8 0 411 1 231 367 HEX6289334.1 hypothetical protein [Herpetosiphonaceae bacterium] diamond 411 228 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae   Herpetosiphonaceae bacterium
32405495 32405495 PRJEB80557_S_NODE_30599_length_175_cov_1.634921_g30203_i0 PRJEB80557 30599 175 1.634921 2.86111175 Chloroflexota bacterium 2026724 Bacteria Bacteria 84.7 1.41e-17   NR MFC2038736.1 2026724 g30203 i0 75 1.86857142857143 52 13 89.1 0 20 175 195 246 MFC2038736.1 indolepyruvate ferredoxin oxidoreductase subunit alpha [Chloroflexota bacterium] diamond 327 84.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;