RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJDB3785" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 16 ✖

bioproject 1

  • PRJDB3785 · 16 ✖

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
8919 8919 PRJDB3785_S_NODE_3961_length_384_cov_7.970149_g3808_i0 PRJDB3785 3961 384 7.970149 30.60537216 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 117 1.28e-21   NTclustered gi|551580226|ref|XM_005775612.1| 280463 g3808 i0 83.206 4.8828125 131 19 33 2 48 175 746 616 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 1875 117 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
3834905 3834905 PRJDB3785_S_NODE_13464_length_210_cov_0.950311_g13311_i0 PRJDB3785 13464 210 0.950311 1.9956531 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 94.4 9.62e-23   NR XP_005789979.1 280463 g13311 i0 75 8.75714285714286 68 17 97.1 0 208 5 3 70 XP_005789979.1 hypothetical protein EMIHUDRAFT_417676 [Emiliania huxleyi CCMP1516] diamond 1839 94.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22960794 22960794 PRJDB3785_S_NODE_26199_length_162_cov_1.433628_g26046_i0 PRJDB3785 26199 162 1.433628 2.32247736 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 108 1.6300000000000002e-27   NR KAL1528518.1 97485 g26046 i0 90.4 2.88888888888889 52 5 96.3 0 7 162 1 52 KAL1528518.1 hypothetical protein AB1Y20_009861 [Prymnesium parvum] diamond 468 108 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
25207260 25207260 PRJDB3785_S_NODE_19880_length_178_cov_1.217054_g19727_i0 PRJDB3785 19880 178 1.217054 2.16635612 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 108 3.17e-19   NTclustered gi|551604847|ref|XM_005783816.1| 280463 g19727 i0 83.193 11.0393258426966 119 18 66 2 50 167 385 268 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1965 108 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26620859 26620859 PRJDB3785_S_NODE_14381_length_204_cov_1.470968_g14228_i0 PRJDB3785 14381 204 1.470968 3.00077472 Prymnesium parvum 97485 Haptophyta other_Eukaryota 85.9 1.38e-17   NR KAL1504395.1 97485 g14228 i0 57.4 3 68 29 100 0 204 1 47 114 KAL1504395.1 hypothetical protein AB1Y20_010801 [Prymnesium parvum] diamond 612 85.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28226453 28226453 PRJDB3785_S_NODE_10126_length_238_cov_1.333333_g9973_i0 PRJDB3785 10126 238 1.333333 3.17333254 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 2.7699999999999993e-28   NR KAL1521514.1 97485 g9973 i0 67.1 3.98319327731092 79 26 99.6 0 1 237 281 359 KAL1521514.1 hypothetical protein AB1Y20_021174 [Prymnesium parvum] diamond 948 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28422255 28422255 PRJDB3785_S_NODE_18966_length_182_cov_1.127820_g18813_i0 PRJDB3785 18966 182 1.12782 2.0526324 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 47 3.62e-4   NR KOO21172.1 1460289 g18813 i0 45.7 0.758241758241758 46 24 75.8 1 21 158 95 139 KOO21172.1 hypothetical protein Ctob_000106 [Chrysochromulina tobinii] diamond 138 47 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28422267 28422267 PRJDB3785_S_NODE_24506_length_165_cov_0.879310_g24353_i0 PRJDB3785 24506 165 0.87931 1.4508615 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 89 6.89e-19   NR BBB87256.1 2792838 g24353 i0 92.7 1 55 4 100 0 165 1 607 661 BBB87256.1 major vault protein [Raphidocystis contractilis] diamond 165 89 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
28580047 28580047 PRJDB3785_S_NODE_22007_length_170_cov_2.057851_g21854_i0 PRJDB3785 22007 170 2.057851 3.4983467 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 80.5 3.66e-16   NR ABV25598.1 2081491 g21854 i0 71.7 0.935294117647059 53 15 93.5 0 10 168 25 77 ABV25598.1 putative mitochondrial ADP/ATP translocase [Diacronema lutheri] diamond 159 80.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28990706 28990706 PRJDB3785_S_NODE_20988_length_174_cov_1.224000_g20835_i0 PRJDB3785 20988 174 1.224 2.12976 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 83.2 7.71e-18   NR XP_005757770.1 280463 g20835 i0 64.9 2.96551724137931 57 20 98.3 0 174 4 13 69 XP_005757770.1 60S ribosomal protein L10a [Emiliania huxleyi CCMP1516] diamond 516 83.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29495590 29495590 PRJDB3785_S_NODE_9130_length_250_cov_1.009950_g8977_i0 PRJDB3785 9130 250 1.00995 2.524875 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 94.4 2.89e-20   NR KOO23673.1 1460289 g8977 i0 55.4 0.996 83 35 99.6 1 249 1 191 271 KOO23673.1 calcium-transporting ATPase endoplasmic reticulum-type-like protein [Chrysochromulina tobinii] diamond 249 94.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30032555 30032555 PRJDB3785_S_NODE_8611_length_257_cov_1.100962_g8458_i0 PRJDB3785 8611 257 1.100962 2.82947234 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 85.5 3.85e-19   NR KAG8457026.1 2081491 g8458 i0 52.6 1.75097276264591 78 37 91.1 0 234 1 1 78 KAG8457026.1 hypothetical protein KFE25_010442 [Diacronema lutheri] diamond 450 85.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30221942 30221942 PRJDB3785_S_NODE_16572_length_193_cov_0.819444_g16419_i0 PRJDB3785 16572 193 0.819444 1.58152692 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 67.4 2.57e-11   NR XP_005781812.1 280463 g16419 i0 50 1.9119170984456 62 31 96.4 0 187 2 111 172 XP_005781812.1 hypothetical protein EMIHUDRAFT_99790 [Emiliania huxleyi CCMP1516] diamond 369 67.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30822312 30822312 PRJDB3785_S_NODE_10034_length_239_cov_1.342105_g9881_i0 PRJDB3785 10034 239 1.342105 3.20763095 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 53.1 7.49e-6   NR KAG8460152.1 2081491 g9881 i0 51.4 3.96652719665272 72 30 87.9 3 2 211 445 513 KAG8460152.1 hypothetical protein KFE25_014297 [Diacronema lutheri] diamond 948 53.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32271244 32271244 PRJDB3785_S_NODE_13738_length_208_cov_1.276730_g13585_i0 PRJDB3785 13738 208 1.27673 2.6555984 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 89.7 1.52e-19   NR KOO24708.1 1460289 g13585 i0 60.6 6.72115384615385 66 26 95.2 0 5 202 235 300 KOO24708.1 vacuolar protein sorting-associated protein 26 [Chrysochromulina tobinii] diamond 1398 89.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32366258 32366258 PRJDB3785_S_NODE_15499_length_198_cov_1.026846_g15346_i0 PRJDB3785 15499 198 1.026846 2.03315508 Prymnesium 35143 Haptophyta other_Eukaryota 88.6 4.8e-19   NR KAL1529760.1 97485 g15346 i0 55.6 2.86363636363636 63 27 95.5 1 190 2 131 192 KAL1529760.1 hypothetical protein AB1Y20_000696 [Prymnesium parvum] diamond 567 88.6 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);;