RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1022392 · 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
2712796 2712796 PRJNA1022392_P_NODE_58183_length_179_cov_3.984848_g57514_i0 PRJNA1022392 58183 179 3.984848 7.13287792 Tepidiforma flava 3004094 Bacteria Bacteria 111 2.47e-20   NTclustered gi|2421951025|gb|CP115149.1| 3004094 g57514 i0 78.771 22.5474860335196 179 28 97 10 1 174 2662794 2662621 Tepidiforma flava strain YIM 72310 chromosome, complete genome blastn 4036 111 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Tepidiforma Tepidiforma flava
7814655 7814655 PRJNA1022392_P_NODE_35267_length_206_cov_2.295597_g34598_i0 PRJNA1022392 35267 206 2.295597 4.72892982 uncultured Dehalococcoidia bacterium 498747 Bacteria Bacteria 75 3.84e-9   NTclustered gi|2531976033|emb|OY282371.1| 498747 g34598 i0 84.416 1.19417475728155 77 10 37 2 124 199 988765 988690 MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1 blastn 246 75 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       uncultured Dehalococcoidia bacterium
24387951 24387951 PRJNA1022392_P_NODE_12420_length_314_cov_2.970037_g11756_i0 PRJNA1022392 12420 314 2.970037 9.32591618 Roseiflexus sp. RS-1 357808 Bacteria Bacteria 207 5.9300000000000004e-49   NTclustered gi|470481958|ref|NR_076505.1| 357808 g11756 i0 84.951 122.920382165605 206 30 65 1 110 314 956 751 Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence blastn 38597 207 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus sp. RS-1

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);;