RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA811725", 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

  • PRJNA811725 · 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
26959161 26959161 PRJNA811725_P_NODE_23842_length_310_cov_4.544304_g23596_i0 PRJNA811725 23842 310 4.544304 14.0873424 Anaerolineae bacterium 2052143 Bacteria Bacteria 63.5 3.55e-9   NR MBZ0300459.1 2052143 g23596 i0 59.2 0.474193548387097 49 20 47.4 0 149 3 147 195 MBZ0300459.1 hypothetical protein [Anaerolineae bacterium] diamond 147 63.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28601845 28601845 PRJNA811725_P_NODE_24067_length_310_cov_3.438819_g23821_i0 PRJNA811725 24067 310 3.438819 10.6603389 Chloroflexota bacterium 2026724 Bacteria Bacteria 85.9 3.21e-17   NR MEW5958930.1 2026724 g23821 i0 71.4 2.83548387096774 49 14 47.4 0 149 3 20 68 MEW5958930.1 DUF4159 domain-containing protein [Chloroflexota bacterium] diamond 879 85.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28664961 28664961 PRJNA811725_P_NODE_11447_length_440_cov_2.305177_g11203_i0 PRJNA811725 11447 440 2.305177 10.1427788 Chloroflexia bacterium 2448782 Bacteria Bacteria 113 1.68e-27   NR MBA2468861.1 2448782 g11203 i0 86.2 0.934090909090909 65 9 44.3 0 245 439 4 68 MBA2468861.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Chloroflexia bacterium] diamond 411 113 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
29391211 29391211 PRJNA811725_P_NODE_1609_length_1018_cov_17.819048_g1460_i0 PRJNA811725 1609 1018 17.819048 181.39790864 Ktedonobacter sp. 1932716 Bacteria Bacteria 184 7.399999999999998e-54   NR HCI82730.1 1932716 g1460 i0 56.7 0.442043222003929 150 65 44.2 0 684 235 1 150 HCI82730.1 GNAT family N-acetyltransferase [Ktedonobacter sp.] diamond 450 184 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae Ktedonobacter Ktedonobacter sp.
29548767 29548767 PRJNA811725_P_NODE_24450_length_310_cov_2.628692_g24204_i0 PRJNA811725 24450 310 2.628692 8.1489452 Chloroflexota bacterium 2026724 Bacteria Bacteria 80.1 3.62e-16   NR HEU5315871.1 2026724 g24204 i0 80 0.890322580645161 45 9 43.5 0 308 174 141 185 HEU5315871.1 IS5 family transposase [Chloroflexota bacterium] diamond 276 80.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31128165 31128165 PRJNA811725_P_NODE_40855_length_243_cov_0.905882_g40609_i0 PRJNA811725 40855 243 0.905882 2.20129326 Anaerolineales bacterium 2073117 Bacteria Bacteria 62.4 1.49e-9   NR HKZ70725.1 2073117 g40609 i0 66 0.580246913580247 47 16 58 0 222 82 3 49 HKZ70725.1 YncE family protein [Anaerolineales bacterium] diamond 141 62.4 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);;