RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA811237" 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

  • PRJNA811237 · 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
5912267 5912267 PRJNA811237_S_NODE_865_length_751_cov_3.740741_g670_i0 PRJNA811237 865 751 3.740741 28.09296491 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 285 6.819999999999999e-72   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g670 i0 83.607 3.18375499334221 305 48 40 2 377 680 402 99 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 2391 285 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6327570 6327570 PRJNA811237_S_NODE_16445_length_203_cov_2.435065_g16205_i0 PRJNA811237 16445 203 2.435065 4.94318195 Viridiplantae 33090 Haptophyta other_Eukaryota 115 2.22e-21   NTclustered gi|551555706|ref|XM_005764956.1| 280463 g16205 i0 86.538 5.32019704433498 104 14 51 0 42 145 584 481 Emiliania huxleyi CCMP1516 mitochondrial carrier protein mRNA blastn 1080 115 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7187020 7187020 PRJNA811237_S_NODE_12366_length_225_cov_1.079545_g12126_i0 PRJNA811237 12366 225 1.079545 2.42897625 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 176 1.14e-39   NTclustered gi|551561054|ref|XM_005767364.1| 280463 g12126 i0 82.126 26.4177777777778 207 35 92 2 1 206 618 823 Emiliania huxleyi CCMP1516 GTR2, GTR/RAG family GTPase (GTR2-2), mRNA blastn 5944 176 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
9736816 9736816 PRJNA811237_S_NODE_10928_length_235_cov_1.096774_g10688_i0 PRJNA811237 10928 235 1.096774 2.5774189 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.002   NTclustered gi|551612603|ref|XM_005787267.1| 280463 g10688 i0 96.97 0.140425531914894 33 1 14 0 87 119 151 183 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 33 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18660208 18660208 PRJNA811237_S_NODE_17675_length_198_cov_1.543624_g17435_i0 PRJNA811237 17675 198 1.543624 3.05637552 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 110 1e-19   NTclustered gi|551606591|ref|XM_005784584.1| 280463 g17435 i0 84.211 10.5353535353535 114 16 57 2 1 113 201 313 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 2086 110 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);;