RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA534016" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA534016 · 5 ✖

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
28246154 28246154 PRJNA534016_P_NODE_12906_length_256_cov_1.683060_g12816_i0 PRJNA534016 12906 256 1.68306 4.3086336 Anaerolineae bacterium 2052143 Bacteria Bacteria 43.1 0.00549   NR NLT42736.1 2052143 g12816 i0 47.6 0.4921875 42 20 46.9 1 171 52 19 60 NLT42736.1 hypothetical protein [Anaerolineae bacterium] diamond 126 43.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28450903 28450903 PRJNA534016_P_NODE_9786_length_280_cov_3.531401_g9696_i0 PRJNA534016 9786 280 3.531401 9.8879228 Bacteria 2 Bacteria Bacteria 116 8.439999999999998e-30   NR MFN8595148.1 2052143 g9696 i0 61.3 2.93571428571429 93 33 99.6 2 1 279 157 246 MFN8595148.1 2-oxo acid dehydrogenase subunit E2 [Anaerolineae bacterium] diamond 822 116 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29666850 29666850 PRJNA534016_P_NODE_1090_length_790_cov_2.417015_g1012_i0 PRJNA534016 1090 790 2.417015 19.0944185 Chloroflexota bacterium 2026724 Bacteria Bacteria 53.5 4.22e-4   NR MDP9369659.1 2026724 g1012 i0 36.4 0.375949367088608 99 53 36.5 3 790 503 179 270 MDP9369659.1 PKD domain-containing protein [Chloroflexota bacterium] diamond 297 53.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30488583 30488583 PRJNA534016_P_NODE_9673_length_281_cov_3.649038_g9583_i0 PRJNA534016 9673 281 3.649038 10.25379678 Anaerolineales bacterium 2073117 Bacteria Bacteria 95.5 1.38e-21   NR MEJ2711348.1 2073117 g9583 i0 55.4 0.98220640569395 92 31 98.2 1 6 281 6 87 MEJ2711348.1 2-oxo acid dehydrogenase subunit E2 [Anaerolineales bacterium] diamond 276 95.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
32052606 32052606 PRJNA534016_P_NODE_14138_length_250_cov_0.870056_g14048_i0 PRJNA534016 14138 250 0.870056 2.17514 Chloroflexota 200795 Bacteria Bacteria 98.6 5.38e-22   NR MFC1960784.1 2026724 g14048 i0 57.8 16.056 83 21 99.6 1 1 249 224 292 MFC1960784.1 aspartate aminotransferase family protein [Chloroflexota bacterium] diamond 4014 98.6 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);;