contig_metadata
12 rows where bioproject = "PRJNA944406", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3474872 | 3474872 | PRJNA944406_P_NODE_107123_length_241_cov_0.916667_g106164_i0 | PRJNA944406 | 107123 | 241 | 0.916667 | 2.20916747 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 211 | 3.38e-50 | NTclustered | gi|551565063|ref|XM_005768979.1| | 280463 | g106164 | i0 | 82.645 | 11.5643153526971 | 242 | 38 | 99 | 4 | 1 | 240 | 344 | 583 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 2787 | 211 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 8577010 | 8577010 | PRJNA944406_P_NODE_101307_length_243_cov_0.905882_g100348_i0 | PRJNA944406 | 101307 | 243 | 0.905882 | 2.20129326 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 150 | 7.55e-32 | NTclustered | gi|551562710|ref|XM_005768053.1| | 280463 | g100348 | i0 | 85.034 | 5.67901234567901 | 147 | 22 | 60 | 0 | 77 | 223 | 247 | 393 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 1380 | 150 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 22601337 | 22601337 | PRJNA944406_P_NODE_18278_length_307_cov_1.311966_g17319_i0 | PRJNA944406 | 18278 | 307 | 1.311966 | 4.02773562 | Chrysotila carterae | 13221 | Haptophyta | other_Eukaryota | 150 | 9.869999999999998e-32 | NTclustered | gi|2429804553|ref|NC_069636.1| | 13221 | g17319 | i0 | 89.831 | 39.0293159609121 | 118 | 10 | 38 | 2 | 65 | 180 | 33443 | 33560 | Chrysotila carterae chloroplast, complete genome | blastn | 11982 | 150 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Chrysotila | Chrysotila carterae | |||
| 27189987 | 27189987 | PRJNA944406_P_NODE_68622_length_250_cov_0.870056_g67663_i0 | PRJNA944406 | 68622 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 59.3 | 5.98e-8 | NR | KAL1526235.1 | 97485 | g67663 | i0 | 43.8 | 1.764 | 73 | 41 | 87.6 | 0 | 4 | 222 | 720 | 792 | KAL1526235.1 hypothetical protein AB1Y20_014957 [Prymnesium parvum] | diamond | 441 | 59.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27783634 | 27783634 | PRJNA944406_P_NODE_17944_length_309_cov_1.872881_g16985_i0 | PRJNA944406 | 17944 | 309 | 1.872881 | 5.78720229 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 70.9 | 8.53e-14 | NR | KOO35440.1 | 1460289 | g16985 | i0 | 61.9 | 2.44660194174757 | 63 | 24 | 61.2 | 0 | 1 | 189 | 4 | 66 | KOO35440.1 40s ribosomal protein s30 [Chrysochromulina tobinii] | diamond | 756 | 70.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 28067608 | 28067608 | PRJNA944406_P_NODE_38945_length_273_cov_1.955000_g37986_i0 | PRJNA944406 | 38945 | 273 | 1.955 | 5.33715 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 75.1 | 1.09e-15 | NR | KAJ1628734.1 | 483367 | g37986 | i0 | 65 | 1.36263736263736 | 60 | 20 | 64.8 | 1 | 1 | 177 | 1 | 60 | KAJ1628734.1 ribosomal protein S30 [Pavlovales sp. CCMP2436] | diamond | 372 | 75.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28604404 | 28604404 | PRJNA944406_P_NODE_11207_length_373_cov_1.790000_g10248_i0 | PRJNA944406 | 11207 | 373 | 1.79 | 6.6767 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 97.4 | 6.079999999999999e-23 | NR | KOO22770.1 | 1460289 | g10248 | i0 | 53 | 0.804289544235925 | 100 | 46 | 80.4 | 1 | 301 | 2 | 9 | 107 | KOO22770.1 40s ribosomal protein [Chrysochromulina tobinii] | diamond | 300 | 97.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29084919 | 29084919 | PRJNA944406_P_NODE_47068_length_266_cov_1.378238_g46109_i0 | PRJNA944406 | 47068 | 266 | 1.378238 | 3.66611308 | Prymnesiales | 73028 | Haptophyta | other_Eukaryota | 139 | 2.16e-36 | NR | KAL1495812.1 | 97485 | g46109 | i0 | 74.4 | 2.90977443609023 | 86 | 22 | 97 | 0 | 2 | 259 | 422 | 507 | KAL1495812.1 hypothetical protein AB1Y20_016672 [Prymnesium parvum] | diamond | 774 | 139 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29993854 | 29993854 | PRJNA944406_P_NODE_53431_length_260_cov_1.465241_g52472_i0 | PRJNA944406 | 53431 | 260 | 1.465241 | 3.8096266 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 58.2 | 8.48e-8 | NR | KAL3910137.1 | 2812485 | g52472 | i0 | 36.6 | 0.819230769230769 | 71 | 45 | 81.9 | 0 | 244 | 32 | 138 | 208 | KAL3910137.1 MAG: hypothetical protein SGPRY_009169, partial [Prymnesium sp.] | diamond | 213 | 58.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 30310198 | 30310198 | PRJNA944406_P_NODE_32752_length_279_cov_1.495146_g31793_i0 | PRJNA944406 | 32752 | 279 | 1.495146 | 4.17145734 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 114 | 4.0400000000000005e-27 | NR | KAG8461052.1 | 2081491 | g31793 | i0 | 63.4 | 12.741935483871 | 93 | 33 | 100 | 1 | 279 | 1 | 414 | 505 | KAG8461052.1 hypothetical protein KFE25_003621 [Diacronema lutheri] | diamond | 3555 | 114 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30758853 | 30758853 | PRJNA944406_P_NODE_71154_length_249_cov_2.448864_g70195_i0 | PRJNA944406 | 71154 | 249 | 2.448864 | 6.09767136 | root | 1 | Root_unresolved | Root_unresolved | 97.8 | 1.6e-21 | NR | XP_005786291.1 | 280463 | g70195 | i0 | 58.5 | 6.80722891566265 | 82 | 32 | 98.8 | 1 | 3 | 248 | 343 | 422 | XP_005786291.1 hypothetical protein EMIHUDRAFT_455687 [Emiliania huxleyi CCMP1516] | diamond | 1695 | 97.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 32270058 | 32270058 | PRJNA944406_P_NODE_103798_length_242_cov_0.911243_g102839_i0 | PRJNA944406 | 103798 | 242 | 0.911243 | 2.20520806 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 92.8 | 1.4e-21 | NR | KAL3902345.1 | 2812485 | g102839 | i0 | 58.3 | 1.79752066115702 | 72 | 30 | 89.3 | 0 | 2 | 217 | 83 | 154 | KAL3902345.1 MAG: hypothetical protein SGPRY_012103 [Prymnesium sp.] | diamond | 435 | 92.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. |
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);;