RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1123436 · 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
7407256 7407256 PRJNA1123436_P_NODE_28046_length_487_cov_6.553140_g26838_i0 PRJNA1123436 28046 487 6.55314 31.9137918 root 1 Root_unresolved Root_unresolved 289 3.32e-73   NTclustered gi|471648416|gb|KC661980.1| 29281 g26838 i0 100 81.1108829568789 156 0 85 0 1 156 394 549 Uncultured crenarchaeote clone LC-J-Sd-W3-A12 16S ribosomal RNA gene, partial sequence blastn 39501 289 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
14309690 14309690 PRJNA1123436_P_NODE_95972_length_251_cov_0.865169_g94758_i0 PRJNA1123436 95972 251 0.865169 2.17157419 uncultured crenarchaeote 29281 Archaea Archaea 351 2e-92   NTclustered gi|289470097|gb|GU135501.1| 29281 g94758 i0 99.482 75.2470119521912 193 1 77 0 1 193 194 2 Uncultured crenarchaeote clone Pav-sed-521 16S ribosomal RNA gene, partial sequence blastn 18887 351 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
16331753 16331753 PRJNA1123436_P_NODE_128953_length_219_cov_4.753425_g127739_i0 PRJNA1123436 128953 219 4.753425 10.41000075 root 1 Root_unresolved Root_unresolved 403 4.64e-108   NTclustered gi|332143537|gb|JF694343.1| 29281 g127739 i0 100 99.5433789954338 218 0 99 0 1 218 235 18 Uncultured crenarchaeote clone E2 16S ribosomal RNA gene, partial sequence blastn 21800 403 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote

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