contig_metadata
18 rows where bioproject = "PRJNA884104" and tax_phylum = "Perkinsozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 861046 | 861046 | PRJNA884104_S_NODE_53661_length_286_cov_0.859155_g52918_i0 | PRJNA884104 | 53661 | 286 | 0.859155 | 2.4571833 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 8.77e-33 | NR | KAF4753086.1 | 32597 | g52918 | i0 | 67.4 | 6.76573426573427 | 92 | 30 | 96.5 | 0 | 1 | 276 | 301 | 392 | KAF4753086.1 hypothetical protein FOZ62_001837 [Perkinsus olseni] | diamond | 1935 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 3411529 | 3411529 | PRJNA884104_S_NODE_42403_length_319_cov_1.052846_g41660_i0 | PRJNA884104 | 42403 | 319 | 1.052846 | 3.35857874 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 1.7e-37 | NR | KAF4671046.1 | 32597 | g41660 | i0 | 64.2 | 8.9435736677116 | 106 | 37 | 98.7 | 1 | 3 | 317 | 192 | 297 | KAF4671046.1 hypothetical protein FOZ61_006864 [Perkinsus olseni] | diamond | 2853 | 141 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 4688863 | 4688863 | PRJNA884104_S_NODE_28284_length_383_cov_0.993548_g27541_i0 | PRJNA884104 | 28284 | 383 | 0.993548 | 3.80528884 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 2.3399999999999998e-60 | NR | KAF4692848.1 | 32597 | g27541 | i0 | 71.5 | 27.0548302872063 | 130 | 34 | 99.5 | 1 | 2 | 382 | 265 | 394 | KAF4692848.1 Isocitrate dehydrogenase [NADP], mitochondrial precursor (Oxalosuccinate decarboxylase) [Perkinsus olseni] | diamond | 10362 | 202 | 0.99009900990099 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 13613830 | 13613830 | PRJNA884104_S_NODE_13771_length_542_cov_2.381663_g13037_i0 | PRJNA884104 | 13771 | 542 | 2.381663 | 12.90861346 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 9.45e-89 | NR | XP_002774056.1 | 423536 | g13037 | i0 | 71.5 | 0.990774907749078 | 179 | 49 | 98 | 1 | 533 | 3 | 77 | 255 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 537 | 272 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 13613917 | 13613917 | PRJNA884104_S_NODE_18811_length_465_cov_1.178571_g18068_i0 | PRJNA884104 | 18811 | 465 | 1.178571 | 5.48035515 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 242 | 1.27e-76 | NR | KAF4654509.1 | 32597 | g18068 | i0 | 77.3 | 7.94193548387097 | 154 | 34 | 99.4 | 1 | 464 | 3 | 148 | 300 | KAF4654509.1 hypothetical protein FOZ61_008231, partial [Perkinsus olseni] | diamond | 3693 | 244 | 0.991803278688525 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 13614208 | 13614208 | PRJNA884104_S_NODE_34111_length_351_cov_1.550360_g33368_i0 | PRJNA884104 | 34111 | 351 | 1.55036 | 5.4417636 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 3.05e-62 | NTclustered | gi|294891115|ref|XM_002773382.1| | 423536 | g33368 | i0 | 84.98 | 69.9430199430199 | 253 | 32 | 71 | 5 | 41 | 290 | 189 | 438 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 24550 | 252 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 21643380 | 21643380 | PRJNA884104_S_NODE_22757_length_424_cov_1.236467_g22014_i0 | PRJNA884104 | 22757 | 424 | 1.236467 | 5.24262008 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 5.2699999999999996e-74 | NR | KAF4736119.1 | 32597 | g22014 | i0 | 76.4 | 13.7334905660377 | 140 | 33 | 99.1 | 0 | 422 | 3 | 305 | 444 | KAF4736119.1 hypothetical protein FOZ63_013661, partial [Perkinsus olseni] | diamond | 5823 | 242 | 0.995867768595041 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 22537433 | 22537433 | PRJNA884104_S_NODE_36998_length_339_cov_0.868421_g36255_i0 | PRJNA884104 | 36998 | 339 | 0.868421 | 2.94394719 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.3799999999999996e-55 | NTclustered | gi|294945377|ref|XM_002784604.1| | 423536 | g36255 | i0 | 79.412 | 82.1327433628319 | 340 | 59 | 100 | 6 | 1 | 339 | 1426 | 1097 | Perkinsus marinus ATCC 50983 heat shock protein,, putative, mRNA | blastn | 27843 | 230 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26675243 | 26675243 | PRJNA884104_S_NODE_18801_length_465_cov_1.446429_g18058_i0 | PRJNA884104 | 18801 | 465 | 1.446429 | 6.72589485 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 2.59e-16 | NR | XP_002784356.1 | 423536 | g18058 | i0 | 31.8 | 1.73548387096774 | 129 | 88 | 83.2 | 0 | 421 | 35 | 19 | 147 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 807 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26968366 | 26968366 | PRJNA884104_S_NODE_68102_length_251_cov_1.730337_g67359_i0 | PRJNA884104 | 68102 | 251 | 1.730337 | 4.34314587 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 4.36e-4 | NR | XP_002768706.1 | 423536 | g67359 | i0 | 42.1 | 3.87250996015936 | 57 | 33 | 68.1 | 0 | 173 | 3 | 184 | 240 | XP_002768706.1 Acyl-CoA-binding domain-containing protein, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 972 | 48.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27348002 | 27348002 | PRJNA884104_S_NODE_57683_length_275_cov_1.905941_g56940_i0 | PRJNA884104 | 57683 | 275 | 1.905941 | 5.24133775 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.08e-6 | NR | KAF4738466.1 | 32597 | g56940 | i0 | 52.4 | 4.06909090909091 | 42 | 20 | 45.8 | 0 | 2 | 127 | 89 | 130 | KAF4738466.1 hypothetical protein FOZ62_016296 [Perkinsus olseni] | diamond | 1119 | 53.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28161032 | 28161032 | PRJNA884104_S_NODE_25765_length_400_cov_1.097859_g25022_i0 | PRJNA884104 | 25765 | 400 | 1.097859 | 4.391436 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 3.47e-29 | NR | XP_002775694.1 | 423536 | g25022 | i0 | 55.2 | 1.44 | 96 | 36 | 72 | 1 | 1 | 288 | 87 | 175 | XP_002775694.1 ubiquitin-conjugating enzyme E2 J1, putative [Perkinsus marinus ATCC 50983] | diamond | 576 | 117 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28350257 | 28350257 | PRJNA884104_S_NODE_20226_length_448_cov_3.754667_g19483_i0 | PRJNA884104 | 20226 | 448 | 3.754667 | 16.82090816 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.28e-67 | NR | XP_002778466.1 | 423536 | g19483 | i0 | 75.9 | 0.917410714285714 | 137 | 33 | 91.7 | 0 | 35 | 445 | 1 | 137 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 411 | 213 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28508207 | 28508207 | PRJNA884104_S_NODE_12207_length_577_cov_2.123016_g11480_i0 | PRJNA884104 | 12207 | 577 | 2.123016 | 12.24980232 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.42e-35 | NR | KAF4675741.1 | 330153 | g11480 | i0 | 45.5 | 4.62738301559792 | 178 | 95 | 92.5 | 2 | 573 | 40 | 750 | 925 | KAF4675741.1 40S ribosomal protein S3-1 [Perkinsus chesapeaki] | diamond | 2670 | 143 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28634723 | 28634723 | PRJNA884104_S_NODE_54887_length_282_cov_1.904306_g54144_i0 | PRJNA884104 | 54887 | 282 | 1.904306 | 5.37014292 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.6e-16 | NR | KAF4691821.1 | 32597 | g54144 | i0 | 46.2 | 0.968085106382979 | 91 | 49 | 96.8 | 0 | 280 | 8 | 23 | 113 | KAF4691821.1 hypothetical protein FOZ60_014703 [Perkinsus olseni] | diamond | 273 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30505724 | 30505724 | PRJNA884104_S_NODE_40413_length_326_cov_0.913043_g39670_i0 | PRJNA884104 | 40413 | 326 | 0.913043 | 2.97652018 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 1.43e-9 | NR | KAF4680354.1 | 32597 | g39670 | i0 | 36 | 3.69018404907975 | 100 | 57 | 92 | 2 | 22 | 321 | 512 | 604 | KAF4680354.1 hypothetical protein FOZ60_013669 [Perkinsus olseni] | diamond | 1203 | 65.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30813646 | 30813646 | PRJNA884104_S_NODE_21574_length_435_cov_1.718232_g20831_i0 | PRJNA884104 | 21574 | 435 | 1.718232 | 7.4743092 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 2.54e-7 | NR | KAF4676497.1 | 330153 | g20831 | i0 | 50.8 | 2.9448275862069 | 61 | 26 | 40 | 3 | 432 | 259 | 31 | 90 | KAF4676497.1 hypothetical protein FOL47_006135 [Perkinsus chesapeaki] | diamond | 1281 | 58.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31287593 | 31287593 | PRJNA884104_S_NODE_35975_length_343_cov_1.140741_g35232_i0 | PRJNA884104 | 35975 | 343 | 1.140741 | 3.91274163 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 1.88e-34 | NR | XP_002771800.1 | 423536 | g35232 | i0 | 55.9 | 2.91253644314869 | 111 | 49 | 97.1 | 0 | 2 | 334 | 728 | 838 | XP_002771800.1 elongation factor 2, putative [Perkinsus marinus ATCC 50983] | diamond | 999 | 136 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus |
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);;