RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA846486" 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

  • PRJNA846486 · 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
833371 833371 PRJNA846486_P_NODE_82901_length_166_cov_1.333333_g82805_i0 PRJNA846486 82901 166 1.333333 2.21333278 uncultured Dehalococcoidia bacterium 498747 Bacteria Bacteria 87.9 3.81e-13   NTclustered gi|2518551288|emb|OX638345.1| 498747 g82805 i0 83.158 2.04819277108434 95 16 57 0 22 116 3824944 3824850 MAG: uncultured Dehalococcoidia bacterium isolate 64bd3295-a2ac-4bb0-a587-f708157bf7f0 genome assembly, chromosome: 1 blastn 340 87.9 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       uncultured Dehalococcoidia bacterium
9761302 9761302 PRJNA846486_P_NODE_37988_length_220_cov_1.216374_g37892_i0 PRJNA846486 37988 220 1.216374 2.6760228 uncultured Chloroflexota bacterium 166587 Bacteria Bacteria 78.7 3.21e-10   NTclustered gi|2531948664|emb|OY282448.1| 166587 g37892 i0 86.957 3.15909090909091 69 9 31 0 5 73 1117728 1117796 MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1 blastn 695 78.7 1 Bacteria   Bacillati Chloroflexota         uncultured Chloroflexota bacterium
14861274 14861274 PRJNA846486_P_NODE_83252_length_166_cov_1.068376_g83156_i0 PRJNA846486 83252 166 1.068376 1.77350416 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 52.8 0.014   NTclustered gi|2626282194|emb|OY839116.1| 2026734 g83156 i0 96.875 0.192771084337349 32 0 19 1 44 75 914356 914326 MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1 blastn 32 52.8 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
21235445 21235445 PRJNA846486_P_NODE_90257_length_163_cov_1.324561_g90161_i0 PRJNA846486 90257 163 1.324561 2.15903443 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 97.1 6.19e-16   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g90161 i0 85.714 3.01226993865031 91 13 82 0 49 139 2392324 2392234 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 491 97.1 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);;