contig_metadata
9 rows where bioproject = "PRJNA971676", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3495394 | 3495394 | PRJNA971676_P_NODE_2923_length_457_cov_1.898438_g2834_i0 | PRJNA971676 | 2923 | 457 | 1.898438 | 8.67586166 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 124 | 2.64e-33 | NR | XP_005765065.1 | 280463 | g2834 | i0 | 55.6 | 3.02625820568928 | 117 | 48 | 76.8 | 1 | 370 | 20 | 7 | 119 | XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516] | diamond | 1383 | 124 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 8597700 | 8597700 | PRJNA971676_P_NODE_3607_length_417_cov_4.197674_g3518_i0 | PRJNA971676 | 3607 | 417 | 4.197674 | 17.50430058 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 127 | 2.15e-33 | NR | KAJ1635632.1 | 483367 | g3518 | i0 | 53 | 3.80575539568345 | 132 | 62 | 95 | 0 | 396 | 1 | 7 | 138 | KAJ1635632.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 1587 | 127 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 17522836 | 17522836 | PRJNA971676_P_NODE_6414_length_338_cov_2.667925_g6325_i0 | PRJNA971676 | 6414 | 338 | 2.667925 | 9.0175865 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 109 | 1.01e-27 | NR | KAJ1624347.1 | 483367 | g6325 | i0 | 71.4 | 1.4112426035503 | 77 | 22 | 68.3 | 0 | 256 | 26 | 2 | 78 | KAJ1624347.1 V-type ATPase 16 kDa proteolipid subunit [Pavlovales sp. CCMP2436] | diamond | 477 | 109 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 27342245 | 27342245 | PRJNA971676_P_NODE_20123_length_244_cov_1.801170_g20034_i0 | PRJNA971676 | 20123 | 244 | 1.80117 | 4.3948548 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 68.2 | 4.04e-11 | NR | KAL1524241.1 | 97485 | g20034 | i0 | 46.1 | 0.934426229508197 | 76 | 40 | 92.2 | 1 | 7 | 231 | 130 | 205 | KAL1524241.1 hypothetical protein AB1Y20_019146 [Prymnesium parvum] | diamond | 228 | 68.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27531505 | 27531505 | PRJNA971676_P_NODE_19203_length_245_cov_1.465116_g19114_i0 | PRJNA971676 | 19203 | 245 | 1.465116 | 3.5895342 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 42.4 | 0.0497 | NR | KOO30387.1 | 1460289 | g19114 | i0 | 40.7 | 0.722448979591837 | 59 | 34 | 71 | 1 | 177 | 4 | 2 | 60 | KOO30387.1 papain family cysteine protease containing protein [Chrysochromulina tobinii] | diamond | 177 | 42.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 27689800 | 27689800 | PRJNA971676_P_NODE_12424_length_263_cov_1.547368_g12335_i0 | PRJNA971676 | 12424 | 263 | 1.547368 | 4.06957784 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 123 | 4.3e-31 | NR | KOO33834.1 | 1460289 | g12335 | i0 | 64.4 | 1.98479087452471 | 87 | 31 | 99.2 | 0 | 3 | 263 | 225 | 311 | KOO33834.1 cystathione gamma lyase [Chrysochromulina tobinii] | diamond | 522 | 123 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 27752745 | 27752745 | PRJNA971676_P_NODE_9444_length_292_cov_1.698630_g9355_i0 | PRJNA971676 | 9444 | 292 | 1.69863 | 4.9599996 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 63.5 | 3.02e-9 | NR | KAL1524241.1 | 97485 | g9355 | i0 | 43.8 | 1.64383561643836 | 73 | 40 | 75 | 1 | 57 | 275 | 132 | 203 | KAL1524241.1 hypothetical protein AB1Y20_019146 [Prymnesium parvum] | diamond | 480 | 63.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30285396 | 30285396 | PRJNA971676_P_NODE_5652_length_353_cov_1.557143_g5563_i0 | PRJNA971676 | 5652 | 353 | 1.557143 | 5.49671479 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 5.34e-6 | NR | KAL1496131.1 | 97485 | g5563 | i0 | 45.8 | 0.994334277620397 | 59 | 25 | 50.1 | 1 | 174 | 350 | 27 | 78 | KAL1496131.1 hypothetical protein AB1Y20_014752 [Prymnesium parvum] | diamond | 351 | 55.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31707315 | 31707315 | PRJNA971676_P_NODE_16597_length_248_cov_0.880000_g16508_i0 | PRJNA971676 | 16597 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 2.82e-5 | NR | KAL1500475.1 | 97485 | g16508 | i0 | 40.4 | 3.87096774193548 | 47 | 28 | 56.9 | 0 | 245 | 105 | 159 | 205 | KAL1500475.1 hypothetical protein AB1Y20_013132 [Prymnesium parvum] | diamond | 960 | 52 | 0.992307692307692 | 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);;