contig_metadata
11 rows where bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12716844 | 12716844 | PRJNA870096_S_NODE_19790_length_407_cov_8.538462_g18134_i0 | PRJNA870096 | 19790 | 407 | 8.5384620000000009 | 34.75154034 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 162 | 4.18e-49 | NR | KAG8458387.1 | 2081491 | g18134 | i0 | 69.5 | 1.52579852579853 | 105 | 32 | 77.4 | 0 | 362 | 48 | 1 | 105 | KAG8458387.1 hypothetical protein KFE25_004528 [Diacronema lutheri] | diamond | 621 | 163 | 0.993865030674847 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 13603651 | 13603651 | PRJNA870096_S_NODE_29691_length_329_cov_1.744755_g28027_i0 | PRJNA870096 | 29691 | 329 | 1.744755 | 5.74024395 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 76.8 | 1.84e-9 | NTclustered | gi|551583056|ref|XM_005776908.1| | 280463 | g28027 | i0 | 85.915 | 0.43161094224924 | 71 | 10 | 22 | 0 | 77 | 147 | 318 | 388 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 142 | 76.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 25076442 | 25076442 | PRJNA870096_S_NODE_64320_length_218_cov_2.840000_g62656_i0 | PRJNA870096 | 64320 | 218 | 2.84 | 6.1912 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 5.8099999999999994e-30 | NR | ALD47920.1 | 2903 | g62656 | i0 | 73.6 | 3.96330275229358 | 72 | 19 | 99.1 | 0 | 218 | 3 | 276 | 347 | ALD47920.1 adaptor protein complex 1 subunit mu [Emiliania huxleyi] | diamond | 864 | 118 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26928658 | 26928658 | PRJNA870096_S_NODE_48102_length_254_cov_2.502370_g46438_i0 | PRJNA870096 | 48102 | 254 | 2.50237 | 6.3560198 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 53.9 | 4.99e-6 | NR | KAL1524590.1 | 97485 | g46438 | i0 | 56.4 | 0.649606299212598 | 55 | 19 | 59.1 | 3 | 26 | 175 | 1005 | 1059 | KAL1524590.1 hypothetical protein AB1Y20_019480 [Prymnesium parvum] | diamond | 165 | 53.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28665948 | 28665948 | PRJNA870096_S_NODE_99827_length_177_cov_1.074627_g98163_i0 | PRJNA870096 | 99827 | 177 | 1.074627 | 1.90208979 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 90.1 | 4.34e-22 | NR | KAG8467831.1 | 2081491 | g98163 | i0 | 70.7 | 2.94915254237288 | 58 | 16 | 98.3 | 1 | 175 | 2 | 10 | 66 | KAG8467831.1 hypothetical protein KFE25_006883 [Diacronema lutheri] | diamond | 522 | 90.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 28823392 | 28823392 | PRJNA870096_S_NODE_128068_length_157_cov_3.368421_g126404_i0 | PRJNA870096 | 128068 | 157 | 3.368421 | 5.28842097 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 50.1 | 2.81e-5 | NR | XP_005765089.1 | 280463 | g126404 | i0 | 58.5 | 1.77707006369427 | 41 | 17 | 78.3 | 0 | 123 | 1 | 207 | 247 | XP_005765089.1 hypothetical protein EMIHUDRAFT_67016 [Emiliania huxleyi CCMP1516] | diamond | 279 | 50.1 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 28989904 | 28989904 | PRJNA870096_S_NODE_80868_length_195_cov_1.578947_g79204_i0 | PRJNA870096 | 80868 | 195 | 1.578947 | 3.07894665 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.9 | 6.14e-17 | NR | XP_005791870.1 | 280463 | g79204 | i0 | 62.7 | 3.06153846153846 | 67 | 23 | 100 | 2 | 195 | 1 | 61 | 127 | XP_005791870.1 hypothetical protein EMIHUDRAFT_448819 [Emiliania huxleyi CCMP1516] | diamond | 597 | 80.9 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 29084468 | 29084468 | PRJNA870096_S_NODE_61048_length_224_cov_2.386740_g59384_i0 | PRJNA870096 | 61048 | 224 | 2.38674 | 5.3462976 | Prymnesium | 35143 | Haptophyta | other_Eukaryota | 50.4 | 5.46e-5 | NR | KAL1516059.1 | 97485 | g59384 | i0 | 38 | 1.84821428571429 | 71 | 42 | 95.1 | 2 | 214 | 2 | 368 | 436 | KAL1516059.1 hypothetical protein AB1Y20_002671 [Prymnesium parvum] | diamond | 414 | 50.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29368566 | 29368566 | PRJNA870096_S_NODE_44109_length_266_cov_3.013453_g42445_i0 | PRJNA870096 | 44109 | 266 | 3.013453 | 8.01578498 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.3 | 2.81e-18 | NR | KAG8462174.1 | 2081491 | g42445 | i0 | 52.3 | 2.0187969924812 | 88 | 41 | 98.1 | 1 | 2 | 262 | 57 | 144 | KAG8462174.1 hypothetical protein KFE25_011624 [Diacronema lutheri] | diamond | 537 | 84.3 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 31991402 | 31991402 | PRJNA870096_S_NODE_79858_length_196_cov_1.849673_g78194_i0 | PRJNA870096 | 79858 | 196 | 1.849673 | 3.62535908 | Pavlovophyceae | 3435358 | Haptophyta | other_Eukaryota | 57.8 | 9.03e-8 | NR | XP_005787842.1 | 280463 | g78194 | i0 | 50.8 | 2.93877551020408 | 65 | 28 | 99.5 | 1 | 1 | 195 | 224 | 284 | XP_005787842.1 hypothetical protein EMIHUDRAFT_352039 [Emiliania huxleyi CCMP1516] | diamond | 576 | 58.2 | 0.993127147766323 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 32899207 | 32899207 | PRJNA870096_S_NODE_49140_length_251_cov_2.149038_g47476_i0 | PRJNA870096 | 49140 | 251 | 2.149038 | 5.39408538 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 58.5 | 4.41e-8 | NR | KOO29770.1 | 1460289 | g47476 | i0 | 64.3 | 1.50597609561753 | 42 | 15 | 50.2 | 0 | 2 | 127 | 148 | 189 | KOO29770.1 peptidyl-prolyl cis-trans isomerase [Chrysochromulina tobinii] | diamond | 378 | 58.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii |
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);;