RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB73599", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 6 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJEB73599 · 6 ✖

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
1409744 1409744 PRJEB73599_P_NODE_2322_length_483_cov_2.376652_g2060_i0 PRJEB73599 2322 483 2.376652 11.47922916 Marophrys sp. SRT127 2488311 Root_unresolved Root_unresolved 130 2.11e-25   NTclustered gi|1601521829|dbj|AP019310.1| 2488311 g2060 i0 89.423 23.4016563146998 104 10 47 1 148 251 55613 55715 Marophrys sp. SRT127 mitochondrial DNA, complete sequence blastn 11303 130 1 Eukaryota Haptista     Centroplasthelida Acanthocystida   Marophrys Marophrys sp. SRT127
5237750 5237750 PRJEB73599_P_NODE_6825_length_224_cov_4.251282_g6538_i0 PRJEB73599 6825 224 4.251282 9.52287168 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 147 8.88e-31   NTclustered gi|81230320|dbj|AB196984.1| 2792838 g6538 i0 93.878 43.7633928571429 98 5 44 1 2 99 1990 1894 Raphidocystis contractilis gene for 18S ribosomal RNA, partial sequence blastn 9803 147 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
12888704 12888704 PRJEB73599_P_NODE_1791_length_554_cov_2.680000_g1554_i0 PRJEB73599 1791 554 2.68 14.8472 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 312 7.689999999999997e-106   NR KAL1523490.1 97485 g1554 i0 82.1 6.97472924187726 184 33 99.6 0 3 554 22 205 KAL1523490.1 hypothetical protein AB1Y20_018428 [Prymnesium parvum] diamond 3864 315 0.990476190476191 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
15437667 15437667 PRJEB73599_P_NODE_5373_length_275_cov_12.121951_g5086_i0 PRJEB73599 5373 275 12.121951 33.33536525 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 150 8.709999999999998e-32   NTclustered gi|81230320|dbj|AB196984.1| 2792838 g5086 i0 96.667 29.3781818181818 90 3 33 0 1 90 99 188 Raphidocystis contractilis gene for 18S ribosomal RNA, partial sequence blastn 8079 150 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
21397662 21397662 PRJEB73599_P_NODE_8877_length_173_cov_2.583333_g8590_i0 PRJEB73599 8877 173 2.583333 4.46916609 Pterocystis 238775 Root_unresolved Root_unresolved 252 1.33e-62   NTclustered gi|55469134|gb|AY749607.1| 299882 g8590 i0 93.567 97.9537572254335 171 3 99 1 2 172 710 872 Pterocystis sp. Oxford2 18S ribosomal RNA gene, partial sequence blastn 16946 252 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis sp. Oxford2
28423910 28423910 PRJEB73599_P_NODE_7046_length_218_cov_1.280423_g6759_i0 PRJEB73599 7046 218 1.280423 2.79132214 Prymnesium parvum 97485 Haptophyta other_Eukaryota 101 3.21e-23   NR KAL1504127.1 97485 g6759 i0 65.3 0.990825688073395 72 25 99.1 0 3 218 132 203 KAL1504127.1 hypothetical protein AB1Y20_010537 [Prymnesium parvum] diamond 216 101 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);;