contig_metadata
16 rows where bioproject = "PRJEB76780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138740 | 138740 | PRJEB76780_P_NODE_5281_length_352_cov_1.612903_g5181_i0 | PRJEB76780 | 5281 | 352 | 1.612903 | 5.67741856 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 154 | 1.9299999999999994e-42 | NR | XP_005764372.1 | 280463 | g5181 | i0 | 61.5 | 4.96022727272727 | 117 | 45 | 99.7 | 0 | 1 | 351 | 261 | 377 | XP_005764372.1 aspartate aminotransferase [Emiliania huxleyi CCMP1516] | diamond | 1746 | 154 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 2688833 | 2688833 | PRJEB76780_P_NODE_2383_length_534_cov_3.822126_g2283_i0 | PRJEB76780 | 2383 | 534 | 3.822126 | 20.41015284 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 174 | 3.21e-52 | NR | KAG8461003.1 | 2081491 | g2283 | i0 | 57.6 | 1.76404494382022 | 158 | 60 | 86.5 | 3 | 516 | 55 | 8 | 162 | KAG8461003.1 hypothetical protein KFE25_010754 [Diacronema lutheri] | diamond | 942 | 174 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 4824492 | 4824492 | PRJEB76780_P_NODE_1144_length_775_cov_1.562678_g1055_i0 | PRJEB76780 | 1144 | 775 | 1.562678 | 12.1107545 | Chrysotila carterae | 13221 | Haptophyta | other_Eukaryota | 191 | 8.72e-58 | NR | Q43362.1 | 13221 | g1055 | i0 | 71.3 | 0.607741935483871 | 157 | 45 | 60.8 | 0 | 143 | 613 | 8 | 164 | 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 | 471 | 191 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Chrysotila | Chrysotila carterae | |||
| 6516878 | 6516878 | PRJEB76780_P_NODE_11766_length_248_cov_0.891429_g11666_i0 | PRJEB76780 | 11766 | 248 | 0.891429 | 2.21074392 | Pavlovophyceae | 3435358 | Haptophyta | other_Eukaryota | 145 | 4.1699999999999996e-39 | NR | XP_005769036.1 | 280463 | g11666 | i0 | 84.1 | 26.5161290322581 | 82 | 13 | 99.2 | 0 | 248 | 3 | 115 | 196 | XP_005769036.1 hypothetical protein EMIHUDRAFT_419452 [Emiliania huxleyi CCMP1516] | diamond | 6576 | 146 | 0.993150684931507 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 12892243 | 12892243 | PRJEB76780_P_NODE_2751_length_496_cov_4.569740_g2651_i0 | PRJEB76780 | 2751 | 496 | 4.56974 | 22.6659104 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 211 | 3.989999999999999e-67 | NR | KAG8463427.1 | 2081491 | g2651 | i0 | 66.9 | 43.0040322580645 | 151 | 50 | 91.3 | 0 | 4 | 456 | 3 | 153 | KAG8463427.1 hypothetical protein KFE25_004938 [Diacronema lutheri] | diamond | 21330 | 211 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 15024323 | 15024323 | PRJEB76780_P_NODE_9752_length_260_cov_1.251337_g9652_i0 | PRJEB76780 | 9752 | 260 | 1.251337 | 3.2534762 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 207 | 4.78e-49 | NTclustered | gi|551568843|ref|XM_005770320.1| | 280463 | g9652 | i0 | 81.967 | 91.7192307692308 | 244 | 44 | 94 | 0 | 17 | 260 | 474 | 231 | Emiliania huxleyi CCMP1516 peptidyl-prolyl isomerase (CYPB1), mRNA | blastn | 23847 | 207 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26685921 | 26685921 | PRJEB76780_P_NODE_11361_length_249_cov_0.886364_g11261_i0 | PRJEB76780 | 11361 | 249 | 0.886364 | 2.20704636 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 98.6 | 8.1800000000000005e-22 | NR | KAL1504879.1 | 97485 | g11261 | i0 | 64.6 | 1.90361445783133 | 79 | 28 | 95.2 | 0 | 248 | 12 | 378 | 456 | KAL1504879.1 hypothetical protein AB1Y20_008649 [Prymnesium parvum] | diamond | 474 | 98.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27192141 | 27192141 | PRJEB76780_P_NODE_6982_length_306_cov_1.004292_g6882_i0 | PRJEB76780 | 6982 | 306 | 1.004292 | 3.07313352 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 55.1 | 3.71e-6 | NR | KAJ1629873.1 | 483367 | g6882 | i0 | 37.9 | 0.931372549019608 | 95 | 56 | 93.1 | 2 | 287 | 3 | 77 | 168 | KAJ1629873.1 hypothetical protein T492DRAFT_107225 [Pavlovales sp. CCMP2436] | diamond | 285 | 55.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 27223691 | 27223691 | PRJEB76780_P_NODE_9903_length_258_cov_1.097297_g9803_i0 | PRJEB76780 | 9903 | 258 | 1.097297 | 2.83102626 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 69.3 | 3.76e-12 | NR | KAL1495917.1 | 97485 | g9803 | i0 | 61.4 | 1.02325581395349 | 44 | 17 | 51.2 | 0 | 250 | 119 | 95 | 138 | KAL1495917.1 hypothetical protein AB1Y20_014559 [Prymnesium parvum] | diamond | 264 | 69.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27666271 | 27666271 | PRJEB76780_P_NODE_2844_length_489_cov_1.336538_g2744_i0 | PRJEB76780 | 2844 | 489 | 1.336538 | 6.53567082 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 93.2 | 1.02e-18 | NR | KAG8469556.1 | 2081491 | g2744 | i0 | 38.6 | 3.50306748466258 | 127 | 70 | 74.2 | 2 | 126 | 488 | 28 | 152 | KAG8469556.1 hypothetical protein KFE25_006011 [Diacronema lutheri] | diamond | 1713 | 93.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29150459 | 29150459 | PRJEB76780_P_NODE_9709_length_260_cov_1.791444_g9609_i0 | PRJEB76780 | 9709 | 260 | 1.791444 | 4.6577544 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 92.8 | 1.9600000000000003e-21 | NR | KAG8471263.1 | 2081491 | g9609 | i0 | 64.2 | 0.773076923076923 | 67 | 24 | 77.3 | 0 | 60 | 260 | 8 | 74 | KAG8471263.1 hypothetical protein KFE25_009684 [Diacronema lutheri] | diamond | 201 | 92.8 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29686511 | 29686511 | PRJEB76780_P_NODE_7050_length_304_cov_1.441558_g6950_i0 | PRJEB76780 | 7050 | 304 | 1.441558 | 4.38233632 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 52.4 | 3.19e-5 | NR | KOO28860.1 | 1460289 | g6950 | i0 | 38.6 | 1.92434210526316 | 83 | 46 | 81.9 | 1 | 266 | 18 | 587 | 664 | KOO28860.1 tropomodulin c-terminal half, partial [Chrysochromulina tobinii] | diamond | 585 | 52.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29869045 | 29869045 | PRJEB76780_P_NODE_3531_length_435_cov_1.433702_g3431_i0 | PRJEB76780 | 3531 | 435 | 1.433702 | 6.2366037 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 4.87e-26 | NR | XP_005789617.1 | 280463 | g3431 | i0 | 76.7 | 0.83448275862069 | 60 | 14 | 41.4 | 0 | 6 | 185 | 285 | 344 | XP_005789617.1 GPB1, beta subunit of a heterotrimeric G-protein [Emiliania huxleyi CCMP1516] | diamond | 363 | 111 | 0.990990990990991 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30255730 | 30255730 | PRJEB76780_P_NODE_10372_length_253_cov_0.866667_g10272_i0 | PRJEB76780 | 10372 | 253 | 0.866667 | 2.19266751 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 72.4 | 1.55e-12 | NR | KOO23790.1 | 1460289 | g10272 | i0 | 60.7 | 0.66403162055336 | 56 | 22 | 66.4 | 0 | 82 | 249 | 437 | 492 | KOO23790.1 putative ATP-dependent RNA helicase ddx46-like protein [Chrysochromulina tobinii] | diamond | 168 | 72.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 30382215 | 30382215 | PRJEB76780_P_NODE_10033_length_256_cov_1.278689_g9933_i0 | PRJEB76780 | 10033 | 256 | 1.278689 | 3.27344384 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 119 | 1.32e-29 | NR | KAG8468125.1 | 2081491 | g9933 | i0 | 61.9 | 0.984375 | 84 | 32 | 98.4 | 0 | 3 | 254 | 152 | 235 | KAG8468125.1 hypothetical protein KFE25_007177 [Diacronema lutheri] | diamond | 252 | 119 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 31582999 | 31582999 | PRJEB76780_P_NODE_11816_length_247_cov_1.701149_g11716_i0 | PRJEB76780 | 11816 | 247 | 1.701149 | 4.20183803 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 48.5 | 3.16e-4 | NR | KAL1512063.1 | 97485 | g11716 | i0 | 31.5 | 1.38461538461538 | 73 | 46 | 83.8 | 1 | 1 | 207 | 198 | 270 | KAL1512063.1 hypothetical protein AB1Y20_005336 [Prymnesium parvum] | diamond | 342 | 48.5 | 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);;