RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA917598 · 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
20023147 20023147 PRJNA917598_P_NODE_59476_length_292_cov_2.767123_g58532_i0 PRJNA917598 59476 292 2.7671230000000002 8.07999916 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 322 1.87e-83   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g58532 i0 89.96 150.02397260274 249 25 85 0 1 249 274031 274279 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 43807 322 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
20023473 20023473 PRJNA917598_P_NODE_73536_length_264_cov_2.015707_g72592_i0 PRJNA917598 73536 264 2.015707 5.32146648 Roseiflexus sp. RS-1 357808 Bacteria Bacteria 241 4.8e-59   NTclustered gi|470481958|ref|NR_076505.1| 357808 g72592 i0 85.774 7.50757575757576 239 20 90 9 28 264 1401 1175 Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence blastn 1982 241 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus sp. RS-1
21298465 21298465 PRJNA917598_P_NODE_59857_length_291_cov_2.527523_g58913_i0 PRJNA917598 59857 291 2.527523 7.35509193 Phototrophicaceae bacterium 3069543 Bacteria Bacteria 263 1.14e-65   NTclustered gi|2893356046|emb|OZ220469.1| 3069543 g58913 i0 87.391 86.8865979381443 230 27 79 2 33 261 2202583 2202355 MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1 blastn 25284 263 1 Bacteria   Bacillati Chloroflexota Candidatus Thermofontia Phototrophicales Phototrophicaceae   Phototrophicaceae 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);;