RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB50332" 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

bioproject 1

  • PRJEB50332 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28201937 28201937 PRJEB50332_P_NODE_16046_length_205_cov_0.902778_g15964_i0 PRJEB50332 16046 205 0.902778 1.8506949 Herpetosiphonaceae bacterium 2720503 Bacteria Bacteria 139 5.24e-38   NR HEY1016252.1 2720503 g15964 i0 89.6 0.980487804878049 67 7 98 0 3 203 285 351 HEY1016252.1 ABC transporter permease subunit [Herpetosiphonaceae bacterium] diamond 201 139 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae   Herpetosiphonaceae bacterium
29307176 29307176 PRJEB50332_P_NODE_529_length_743_cov_1.032258_g459_i0 PRJEB50332 529 743 1.032258 7.6696769400000004 Anaerolineae bacterium 2052143 Bacteria Bacteria 46.2 0.0211   NR MCX7707660.1 2052143 g459 i0 33.3 0.399730820995962 99 45 35.5 3 436 699 55 143 MCX7707660.1 hypothetical protein [Anaerolineae bacterium] diamond 297 46.2 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
31354043 31354043 PRJEB50332_P_NODE_12216_length_212_cov_1.715232_g12134_i0 PRJEB50332 12216 212 1.715232 3.63629184 Bacteria 2 Bacteria Bacteria 103 1.63e-24   NR HDQ35038.1 2026724 g12134 i0 65.2 3.90566037735849 69 24 97.6 0 4 210 293 361 HDQ35038.1 winged helix DNA-binding domain-containing protein [Chloroflexota bacterium] diamond 828 103 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31676912 31676912 PRJEB50332_P_NODE_1497_length_452_cov_2.892583_g1416_i0 PRJEB50332 1497 452 2.892583 13.07447516 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 70.5 3.41e-12   NR MDO9333994.1 2026733 g1416 i0 90 0.265486725663717 40 3 25.9 1 3 119 96 135 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 120 70.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
31961644 31961644 PRJEB50332_P_NODE_16438_length_204_cov_1.615385_g16356_i0 PRJEB50332 16438 204 1.615385 3.2953854 Anaerolineales bacterium 2073117 Bacteria Bacteria 42.7 0.0212   NR MBE7557214.1 2073117 g16356 i0 48.8 1.20588235294118 41 19 60.3 2 13 135 15 53 MBE7557214.1 hypothetical protein [Anaerolineales bacterium] diamond 246 42.7 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
32183312 32183312 PRJEB50332_P_NODE_4478_length_284_cov_1.165919_g4396_i0 PRJEB50332 4478 284 1.165919 3.31120996 Anaerolineales bacterium 2073117 Bacteria Bacteria 82 1.87e-16   NR NIS83154.1 2073117 g4396 i0 42.6 1.98591549295775 94 54 99.3 0 1 282 134 227 NIS83154.1 slipin family protein [Anaerolineales bacterium] diamond 564 82 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales 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);;