contig_metadata
25 rows where bioproject = "PRJNA379145", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675402 | 1675402 | PRJNA379145_P_NODE_25482_length_487_cov_7.270925_g23443_i0 | PRJNA379145 | 25482 | 487 | 7.270925 | 35.40940475 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.5799999999999995e-74 | NR | XP_002768542.1 | 423536 | g23443 | i0 | 77.2 | 16.9650924024641 | 145 | 33 | 89.3 | 0 | 7 | 441 | 1 | 145 | XP_002768542.1 ribosomal protein S23, putative [Perkinsus marinus ATCC 50983] | diamond | 8262 | 228 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 3624827 | 3624827 | PRJNA379145_P_NODE_7663_length_1099_cov_7.335835_g6748_i0 | PRJNA379145 | 7663 | 1099 | 7.335835 | 80.62082665 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 476 | 3.689999999999999e-166 | NR | XP_002774056.1 | 423536 | g6748 | i0 | 73.1 | 1.7115559599636 | 312 | 83 | 84.9 | 1 | 61 | 993 | 4 | 315 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 1881 | 476 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 4227752 | 4227752 | PRJNA379145_P_NODE_14544_length_751_cov_2.908078_g12977_i0 | PRJNA379145 | 14544 | 751 | 2.908078 | 21.83966578 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.16e-100 | NR | KAF4677256.1 | 330153 | g12977 | i0 | 70 | 1.55792276964048 | 200 | 58 | 79.1 | 2 | 750 | 157 | 272 | 471 | KAF4677256.1 Cytosolic seryl-tRNA synthetase [Perkinsus chesapeaki] | diamond | 1170 | 309 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27391223 | 27391223 | PRJNA379145_P_NODE_57283_length_199_cov_2.289157_g55129_i0 | PRJNA379145 | 57283 | 199 | 2.289157 | 4.55542243 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 1.02e-4 | NR | XP_002780266.1 | 423536 | g55129 | i0 | 52.1 | 0.723618090452261 | 48 | 23 | 72.4 | 0 | 153 | 10 | 12 | 59 | XP_002780266.1 autophagy 8i, putative [Perkinsus marinus ATCC 50983] | diamond | 144 | 47.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27454370 | 27454370 | PRJNA379145_P_NODE_37583_length_325_cov_1.969178_g35432_i0 | PRJNA379145 | 37583 | 325 | 1.969178 | 6.3998285 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 6.9e-7 | NR | KAF4659857.1 | 330153 | g35432 | i0 | 35.4 | 0.756923076923077 | 82 | 46 | 70.2 | 2 | 320 | 93 | 106 | 186 | KAF4659857.1 nucleosome assembly [Perkinsus chesapeaki] | diamond | 246 | 57 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27660804 | 27660804 | PRJNA379145_P_NODE_33124_length_374_cov_2.513196_g30983_i0 | PRJNA379145 | 33124 | 374 | 2.513196 | 9.39935304 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.06e-20 | NR | ABF58685.1 | 31276 | g30983 | i0 | 45.2 | 6.29679144385027 | 104 | 56 | 83.4 | 1 | 1 | 312 | 25 | 127 | ABF58685.1 delta5-desaturase [Perkinsus marinus] | diamond | 2355 | 96.3 | 0.995846313603323 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27724220 | 27724220 | PRJNA379145_P_NODE_61644_length_183_cov_1.680000_g59490_i0 | PRJNA379145 | 61644 | 183 | 1.68 | 3.0744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 2.2e-9 | NR | KAF4674126.1 | 330153 | g59490 | i0 | 78.8 | 4.18032786885246 | 33 | 7 | 54.1 | 0 | 179 | 81 | 169 | 201 | KAF4674126.1 hypothetical protein FOL47_009663 [Perkinsus chesapeaki] | diamond | 765 | 62 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27896069 | 27896069 | PRJNA379145_P_NODE_2125_length_1852_cov_3.165476_g1817_i0 | PRJNA379145 | 2125 | 1852 | 3.165476 | 58.62461552 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 0.00195 | NR | XP_002777205.1 | 423536 | g1817 | i0 | 20.3 | 0.390388768898488 | 241 | 170 | 37.9 | 7 | 1454 | 753 | 187 | 412 | XP_002777205.1 hypothetical protein Pmar_PMAR007110 [Perkinsus marinus ATCC 50983] | diamond | 723 | 53.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27896151 | 27896151 | PRJNA379145_P_NODE_69045_length_162_cov_1.387597_g66891_i0 | PRJNA379145 | 69045 | 162 | 1.387597 | 2.24790714 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 1.12e-15 | NR | KAF4757831.1 | 32597 | g66891 | i0 | 67.3 | 4.81481481481481 | 52 | 17 | 96.3 | 0 | 161 | 6 | 276 | 327 | KAF4757831.1 hypothetical protein FOZ63_026250, partial [Perkinsus olseni] | diamond | 780 | 79.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28134429 | 28134429 | PRJNA379145_P_NODE_14485_length_753_cov_3.436111_g12920_i0 | PRJNA379145 | 14485 | 753 | 3.436111 | 25.87391583 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 2.34e-49 | NR | KAF4692658.1 | 32597 | g12920 | i0 | 48.8 | 2.52191235059761 | 211 | 106 | 83.3 | 2 | 119 | 745 | 242 | 452 | KAF4692658.1 hypothetical protein FOZ60_012957 [Perkinsus olseni] | diamond | 1899 | 178 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28338284 | 28338284 | PRJNA379145_P_NODE_35506_length_347_cov_1.767516_g33360_i0 | PRJNA379145 | 35506 | 347 | 1.767516 | 6.13328052 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 2.49e-16 | NR | KAF4671380.1 | 32597 | g33360 | i0 | 39.8 | 1.60806916426513 | 93 | 52 | 76.9 | 2 | 61 | 327 | 20 | 112 | KAF4671380.1 hypothetical protein FOZ61_000005 [Perkinsus olseni] | diamond | 558 | 80.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28369784 | 28369784 | PRJNA379145_P_NODE_56286_length_203_cov_1.905882_g54132_i0 | PRJNA379145 | 56286 | 203 | 1.905882 | 3.86894046 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.15e-5 | NR | KAF4670093.1 | 330153 | g54132 | i0 | 84.6 | 0.768472906403941 | 26 | 4 | 38.4 | 0 | 81 | 158 | 309 | 334 | KAF4670093.1 Cu/Pi carrier [Perkinsus chesapeaki] | diamond | 156 | 51.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28607898 | 28607898 | PRJNA379145_P_NODE_55727_length_205_cov_4.494186_g53573_i0 | PRJNA379145 | 55727 | 205 | 4.494186 | 9.2130813 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.63e-18 | NR | KAF4670769.1 | 32597 | g53573 | i0 | 65.5 | 3.39512195121951 | 58 | 20 | 84.9 | 0 | 176 | 3 | 19 | 76 | KAF4670769.1 Sec61p translocation complex subunit [Perkinsus olseni] | diamond | 696 | 82 | 0.995121951219512 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28780145 | 28780145 | PRJNA379145_P_NODE_47007_length_251_cov_2.059633_g44854_i0 | PRJNA379145 | 47007 | 251 | 2.059633 | 5.16967883 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 2.19e-10 | NR | KAF4667596.1 | 330153 | g44854 | i0 | 57.1 | 1.17131474103586 | 49 | 21 | 58.6 | 0 | 246 | 100 | 40 | 88 | KAF4667596.1 AP-4 complex subunit epsilon-1 [Perkinsus chesapeaki] | diamond | 294 | 66.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28969824 | 28969824 | PRJNA379145_P_NODE_62428_length_180_cov_2.319728_g60274_i0 | PRJNA379145 | 62428 | 180 | 2.319728 | 4.1755104 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 39.7 | 0.0241 | NR | XP_002788816.1 | 423536 | g60274 | i0 | 73.1 | 0.433333333333333 | 26 | 7 | 43.3 | 0 | 175 | 98 | 20 | 45 | XP_002788816.1 60S ribosomal protein L37, putative [Perkinsus marinus ATCC 50983] | diamond | 78 | 39.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29207962 | 29207962 | PRJNA379145_P_NODE_15349_length_724_cov_1.781476_g13716_i0 | PRJNA379145 | 15349 | 724 | 1.781476 | 12.89788624 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 3.73e-5 | NR | XP_002777835.1 | 423536 | g13716 | i0 | 30.5 | 1.15193370165746 | 95 | 58 | 39.4 | 1 | 64 | 348 | 758 | 844 | XP_002777835.1 serine-threonine protein kinase, putative [Perkinsus marinus ATCC 50983] | diamond | 834 | 56.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29664017 | 29664017 | PRJNA379145_P_NODE_61250_length_184_cov_2.251656_g59096_i0 | PRJNA379145 | 61250 | 184 | 2.251656 | 4.14304704 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 5.21e-7 | NR | KAF4748654.1 | 32597 | g59096 | i0 | 81.8 | 1.07608695652174 | 33 | 5 | 52.2 | 1 | 97 | 2 | 249 | 281 | KAF4748654.1 hypothetical protein FOZ62_012804, partial [Perkinsus olseni] | diamond | 198 | 55.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29727205 | 29727205 | PRJNA379145_P_NODE_33370_length_371_cov_1.914201_g31228_i0 | PRJNA379145 | 33370 | 371 | 1.914201 | 7.10168571 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 9.61e-10 | NR | KAF4667596.1 | 330153 | g31228 | i0 | 57.1 | 0.792452830188679 | 49 | 21 | 39.6 | 0 | 135 | 281 | 40 | 88 | KAF4667596.1 AP-4 complex subunit epsilon-1 [Perkinsus chesapeaki] | diamond | 294 | 66.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30186669 | 30186669 | PRJNA379145_P_NODE_21052_length_572_cov_1.797774_g19155_i0 | PRJNA379145 | 21052 | 572 | 1.797774 | 10.28326728 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.5e-11 | NR | KAF4738466.1 | 32597 | g19155 | i0 | 37.9 | 3.98601398601399 | 95 | 57 | 49.8 | 1 | 470 | 186 | 38 | 130 | KAF4738466.1 hypothetical protein FOZ62_016296 [Perkinsus olseni] | diamond | 2280 | 69.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30548794 | 30548794 | PRJNA379145_P_NODE_19573_length_606_cov_13.712042_g17722_i0 | PRJNA379145 | 19573 | 606 | 13.712042 | 83.09497452 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.1499999999999997e-84 | NR | XP_002778466.1 | 423536 | g17722 | i0 | 65.1 | 0.95049504950495 | 192 | 66 | 94.6 | 1 | 24 | 596 | 1 | 192 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 576 | 257 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31117324 | 31117324 | PRJNA379145_P_NODE_31575_length_394_cov_8.063712_g29444_i0 | PRJNA379145 | 31575 | 394 | 8.063712 | 31.77102528 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00446 | NR | KAF4665648.1 | 32597 | g29444 | i0 | 38.5 | 0.49492385786802 | 65 | 35 | 49.5 | 1 | 358 | 164 | 1 | 60 | KAF4665648.1 hypothetical protein FOZ61_010655 [Perkinsus olseni] | diamond | 195 | 44.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31148796 | 31148796 | PRJNA379145_P_NODE_58095_length_196_cov_1.766871_g55941_i0 | PRJNA379145 | 58095 | 196 | 1.766871 | 3.46306716 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.53e-5 | NR | KAF4665936.1 | 330153 | g55941 | i0 | 67.6 | 0.520408163265306 | 34 | 11 | 52 | 0 | 50 | 151 | 114 | 147 | KAF4665936.1 hypothetical protein FOL47_004355 [Perkinsus chesapeaki] | diamond | 102 | 51.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31686740 | 31686740 | PRJNA379145_P_NODE_39237_length_310_cov_1.393502_g37086_i0 | PRJNA379145 | 39237 | 310 | 1.393502 | 4.3198562 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.19e-17 | NR | KAF4662129.1 | 32597 | g37086 | i0 | 51.3 | 3.56129032258065 | 76 | 35 | 71.6 | 1 | 88 | 309 | 35 | 110 | KAF4662129.1 hypothetical protein FOZ61_002692 [Perkinsus olseni] | diamond | 1104 | 84.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32572924 | 32572924 | PRJNA379145_P_NODE_25499_length_487_cov_2.841410_g23459_i0 | PRJNA379145 | 25499 | 487 | 2.84141 | 13.8376667 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 9.83e-21 | NR | KAF4696041.1 | 32597 | g23459 | i0 | 82.7 | 0.960985626283368 | 52 | 9 | 32 | 0 | 185 | 30 | 78 | 129 | KAF4696041.1 suppressor of kinetochore protein mutant [Perkinsus olseni] | diamond | 468 | 92.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32652361 | 32652361 | PRJNA379145_P_NODE_36860_length_332_cov_2.571906_g34712_i0 | PRJNA379145 | 36860 | 332 | 2.571906 | 8.53872792 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 1.08e-4 | NR | KAF4663612.1 | 32597 | g34712 | i0 | 37.3 | 5.85542168674699 | 67 | 42 | 60.5 | 0 | 329 | 129 | 101 | 167 | KAF4663612.1 hypothetical protein FOZ61_001514 [Perkinsus olseni] | diamond | 1944 | 51.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
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);;