RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 3 ✖

bioproject 1

  • PRJNA788929 · 3 ✖

analysis 1

  • blastn · 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
2489853 2489853 PRJNA788929_P_NODE_48222_length_209_cov_10.397059_g47561_i0 PRJNA788929 48222 209 10.397059 21.72985331 Pterocystida 2607628 Root_unresolved Root_unresolved 115 2.3e-21   NTclustered gi|61187375|gb|AY752993.1| 299886 g47561 i0 98.462 29.9521531100478 65 1 31 0 123 187 2502 2438 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 6260 115 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
3320499 3320499 PRJNA788929_P_NODE_22843_length_338_cov_26.362264_g22182_i0 PRJNA788929 22843 338 26.362264 89.10445232 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 117 1.1200000000000002e-21   NTclustered gi|551580226|ref|XM_005775612.1| 280463 g22182 i0 83.206 5.54733727810651 131 19 38 2 152 279 616 746 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 1875 117 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24995831 24995831 PRJNA788929_P_NODE_27460_length_303_cov_10.704348_g26799_i0 PRJNA788929 27460 303 10.704348 32.43417444 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 165 3.47e-36   NTclustered gi|61187370|gb|AY752991.1| 299901 g26799 i0 78.799 209.339933993399 283 32 93 25 1 281 2302 2046 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 63430 165 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii

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