contig_metadata
16 rows where bioproject = "PRJNA667863" and tax_clade = "Haptista"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1910243 | 1910243 | PRJNA667863_P_NODE_4882_length_305_cov_1.211207_g4848_i0 | PRJNA667863 | 4882 | 305 | 1.211207 | 3.69418135 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 118 | 2.8699999999999997e-31 | NR | KAL3914967.1 | 2812485 | g4848 | i0 | 80.2 | 3.24590163934426 | 81 | 16 | 79.7 | 0 | 62 | 304 | 2 | 82 | KAL3914967.1 MAG: hypothetical protein SGPRY_007430 [Prymnesium sp.] | diamond | 990 | 118 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 4991771 | 4991771 | PRJNA667863_P_NODE_10124_length_257_cov_1.554348_g10090_i0 | PRJNA667863 | 10124 | 257 | 1.554348 | 3.99467436 | Diacronema | 70451 | Haptophyta | other_Eukaryota | 154 | 1.6299999999999999e-43 | NR | KAJ1632162.1 | 483367 | g10090 | i0 | 78.6 | 2.95330739299611 | 84 | 18 | 98.1 | 0 | 255 | 4 | 159 | 242 | KAJ1632162.1 defense-responsive protein, partial [Pavlovales sp. CCMP2436] | diamond | 759 | 155 | 0.993548387096774 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 5737437 | 5737437 | PRJNA667863_P_NODE_1985_length_397_cov_1.160494_g1951_i0 | PRJNA667863 | 1985 | 397 | 1.160494 | 4.60716118 | Dicrateria rotunda | 2703868 | Haptophyta | other_Eukaryota | 220 | 9.85e-53 | NTclustered | gi|259419544|emb|FN392559.1| | 2703868 | g1951 | i0 | 83.471 | 6.3727959697733 | 242 | 34 | 60 | 5 | 95 | 333 | 284 | 46 | Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 | blastn | 2530 | 220 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Dicrateria | Dicrateria rotunda | |||
| 8287122 | 8287122 | PRJNA667863_P_NODE_11027_length_252_cov_1.642458_g10993_i0 | PRJNA667863 | 11027 | 252 | 1.642458 | 4.13899416 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 9.999999999999999e-29 | NR | ALD47920.1 | 2903 | g10993 | i0 | 67.9 | 5.97619047619048 | 84 | 26 | 100 | 1 | 252 | 1 | 78 | 160 | ALD47920.1 adaptor protein complex 1 subunit mu [Emiliania huxleyi] | diamond | 1506 | 115 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 8287178 | 8287178 | PRJNA667863_P_NODE_14607_length_245_cov_0.895349_g14573_i0 | PRJNA667863 | 14607 | 245 | 0.895349 | 2.19360505 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 150 | 7.62e-32 | NTclustered | gi|551577272|ref|XM_005774215.1| | 280463 | g14573 | i0 | 87.121 | 33.2816326530612 | 132 | 17 | 54 | 0 | 27 | 158 | 1 | 132 | Emiliania huxleyi CCMP1516 40S ribosomal protein S4 partial mRNA | blastn | 8154 | 150 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 8287326 | 8287326 | PRJNA667863_P_NODE_6887_length_279_cov_2.271845_g6853_i0 | PRJNA667863 | 6887 | 279 | 2.271845 | 6.33844755 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 183 | 8.73e-42 | NTclustered | gi|54399513|gb|AY729487.1| | 2081491 | g6853 | i0 | 79.921 | 0.910394265232975 | 254 | 47 | 90 | 3 | 1 | 252 | 917 | 1168 | Pavlova lutheri EF-1 alpha-like protein (efl) mRNA, partial cds | blastn | 254 | 183 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 14662833 | 14662833 | PRJNA667863_P_NODE_10012_length_257_cov_9.815217_g9978_i0 | PRJNA667863 | 10012 | 257 | 9.815217 | 25.22510769 | Viridiplantae | 33090 | Haptophyta | other_Eukaryota | 141 | 9.37e-41 | NR | KAJ1623557.1 | 483367 | g9978 | i0 | 78.3 | 13.5875486381323 | 83 | 18 | 96.9 | 0 | 257 | 9 | 65 | 147 | KAJ1623557.1 ribosomal protein S11 [Pavlovales sp. CCMP2436] | diamond | 3492 | 142 | 0.992957746478873 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 14662848 | 14662848 | PRJNA667863_P_NODE_11432_length_251_cov_0.865169_g11398_i0 | PRJNA667863 | 11432 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 142 | 2.8299999999999993e-42 | NR | KAL1518757.1 | 97485 | g11398 | i0 | 84.6 | 13.1832669322709 | 78 | 12 | 93.2 | 0 | 18 | 251 | 1 | 78 | KAL1518757.1 hypothetical protein AB1Y20_003041 [Prymnesium parvum] | diamond | 3309 | 142 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 22311224 | 22311224 | PRJNA667863_P_NODE_1078_length_486_cov_24.782082_g1045_i0 | PRJNA667863 | 1078 | 486 | 24.782082 | 120.44091852 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 148 | 2.31e-43 | NR | XP_005758635.1 | 280463 | g1045 | i0 | 86.4 | 13.9814814814815 | 81 | 11 | 50 | 0 | 432 | 190 | 3 | 83 | XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] | diamond | 6795 | 148 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 28408075 | 28408075 | PRJNA667863_P_NODE_12386_length_249_cov_0.875000_g12352_i0 | PRJNA667863 | 12386 | 249 | 0.875 | 2.17875 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 43.5 | 0.0217 | NR | KAL1523261.1 | 97485 | g12352 | i0 | 54.1 | 0.44578313253012 | 37 | 17 | 44.6 | 0 | 221 | 111 | 767 | 803 | KAL1523261.1 hypothetical protein AB1Y20_018211 [Prymnesium parvum] | diamond | 111 | 43.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28818174 | 28818174 | PRJNA667863_P_NODE_18708_length_226_cov_2.006536_g18674_i0 | PRJNA667863 | 18708 | 226 | 2.006536 | 4.53477136 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 124 | 1.5899999999999998e-31 | NR | KAG8463986.1 | 2081491 | g18674 | i0 | 77.3 | 1.99115044247788 | 75 | 17 | 99.6 | 0 | 1 | 225 | 318 | 392 | KAG8463986.1 hypothetical protein KFE25_000154 [Diacronema lutheri] | diamond | 450 | 124 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30788745 | 30788745 | PRJNA667863_P_NODE_3294_length_341_cov_1.145522_g3260_i0 | PRJNA667863 | 3294 | 341 | 1.145522 | 3.90623002 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 128 | 3.67e-32 | NR | KAL1504882.1 | 97485 | g3260 | i0 | 67.9 | 2.31378299120235 | 84 | 27 | 73.9 | 0 | 14 | 265 | 291 | 374 | KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum] | diamond | 789 | 129 | 0.992248062015504 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31990158 | 31990158 | PRJNA667863_P_NODE_5738_length_290_cov_2.562212_g5704_i0 | PRJNA667863 | 5738 | 290 | 2.562212 | 7.4304148 | Prymnesium | 35143 | Haptophyta | other_Eukaryota | 84.3 | 3.44e-17 | NR | KAL1524175.1 | 97485 | g5704 | i0 | 56.2 | 3.77586206896552 | 73 | 32 | 75.5 | 0 | 219 | 1 | 96 | 168 | KAL1524175.1 hypothetical protein AB1Y20_019084 [Prymnesium parvum] | diamond | 1095 | 85.1 | 0.990599294947121 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32326631 | 32326631 | PRJNA667863_P_NODE_16039_length_242_cov_3.343195_g16005_i0 | PRJNA667863 | 16039 | 242 | 3.343195 | 8.0905319 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 45.4 | 0.00393 | NR | KOO29958.1 | 1460289 | g16005 | i0 | 40.3 | 1.7603305785124 | 62 | 34 | 76.9 | 1 | 229 | 44 | 249 | 307 | KOO29958.1 calcium-dependent protein kinase family protein [Chrysochromulina tobinii] | diamond | 426 | 45.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32496652 | 32496652 | PRJNA667863_P_NODE_14839_length_245_cov_0.895349_g14805_i0 | PRJNA667863 | 14839 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 3.22e-31 | NR | KAL1523551.1 | 97485 | g14805 | i0 | 70.4 | 4.95918367346939 | 81 | 24 | 99.2 | 0 | 2 | 244 | 19 | 99 | KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] | diamond | 1215 | 116 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32685651 | 32685651 | PRJNA667863_P_NODE_18660_length_226_cov_2.627451_g18626_i0 | PRJNA667863 | 18660 | 226 | 2.627451 | 5.93803926 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 8.270000000000001e-22 | NR | KAL1495466.1 | 97485 | g18626 | i0 | 74.1 | 3.51769911504425 | 58 | 15 | 77 | 0 | 174 | 1 | 15 | 72 | KAL1495466.1 hypothetical protein AB1Y20_016832 [Prymnesium parvum] | diamond | 795 | 91.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum |
Advanced export
JSON shape: default, array, newline-delimited
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);;