RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB39269 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
3883171 3883171 PRJEB39269_P_NODE_22084_length_298_cov_3.444015_g21679_i0 PRJEB39269 22084 298 3.444015 10.2631647 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 86.1 2.73e-12   NTclustered gi|2621703574|emb|OY761449.1| 2026734 g21679 i0 88.732 7.06375838926174 71 7 23 1 95 164 1957832 1957762 MAG: Dehalococcoidia bacterium isolate 8faaec51-6d46-4fc3-9050-60b85d5760d4 genome assembly, chromosome: 1 blastn 2105 86.1 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
4817108 4817108 PRJEB39269_P_NODE_34864_length_234_cov_1.123077_g34459_i0 PRJEB39269 34864 234 1.123077 2.62800018 Thermobaculum 262406 Bacteria Bacteria 206 1.52e-48   NTclustered gi|470485526|ref|NR_076705.1| 166501 g34459 i0 83.7 78.4230769230769 227 27 94 10 14 234 662 884 Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence blastn 18351 206 1 Bacteria   Bacillati Chloroflexota Chloroflexia Candidatus Thermobaculales Candidatus Thermobaculaceae Thermobaculum Thermobaculum terrenum
10259876 10259876 PRJEB39269_P_NODE_76289_length_161_cov_3.401639_g75884_i0 PRJEB39269 76289 161 3.401639 5.47663879 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 104 3.64e-18   NTclustered gi|2621703287|emb|OY762444.1| 2026734 g75884 i0 90.909 1.16149068322981 77 7 48 0 83 159 2695633 2695709 MAG: Dehalococcoidia bacterium isolate 1bd329a7-1418-4194-a07e-3fe2e7ca1f7c genome assembly, chromosome: 1 blastn 187 104 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia 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);;