contig_metadata
8 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4294823 | 4294823 | PRJNA493632_P_NODE_671904_length_237_cov_4.085366_g668463_i0 | PRJNA493632 | 671904 | 237 | 4.085366 | 9.68231742 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|551559913|ref|XM_005766799.1| | 280463 | g668463 | i0 | 100 | 0.118143459915612 | 28 | 0 | 12 | 0 | 147 | 174 | 708 | 681 | Emiliania huxleyi CCMP1516 type II DNA topoisomerase VI subunit A 2 (Top6A), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 10670785 | 10670785 | PRJNA493632_P_NODE_620109_length_243_cov_2.376471_g616668_i0 | PRJNA493632 | 620109 | 243 | 2.376471 | 5.77482453 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 73.1 | 1.68e-8 | NTclustered | gi|551542608|ref|XM_005759434.1| | 280463 | g616668 | i0 | 93.878 | 1.08641975308642 | 49 | 1 | 21 | 2 | 3 | 51 | 1277 | 1231 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 264 | 73.1 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 22141010 | 22141010 | PRJNA493632_P_NODE_472578_length_257_cov_2.429348_g469139_i0 | PRJNA493632 | 472578 | 257 | 2.429348 | 6.24342436 | Dicrateria rotunda | 2703868 | Haptophyta | other_Eukaryota | 183 | 7.949999999999997e-42 | NTclustered | gi|259419544|emb|FN392559.1| | 2703868 | g469139 | i0 | 82.407 | 7.93774319066148 | 216 | 32 | 83 | 5 | 8 | 220 | 258 | 46 | Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 | blastn | 2040 | 183 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Dicrateria | Dicrateria rotunda | |||
| 23411344 | 23411344 | PRJNA493632_P_NODE_168319_length_369_cov_2.368243_g164892_i0 | PRJNA493632 | 168319 | 369 | 2.368243 | 8.73881667 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|551609071|ref|XM_005785712.1| | 280463 | g164892 | i0 | 94.444 | 0.173441734417344 | 36 | 1 | 9 | 1 | 27 | 61 | 1699 | 1734 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26918508 | 26918508 | PRJNA493632_P_NODE_643182_length_242_cov_0.911243_g639741_i0 | PRJNA493632 | 643182 | 242 | 0.911243 | 2.20520806 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 116 | 3.36e-28 | NR | KOO24932.1 | 1460289 | g639741 | i0 | 65 | 0.991735537190083 | 80 | 28 | 99.2 | 0 | 240 | 1 | 409 | 488 | KOO24932.1 beta-hexosaminidase subunit beta-like protein [Chrysochromulina tobinii] | diamond | 240 | 116 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29887235 | 29887235 | PRJNA493632_P_NODE_612831_length_244_cov_0.900585_g609390_i0 | PRJNA493632 | 612831 | 244 | 0.900585 | 2.1974274 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 79.3 | 1.75e-15 | NR | KAL1526508.1 | 97485 | g609390 | i0 | 54.8 | 3.40573770491803 | 62 | 28 | 76.2 | 0 | 192 | 7 | 205 | 266 | KAL1526508.1 hypothetical protein AB1Y20_015218 [Prymnesium parvum] | diamond | 831 | 79.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31040596 | 31040596 | PRJNA493632_P_NODE_402235_length_271_cov_7.469697_g398796_i0 | PRJNA493632 | 402235 | 271 | 7.469697 | 20.24287887 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 2.09e-10 | NR | KAJ1641544.1 | 483367 | g398796 | i0 | 46.2 | 10.5830258302583 | 78 | 39 | 86.3 | 2 | 241 | 8 | 323 | 397 | KAJ1641544.1 hypothetical protein T492DRAFT_920404 [Pavlovales sp. CCMP2436] | diamond | 2868 | 66.6 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 32479757 | 32479757 | PRJNA493632_P_NODE_698939_length_228_cov_2.167742_g695498_i0 | PRJNA493632 | 698939 | 228 | 2.167742 | 4.94245176 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 72 | 1.45e-12 | NR | XP_005783348.1 | 280463 | g695498 | i0 | 40 | 1.97368421052632 | 75 | 45 | 98.7 | 0 | 226 | 2 | 37 | 111 | XP_005783348.1 hypothetical protein EMIHUDRAFT_462781 [Emiliania huxleyi CCMP1516] | diamond | 450 | 72 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi |
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);;