contig_metadata
15 rows where bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1726943 | 1726943 | PRJNA492406_P_NODE_11062_length_372_cov_2.872910_g10763_i0 | PRJNA492406 | 11062 | 372 | 2.87291 | 10.6872252 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 122 | 5.43e-33 | NR | XP_005765065.1 | 280463 | g10763 | i0 | 57.1 | 0.959677419354839 | 119 | 46 | 96 | 2 | 357 | 1 | 2 | 115 | XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516] | diamond | 357 | 122 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 1727586 | 1727586 | PRJNA492406_P_NODE_7562_length_440_cov_179.416894_g7263_i0 | PRJNA492406 | 7562 | 440 | 179.416894 | 789.4343336 | Acanthocystis sp. NZ2 | 299878 | Root_unresolved | Root_unresolved | 455 | 2.7700000000000003e-123 | NTclustered | gi|55469155|gb|AY749628.1| | 299878 | g7263 | i0 | 85.652 | 31.7590909090909 | 460 | 34 | 100 | 21 | 1 | 440 | 685 | 1132 | Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence | blastn | 13974 | 455 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Acanthocystidae | Acanthocystis | Acanthocystis sp. NZ2 | |||
| 3003594 | 3003594 | PRJNA492406_P_NODE_9743_length_393_cov_13.118750_g9444_i0 | PRJNA492406 | 9743 | 393 | 13.11875 | 51.5566875 | Acanthocystis sp. NZ2 | 299878 | Root_unresolved | Root_unresolved | 532 | 1.0999999999999996e-146 | NTclustered | gi|55469155|gb|AY749628.1| | 299878 | g9444 | i0 | 91.133 | 62.381679389313 | 406 | 17 | 100 | 13 | 1 | 393 | 35 | 434 | Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence | blastn | 24516 | 532 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Acanthocystidae | Acanthocystis | Acanthocystis sp. NZ2 | |||
| 9380616 | 9380616 | PRJNA492406_P_NODE_4448_length_566_cov_22.805274_g4153_i0 | PRJNA492406 | 4448 | 566 | 22.805274 | 129.07785084 | Acanthocystis sp. NZ2 | 299878 | Root_unresolved | Root_unresolved | 621 | 3.39e-173 | NTclustered | gi|55469155|gb|AY749628.1| | 299878 | g4153 | i0 | 87.612 | 83.8515901060071 | 557 | 41 | 94 | 21 | 1 | 534 | 1683 | 2234 | Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence | blastn | 47460 | 621 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Acanthocystidae | Acanthocystis | Acanthocystis sp. NZ2 | |||
| 11930829 | 11930829 | PRJNA492406_P_NODE_11130_length_371_cov_11.573826_g10831_i0 | PRJNA492406 | 11130 | 371 | 11.573826 | 42.93889446 | Oxnerella micra | 1147772 | Root_unresolved | Root_unresolved | 163 | 1.5599999999999998e-35 | NTclustered | gi|375582525|gb|JQ245080.1| | 1147772 | g10831 | i0 | 96.907 | 333.175202156334 | 97 | 3 | 26 | 0 | 275 | 371 | 2146 | 2242 | Oxnerella micra 28S ribosomal RNA gene, partial sequence | blastn | 123608 | 163 | 1 | Eukaryota | Haptista | Centroplasthelida | Pterocystida | Oxnerellidae | Oxnerella | Oxnerella micra | |||
| 15755088 | 15755088 | PRJNA492406_P_NODE_21613_length_276_cov_0.906404_g21314_i0 | PRJNA492406 | 21613 | 276 | 0.906404 | 2.50167504 | Marophrys sp. SRT127 | 2488311 | Root_unresolved | Root_unresolved | 142 | 1.1299999999999998e-41 | NR | BBH42927.1 | 2488311 | g21314 | i0 | 78.8 | 0.923913043478261 | 85 | 18 | 92.4 | 0 | 1 | 255 | 22 | 106 | BBH42927.1 30S ribosomal protein S12 [Marophrys sp. SRT127] | diamond | 255 | 142 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Marophrys | Marophrys sp. SRT127 | ||||
| 20854121 | 20854121 | PRJNA492406_P_NODE_21717_length_275_cov_1.495050_g21418_i0 | PRJNA492406 | 21717 | 275 | 1.49505 | 4.1113875 | Marophrys sp. SRT127 | 2488311 | Root_unresolved | Root_unresolved | 159 | 8.96e-44 | NR | BBH42912.1 | 2488311 | g21418 | i0 | 87.9 | 0.992727272727273 | 91 | 11 | 99.3 | 0 | 1 | 273 | 166 | 256 | BBH42912.1 ATP synthase F1 subunit alpha [Marophrys sp. SRT127] | diamond | 273 | 159 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Marophrys | Marophrys sp. SRT127 | ||||
| 26855148 | 26855148 | PRJNA492406_P_NODE_14501_length_329_cov_1.656250_g14202_i0 | PRJNA492406 | 14501 | 329 | 1.65625 | 5.4490625 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 142 | 4.799999999999998e-41 | NR | KAJ1638552.1 | 483367 | g14202 | i0 | 73.2 | 3.62917933130699 | 97 | 26 | 88.4 | 0 | 37 | 327 | 10 | 106 | KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436] | diamond | 1194 | 142 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28560866 | 28560866 | PRJNA492406_P_NODE_24287_length_262_cov_1.365079_g23988_i0 | PRJNA492406 | 24287 | 262 | 1.365079 | 3.57650698 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 47.4 | 8.75e-4 | NR | KOO26516.1 | 1460289 | g23988 | i0 | 34.5 | 0.961832061068702 | 84 | 54 | 95 | 1 | 249 | 1 | 21 | 104 | KOO26516.1 hypothetical protein Ctob_003635 [Chrysochromulina tobinii] | diamond | 252 | 47.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 28734639 | 28734639 | PRJNA492406_P_NODE_18967_length_288_cov_1.381395_g18668_i0 | PRJNA492406 | 18967 | 288 | 1.381395 | 3.9784176 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62 | 1.12e-8 | NR | KAG8459797.1 | 2081491 | g18668 | i0 | 53.7 | 5.20833333333333 | 67 | 30 | 69.8 | 1 | 287 | 87 | 4440 | 4505 | KAG8459797.1 hypothetical protein KFE25_014360 [Diacronema lutheri] | diamond | 1500 | 62.4 | 0.993589743589744 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29902981 | 29902981 | PRJNA492406_P_NODE_24211_length_262_cov_1.873016_g23912_i0 | PRJNA492406 | 24211 | 262 | 1.873016 | 4.90730192 | Prymnesiales | 73028 | Haptophyta | other_Eukaryota | 124 | 7.4299999999999995e-31 | NR | KAL1512226.1 | 97485 | g23912 | i0 | 67.8 | 1.99236641221374 | 87 | 28 | 99.6 | 0 | 261 | 1 | 4774 | 4860 | KAL1512226.1 hypothetical protein AB1Y20_005488 [Prymnesium parvum] | diamond | 522 | 124 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31118785 | 31118785 | PRJNA492406_P_NODE_21995_length_273_cov_2.995000_g21696_i0 | PRJNA492406 | 21995 | 273 | 2.995 | 8.17635 | Raphidocystis contractilis | 2792838 | Root_unresolved | Root_unresolved | 154 | 1.0599999999999999e-42 | NR | BAG54797.1 | 2792838 | g21696 | i0 | 81.1 | 1.96703296703297 | 90 | 17 | 98.9 | 0 | 271 | 2 | 219 | 308 | BAG54797.1 translation elongation factor-like protein, partial [Raphidocystis contractilis] | diamond | 537 | 154 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Raphidocystidae | Raphidocystis | Raphidocystis contractilis | |||
| 31340360 | 31340360 | PRJNA492406_P_NODE_20116_length_283_cov_1.200000_g19817_i0 | PRJNA492406 | 20116 | 283 | 1.2 | 3.396 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 51.6 | 4.29e-5 | NR | KAL1495751.1 | 97485 | g19817 | i0 | 69.7 | 2.63957597173145 | 33 | 10 | 35 | 0 | 180 | 278 | 1 | 33 | KAL1495751.1 hypothetical protein AB1Y20_016613 [Prymnesium parvum] | diamond | 747 | 51.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32258146 | 32258146 | PRJNA492406_P_NODE_32518_length_234_cov_4.807453_g32219_i0 | PRJNA492406 | 32518 | 234 | 4.807453 | 11.24944002 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 55.8 | 8.11e-7 | NR | KAG8470448.1 | 2081491 | g32219 | i0 | 39.7 | 1.66666666666667 | 68 | 41 | 87.2 | 0 | 30 | 233 | 404 | 471 | KAG8470448.1 hypothetical protein KFE25_008869 [Diacronema lutheri] | diamond | 390 | 55.8 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 32636862 | 32636862 | PRJNA492406_P_NODE_30400_length_244_cov_0.900585_g30101_i0 | PRJNA492406 | 30400 | 244 | 0.900585 | 2.1974274 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 60.8 | 1.6e-8 | NR | KAL1510237.1 | 97485 | g30101 | i0 | 40.7 | 0.995901639344262 | 81 | 47 | 99.6 | 1 | 243 | 1 | 918 | 997 | KAL1510237.1 hypothetical protein AB1Y20_006563 [Prymnesium parvum] | diamond | 243 | 60.8 | 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);;