RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA489308" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA489308 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
10653729 10653729 PRJNA489308_P_NODE_10709_length_348_cov_2.214545_g10633_i0 PRJNA489308 10709 348 2.214545 7.7066166 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 139 2.46e-28   NTclustered gi|551555198|ref|XM_005764739.1| 280463 g10633 i0 82.099 10.4942528735632 162 29 47 0 186 347 2028 1867 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 3652 139 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22126627 22126627 PRJNA489308_P_NODE_26298_length_263_cov_2.421053_g26222_i0 PRJNA489308 26298 263 2.421053 6.36736939 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 206 1.74e-48   NTclustered gi|551573160|ref|XM_005772330.1| 280463 g26222 i0 82.143 72.4220532319392 252 33 94 11 18 263 710 465 Emiliania huxleyi CCMP1516 NAD-dependent malate dehydrogenase mRNA blastn 19047 206 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23402373 23402373 PRJNA489308_P_NODE_14199_length_319_cov_1.146341_g14123_i0 PRJNA489308 14199 319 1.146341 3.65682779 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 135 2.89e-27   NTclustered gi|61229241|gb|AY841760.1| 2081491 g14123 i0 84.962 41.9310344827586 133 20 42 0 1 133 1005 1137 Pavlova lutheri S-adenosyl-L-homocysteine hydrolase (sahh) mRNA, partial cds blastn 13376 135 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
24676074 24676074 PRJNA489308_P_NODE_12060_length_335_cov_2.263359_g11984_i0 PRJNA489308 12060 335 2.263359 7.58225265 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 141 6.55e-29   NTclustered gi|551606591|ref|XM_005784584.1| 280463 g11984 i0 80.412 45.0208955223881 194 31 57 4 144 335 419 231 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 15082 141 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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