RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA767802" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 3 ✖

bioproject 1

  • PRJNA767802 · 3 ✖

tax_kingdom 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
3296354 3296354 PRJNA767802_P_NODE_10603_length_218_cov_1.905325_g10530_i0 PRJNA767802 10603 218 1.905325 4.1536085 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 54.7 1.61e-6   NR KAG8463970.1 2081491 g10530 i0 32.9 1.0045871559633 73 44 93.6 1 8 211 158 230 KAG8463970.1 hypothetical protein KFE25_000138 [Diacronema lutheri] diamond 219 54.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
18596848 18596848 PRJNA767802_P_NODE_13695_length_185_cov_2.161765_g13622_i0 PRJNA767802 13695 185 2.161765 3.99926525 Pterocystis tropica 299886 Root_unresolved Root_unresolved 235 1.46e-57   NTclustered gi|61187375|gb|AY752993.1| 299886 g13622 i0 89.73 98.2108108108108 185 17 100 1 1 185 2035 1853 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 18169 235 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
28294468 28294468 PRJNA767802_P_NODE_8146_length_263_cov_1.766355_g8073_i0 PRJNA767802 8146 263 1.766355 4.64551365 Prymnesiales 73028 Haptophyta other_Eukaryota 75.9 1.03e-13   NR KAL1528661.1 97485 g8073 i0 39.5 2.00760456273764 86 42 86.7 1 262 35 485 570 KAL1528661.1 hypothetical protein AB1Y20_009998 [Prymnesium parvum] diamond 528 75.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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