RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA624323", tax_kingdom = "Bacillati" 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

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA624323 · 3 ✖

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
6974810 6974810 PRJNA624323_P_NODE_206_length_1315_cov_2.979066_g143_i0 PRJNA624323 206 1315 2.979066 39.1747179 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 1973 0   NTclustered gi|2874254102|emb|OY970185.1| 1672391 g143 i0 93.722 478.050950570342 1322 74 100 7 1 1315 1857978 1859297 MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 blastn 628637 1973 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
14625276 14625276 PRJNA624323_P_NODE_2012_length_518_cov_2.838202_g1853_i0 PRJNA624323 2012 518 2.838202 14.70188636 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 725 0   NTclustered gi|2874254102|emb|OY970185.1| 1672391 g1853 i0 91.923 41.2586872586873 520 39 100 3 1 518 1857975 1857457 MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 blastn 21372 725 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
22273511 22273511 PRJNA624323_P_NODE_9258_length_243_cov_0.905882_g9096_i0 PRJNA624323 9258 243 0.905882 2.20129326 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 176 1.25e-39   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g9096 i0 83.582 10.5514403292181 201 20 79 11 4 196 273154 273349 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 2564 176 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia 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);;