RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA533114 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
9433852 9433852 PRJNA533114_P_NODE_7988_length_792_cov_3.351878_g7780_i0 PRJNA533114 7988 792 3.351878 26.54687376 Herpetosiphon aurantiacus 65 Bacteria Bacteria 54.7 0.022   NTclustered gi|159889572|gb|CP000875.1| 316274 g7780 i0 100 0.0366161616161616 29 0 4 0 722 750 3903298 3903326 Herpetosiphon aurantiacus DSM 785, complete genome blastn 29 54.7 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon aurantiacus
10709676 10709676 PRJNA533114_P_NODE_89749_length_256_cov_1.683060_g89497_i0 PRJNA533114 89749 256 1.68306 4.3086336 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 58.4 5e-4   NTclustered gi|2621702714|emb|OY759598.1| 2026734 g89497 i0 100 0.6171875 31 0 12 0 102 132 1963914 1963884 MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1 blastn 158 58.4 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
20907764 20907764 PRJNA533114_P_NODE_97477_length_250_cov_0.870056_g97225_i0 PRJNA533114 97477 250 0.870056 2.17514 Candidatus Promineifilum breve 1806508 Bacteria Bacteria 65.8 2.91e-6   NTclustered gi|1027789859|emb|LN890656.1| 1806508 g97225 i0 100 39.164 35 0 16 0 134 168 55744 55778 Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: II blastn 9791 65.8 1 Bacteria   Bacillati Chloroflexota Ardenticatenia Candidatus Promineifilales Candidatus Promineifilaceae Candidatus Promineifilum Candidatus Promineifilum breve
22181356 22181356 PRJNA533114_P_NODE_15618_length_572_cov_2.422846_g15371_i0 PRJNA533114 15618 572 2.422846 13.85867912 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 54.7 0.016   NTclustered gi|2107832821|gb|CP070822.1| 2024896 g15371 i0 100 0.0506993006993007 29 0 5 0 446 474 622947 622975 MAG: Anaerolineaceae bacterium isolate bin1136 chromosome blastn 29 54.7 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae 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);;