contig_metadata
21 rows where bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5079321 | 5079321 | PRJNA915212_P_NODE_3044_length_365_cov_2.117089_g3007_i0 | PRJNA915212 | 3044 | 365 | 2.117089 | 7.72737485 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 265 | 4.09e-66 | NTclustered | gi|551555198|ref|XM_005764739.1| | 280463 | g3007 | i0 | 81.006 | 69.4465753424657 | 358 | 47 | 94 | 14 | 5 | 347 | 640 | 991 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 25348 | 265 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 11098664 | 11098664 | PRJNA915212_P_NODE_3209_length_353_cov_2.700658_g3172_i0 | PRJNA915212 | 3209 | 353 | 2.700658 | 9.53332274 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 149 | 1.46e-44 | NR | XP_005758635.1 | 280463 | g3172 | i0 | 86.4 | 0.688385269121813 | 81 | 11 | 68.8 | 0 | 29 | 271 | 3 | 83 | XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] | diamond | 243 | 149 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 12374293 | 12374293 | PRJNA915212_P_NODE_3090_length_362_cov_1.300319_g3053_i0 | PRJNA915212 | 3090 | 362 | 1.300319 | 4.70715478 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 188 | 7.74e-58 | NR | KAJ1628737.1 | 483367 | g3053 | i0 | 72.5 | 17.9005524861878 | 120 | 33 | 99.4 | 0 | 3 | 362 | 57 | 176 | KAJ1628737.1 ribosomal protein S2, flavodoxin-like domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 6480 | 189 | 0.994708994708995 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 12374302 | 12374302 | PRJNA915212_P_NODE_4050_length_304_cov_2.180392_g4012_i0 | PRJNA915212 | 4050 | 304 | 2.180392 | 6.62839168 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 100 | 3.949999999999999e-24 | NR | KAJ1624347.1 | 483367 | g4012 | i0 | 68.6 | 0.690789473684211 | 70 | 22 | 69.1 | 0 | 95 | 304 | 2 | 71 | KAJ1624347.1 V-type ATPase 16 kDa proteolipid subunit [Pavlovales sp. CCMP2436] | diamond | 210 | 100 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 14923119 | 14923119 | PRJNA915212_P_NODE_5172_length_262_cov_1.553991_g5134_i0 | PRJNA915212 | 5172 | 262 | 1.553991 | 4.07145642 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 255 | 1.7e-63 | NTclustered | gi|551548842|ref|XM_005762007.1| | 280463 | g5134 | i0 | 86.9 | 7.16793893129771 | 229 | 28 | 87 | 2 | 22 | 249 | 175 | 402 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 1878 | 255 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 18746742 | 18746742 | PRJNA915212_P_NODE_3635_length_327_cov_1.464029_g3598_i0 | PRJNA915212 | 3635 | 327 | 1.464029 | 4.78737483 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 160 | 2.35e-48 | NR | KAL1515397.1 | 97485 | g3598 | i0 | 74.5 | 28.394495412844 | 102 | 26 | 93.6 | 0 | 22 | 327 | 2 | 103 | KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] | diamond | 9285 | 160 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 22572228 | 22572228 | PRJNA915212_P_NODE_4878_length_271_cov_1.959459_g4840_i0 | PRJNA915212 | 4878 | 271 | 1.959459 | 5.31013389 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 195 | 3.9e-45 | NTclustered | gi|551548842|ref|XM_005762007.1| | 280463 | g4840 | i0 | 89.542 | 6.7380073800738 | 153 | 16 | 56 | 0 | 117 | 269 | 402 | 250 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 1826 | 195 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27182421 | 27182421 | PRJNA915212_P_NODE_8862_length_196_cov_1.034014_g8824_i0 | PRJNA915212 | 8862 | 196 | 1.034014 | 2.02666744 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 51.2 | 4.08e-6 | NR | KAJ1618496.1 | 483367 | g8824 | i0 | 80.6 | 1.10204081632653 | 36 | 6 | 55.1 | 1 | 1 | 108 | 89 | 123 | KAJ1618496.1 cyclophilin-type peptidyl-prolyl cis-trans isomerase [Pavlovales sp. CCMP2436] | diamond | 216 | 51.6 | 0.992248062015504 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 27214034 | 27214034 | PRJNA915212_P_NODE_2042_length_463_cov_1.031401_g2007_i0 | PRJNA915212 | 2042 | 463 | 1.031401 | 4.77538663 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 53.5 | 6.92e-5 | NR | KAL1523862.1 | 97485 | g2007 | i0 | 28.6 | 1.98920086393089 | 161 | 92 | 99.1 | 4 | 459 | 1 | 811 | 956 | KAL1523862.1 hypothetical protein AB1Y20_018781 [Prymnesium parvum] | diamond | 921 | 53.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28231817 | 28231817 | PRJNA915212_P_NODE_11326_length_170_cov_1.264463_g11288_i0 | PRJNA915212 | 11326 | 170 | 1.264463 | 2.1495871 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.8 | 9.64e-19 | NR | XP_005770755.1 | 280463 | g11288 | i0 | 61.7 | 2.04705882352941 | 60 | 19 | 98.8 | 1 | 1 | 168 | 155 | 214 | XP_005770755.1 MAP kinase [Emiliania huxleyi CCMP1516] | diamond | 348 | 87.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 28824391 | 28824391 | PRJNA915212_P_NODE_12808_length_165_cov_0.879310_g12770_i0 | PRJNA915212 | 12808 | 165 | 0.87931 | 1.4508615 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 50.1 | 3.33e-5 | NR | KAL1530387.1 | 97485 | g12770 | i0 | 35.2 | 1.92727272727273 | 54 | 35 | 98.2 | 0 | 2 | 163 | 700 | 753 | KAL1530387.1 hypothetical protein AB1Y20_001294 [Prymnesium parvum] | diamond | 318 | 50.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29242501 | 29242501 | PRJNA915212_P_NODE_2209_length_443_cov_1.210660_g2173_i0 | PRJNA915212 | 2209 | 443 | 1.21066 | 5.3632238 | root | 1 | Root_unresolved | Root_unresolved | 121 | 9.14e-29 | NR | KAJ1640353.1 | 483367 | g2173 | i0 | 41.1 | 9.98871331828443 | 146 | 83 | 98.9 | 1 | 443 | 6 | 74 | 216 | KAJ1640353.1 glutamine synthetase type III N terminal-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 4425 | 121 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 29455779 | 29455779 | PRJNA915212_P_NODE_10010_length_183_cov_1.141791_g9972_i0 | PRJNA915212 | 10010 | 183 | 1.141791 | 2.08947753 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 52.8 | 9.82e-7 | NR | KAG8458175.1 | 2081491 | g9972 | i0 | 60 | 2.62295081967213 | 40 | 16 | 65.6 | 0 | 181 | 62 | 49 | 88 | KAG8458175.1 hypothetical protein KFE25_011706 [Diacronema lutheri] | diamond | 480 | 52.8 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29582116 | 29582116 | PRJNA915212_P_NODE_8430_length_200_cov_1.827815_g8392_i0 | PRJNA915212 | 8430 | 200 | 1.827815 | 3.65563 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 58.2 | 7.65e-8 | NR | KAJ1640353.1 | 483367 | g8392 | i0 | 45.5 | 0.99 | 66 | 33 | 99 | 1 | 3 | 200 | 96 | 158 | KAJ1640353.1 glutamine synthetase type III N terminal-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 198 | 58.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 29993088 | 29993088 | PRJNA915212_P_NODE_7831_length_209_cov_0.806250_g7793_i0 | PRJNA915212 | 7831 | 209 | 0.80625 | 1.6850625 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 95.9 | 2.5600000000000003e-22 | NR | KAJ1617104.1 | 483367 | g7793 | i0 | 60.9 | 2.92822966507177 | 69 | 27 | 99 | 0 | 209 | 3 | 85 | 153 | KAJ1617104.1 nucleotide-diphospho-sugar transferase, partial [Pavlovales sp. CCMP2436] | diamond | 612 | 95.9 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 30056035 | 30056035 | PRJNA915212_P_NODE_13791_length_163_cov_0.894737_g13753_i0 | PRJNA915212 | 13791 | 163 | 0.894737 | 1.45842131 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 77.8 | 2.8e-15 | NR | KAG8466066.1 | 2081491 | g13753 | i0 | 64.2 | 0.975460122699387 | 53 | 19 | 97.5 | 0 | 159 | 1 | 47 | 99 | KAG8466066.1 hypothetical protein KFE25_005636 [Diacronema lutheri] | diamond | 159 | 77.8 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30119251 | 30119251 | PRJNA915212_P_NODE_8932_length_195_cov_1.047945_g8894_i0 | PRJNA915212 | 8932 | 195 | 1.047945 | 2.04349275 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 91.3 | 6.76e-20 | NR | XP_005776995.1 | 280463 | g8894 | i0 | 69.1 | 1.69230769230769 | 55 | 17 | 84.6 | 0 | 3 | 167 | 309 | 363 | XP_005776995.1 hypothetical protein EMIHUDRAFT_427101 [Emiliania huxleyi CCMP1516] | diamond | 330 | 91.3 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31225094 | 31225094 | PRJNA915212_P_NODE_3095_length_361_cov_3.769231_g3058_i0 | PRJNA915212 | 3095 | 361 | 3.769231 | 13.60692391 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 93.6 | 6.43e-22 | NR | XP_005782836.1 | 280463 | g3058 | i0 | 51 | 6.8393351800554 | 102 | 46 | 83.9 | 2 | 345 | 43 | 16 | 114 | XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] | diamond | 2469 | 93.6 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31517393 | 31517393 | PRJNA915212_P_NODE_8876_length_196_cov_0.789116_g8838_i0 | PRJNA915212 | 8876 | 196 | 0.789116 | 1.54666736 | Pavlovophyceae | 3435358 | Haptophyta | other_Eukaryota | 87.4 | 7.51e-20 | NR | Q43362.1 | 13221 | g8838 | i0 | 66.2 | 6.84183673469388 | 65 | 21 | 99.5 | 1 | 195 | 1 | 26 | 89 | Q43362.1 RecName: Full=V-type proton ATPase 16 kDa proteolipid subunit; Short=V-ATPase 16 kDa proteolipid subunit; AltName: Full=Vacuolar proton pump 16 kDa proteolipid subunit [Chrysotila carterae] | diamond | 1341 | 87.8 | 0.995444191343964 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Chrysotila | Chrysotila carterae | |||
| 32269373 | 32269373 | PRJNA915212_P_NODE_6638_length_227_cov_1.432584_g6600_i0 | PRJNA915212 | 6638 | 227 | 1.432584 | 3.25196568 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 45.8 | 0.00168 | NR | KAL1518803.1 | 97485 | g6600 | i0 | 43.1 | 1.44052863436123 | 51 | 29 | 67.4 | 0 | 206 | 54 | 141 | 191 | KAL1518803.1 hypothetical protein AB1Y20_003083 [Prymnesium parvum] | diamond | 327 | 45.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32592913 | 32592913 | PRJNA915212_P_NODE_2399_length_423_cov_2.032086_g2363_i0 | PRJNA915212 | 2399 | 423 | 2.032086 | 8.59572378 | Viridiplantae | 33090 | Haptophyta | other_Eukaryota | 126 | 1.19e-30 | NR | KAL1495795.1 | 97485 | g2363 | i0 | 55.7 | 2.17730496453901 | 106 | 47 | 75.2 | 0 | 320 | 3 | 298 | 403 | KAL1495795.1 hypothetical protein AB1Y20_016656 [Prymnesium parvum] | diamond | 921 | 126 | 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);;