RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA611476 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
589308 589308 PRJNA611476_P_NODE_28281_length_385_cov_1.083333_g27490_i0 PRJNA611476 28281 385 1.083333 4.17083205 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 58.4 7.9e-4   NTclustered gi|551611545|ref|XM_005786799.1| 280463 g27490 i0 94.737 1.45454545454545 38 0 10 1 308 345 1355 1390 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 560 58.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4416934 4416934 PRJNA611476_P_NODE_34484_length_356_cov_1.632509_g33693_i0 PRJNA611476 34484 356 1.632509 5.81173204 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 117 1.18e-21   NTclustered gi|551580226|ref|XM_005775612.1| 280463 g33693 i0 83.206 5.26685393258427 131 19 36 2 47 174 746 616 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 1875 117 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4975778 4975778 PRJNA611476_P_NODE_116644_length_241_cov_0.916667_g115853_i0 PRJNA611476 116644 241 0.916667 2.20916747 Viridiplantae 33090 Haptophyta other_Eukaryota 54.7 0.006   NTclustered gi|551606909|ref|XM_005784724.1| 280463 g115853 i0 100 0.742738589211618 29 0 12 0 74 102 3848 3876 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 179 54.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10794386 10794386 PRJNA611476_P_NODE_9169_length_642_cov_1.451670_g8387_i0 PRJNA611476 9169 642 1.45167 9.3197214 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 89.8 4.86e-13   NTclustered gi|551557601|ref|XM_005765767.1| 280463 g8387 i0 87.342 0.509345794392523 79 8 12 2 15 92 5073 4996 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 327 89.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13343282 13343282 PRJNA611476_P_NODE_21011_length_436_cov_0.831956_g20220_i0 PRJNA611476 21011 436 0.831956 3.62732816 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 364 4.76e-96   NTclustered gi|551583694|ref|XM_005777204.1| 280463 g20220 i0 82.176 77.9954128440367 432 69 99 6 4 434 866 442 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 34006 364 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14617936 14617936 PRJNA611476_P_NODE_114932_length_241_cov_1.684524_g114141_i0 PRJNA611476 114932 241 1.684524 4.05970284 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 195 3.41e-45   NTclustered gi|551605616|ref|XM_005784143.1| 280463 g114141 i0 82.87 41.3651452282158 216 37 90 0 1 216 1177 962 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 9969 195 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18440858 18440858 PRJNA611476_P_NODE_102915_length_245_cov_0.895349_g102124_i0 PRJNA611476 102915 245 0.895349 2.19360505 Chrysochromulina sp. NIES-1333 407208 Haptophyta other_Eukaryota 270 5.609999999999999e-68   NTclustered gi|116222130|gb|DQ980444.1| 407208 g102124 i0 86.885 85.3183673469388 244 29 99 2 2 245 922 682 Chrysochromulina sp. NIES-1333 Hsp90 gene, partial cds blastn 20903 270 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina sp. NIES-1333
19716556 19716556 PRJNA611476_P_NODE_8256_length_675_cov_1.797342_g7482_i0 PRJNA611476 8256 675 1.797342 12.1320585 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 333 2.15e-86   NTclustered gi|551555706|ref|XM_005764956.1| 280463 g7482 i0 77.798 8.51407407407407 563 109 82 13 83 637 744 190 Emiliania huxleyi CCMP1516 mitochondrial carrier protein mRNA blastn 5747 333 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23541792 23541792 PRJNA611476_P_NODE_31459_length_369_cov_1.246622_g30668_i0 PRJNA611476 31459 369 1.246622 4.60003518 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 52.8 0.035   NTclustered gi|551621201|ref|XM_005791028.1| 280463 g30668 i0 100 0.0758807588075881 28 0 8 0 6 33 2587 2614 Emiliania huxleyi CCMP1516 Sodium/Calcium exchanger protein (NCX1), partial mRNA blastn 28 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23542249 23542249 PRJNA611476_P_NODE_65559_length_275_cov_1.143564_g64768_i0 PRJNA611476 65559 275 1.143564 3.144801 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 141 5.24e-29   NTclustered gi|551615633|ref|XM_005788628.1| 280463 g64768 i0 77.917 26.5272727272727 240 43 85 9 41 275 1197 963 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 7295 141 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24816039 24816039 PRJNA611476_P_NODE_62900_length_280_cov_1.115942_g62109_i0 PRJNA611476 62900 280 1.115942 3.1246376 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 230 1.1099999999999995e-55   NTclustered gi|551584285|ref|XM_005777484.1| 280463 g62109 i0 81.851 48.1857142857143 281 43 99 8 4 280 748 472 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 13492 230 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);;