RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 5 ✖

bioproject 1

  • PRJEB75230 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2686135 2686135 PRJEB75230_P_NODE_126483_length_250_cov_0.870056_g126301_i0 PRJEB75230 126483 250 0.870056 2.17514 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 113 1.02e-20   NTclustered gi|551583414|ref|XM_005777087.1| 280463 g126301 i0 87.629 0.388 97 12 39 0 152 248 1315 1219 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 97 113 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2686867 2686867 PRJEB75230_P_NODE_183403_length_241_cov_0.916667_g183221_i0 PRJEB75230 183403 241 0.916667 2.20916747 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.002   NTclustered gi|551563065|ref|XM_005768200.1| 280463 g183221 i0 100 0.12448132780083 30 0 12 0 133 162 1583 1554 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 30 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6515271 6515271 PRJEB75230_P_NODE_35066_length_337_cov_3.246212_g34884_i0 PRJEB75230 35066 337 3.246212 10.93973444 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 405 2.12e-108   NTclustered gi|81230321|dbj|AB196985.1| 2792838 g34884 i0 88.427 94.1928783382789 337 37 99 2 1 336 853 518 Raphidocystis contractilis gene for alpha-tubulin, partial cds blastn 31743 405 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
10339491 10339491 PRJEB75230_P_NODE_154769_length_245_cov_0.895349_g154587_i0 PRJEB75230 154769 245 0.895349 2.19360505 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 119 2.15e-22   NTclustered gi|259419544|emb|FN392559.1| 2703868 g154587 i0 78.173 72.7959183673469 197 35 80 6 3 197 211 401 Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 blastn 17835 119 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
14165240 14165240 PRJEB75230_P_NODE_184852_length_238_cov_2.793939_g184670_i0 PRJEB75230 184852 238 2.793939 6.64957482 Heterophryidae sp. 2967111 Root_unresolved Root_unresolved 422 1.41e-113   NTclustered gi|2277958256|gb|OP101620.1| 2967111 g184670 i0 98.734 81.2605042016807 237 3 99 0 1 237 650 886 Heterophryidae sp. strain HF-55 small subunit ribosomal RNA gene, partial sequence blastn 19340 422 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae   Heterophryidae sp.

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