contig_metadata
18 rows where bioproject = "PRJNA489308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6201254 | 6201254 | PRJNA489308_P_NODE_4305_length_496_cov_4.664303_g4229_i0 | PRJNA489308 | 4305 | 496 | 4.664303 | 23.13494288 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 9.36e-79 | NTclustered | gi|294891115|ref|XM_002773382.1| | 423536 | g4229 | i0 | 82.162 | 77.0241935483871 | 370 | 54 | 73 | 12 | 95 | 458 | 75 | 438 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 38204 | 307 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 14478808 | 14478808 | PRJNA489308_P_NODE_31572_length_250_cov_0.870056_g31496_i0 | PRJNA489308 | 31572 | 250 | 0.870056 | 2.17514 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.9699999999999997e-23 | NR | KAF4685907.1 | 32597 | g31496 | i0 | 52.7 | 4.464 | 93 | 33 | 98.4 | 1 | 248 | 3 | 239 | 331 | KAF4685907.1 Obg-like ATPase [Perkinsus olseni] | diamond | 1116 | 102 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 17027340 | 17027340 | PRJNA489308_P_NODE_11094_length_344_cov_2.339483_g11018_i0 | PRJNA489308 | 11094 | 344 | 2.339483 | 8.04782152 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 2.5699999999999993e-43 | NR | KAF4677256.1 | 330153 | g11018 | i0 | 67.3 | 3.94186046511628 | 113 | 29 | 97.7 | 2 | 343 | 8 | 354 | 459 | KAF4677256.1 Cytosolic seryl-tRNA synthetase [Perkinsus chesapeaki] | diamond | 1356 | 157 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 18301913 | 18301913 | PRJNA489308_P_NODE_4815_length_475_cov_2.445274_g4739_i0 | PRJNA489308 | 4815 | 475 | 2.445274 | 11.6150515 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 1.14e-70 | NR | KAF4680316.1 | 32597 | g4739 | i0 | 84.3 | 19.2442105263158 | 127 | 20 | 80.2 | 0 | 3 | 383 | 46 | 172 | KAF4680316.1 26S protease regulatory subunit 10B [Perkinsus olseni] | diamond | 9141 | 220 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26791609 | 26791609 | PRJNA489308_P_NODE_16441_length_304_cov_2.536797_g16365_i0 | PRJNA489308 | 16441 | 304 | 2.536797 | 7.71186288 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 2.23e-8 | NR | XP_002776821.1 | 423536 | g16365 | i0 | 56.3 | 0.473684210526316 | 48 | 21 | 47.4 | 0 | 303 | 160 | 323 | 370 | XP_002776821.1 Cycloartenol-C-24-methyltransferase, putative [Perkinsus marinus ATCC 50983] | diamond | 144 | 61.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27581818 | 27581818 | PRJNA489308_P_NODE_26304_length_263_cov_2.368421_g26228_i0 | PRJNA489308 | 26304 | 263 | 2.368421 | 6.22894723 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 4.11e-15 | NR | KAF4674125.1 | 330153 | g26228 | i0 | 46.7 | 1.04942965779468 | 92 | 39 | 97 | 3 | 263 | 9 | 220 | 308 | KAF4674125.1 hypothetical protein FOL47_009662 [Perkinsus chesapeaki] | diamond | 276 | 79 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27676870 | 27676870 | PRJNA489308_P_NODE_34684_length_246_cov_0.890173_g34608_i0 | PRJNA489308 | 34684 | 246 | 0.890173 | 2.18982558 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 7.43e-9 | NR | XP_002781016.1 | 423536 | g34608 | i0 | 46.6 | 0.707317073170732 | 58 | 28 | 70.7 | 1 | 47 | 220 | 1 | 55 | XP_002781016.1 anaphase-promoting complex subunit, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 174 | 57.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27740074 | 27740074 | PRJNA489308_P_NODE_15924_length_307_cov_3.205128_g15848_i0 | PRJNA489308 | 15924 | 307 | 3.205128 | 9.83974296 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 5.98e-10 | NR | XP_002785349.1 | 423536 | g15848 | i0 | 39.3 | 0.86970684039088 | 89 | 53 | 86 | 1 | 290 | 27 | 955 | 1043 | XP_002785349.1 ubiquitin-activating enzyme e1, putative [Perkinsus marinus ATCC 50983] | diamond | 267 | 65.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28466122 | 28466122 | PRJNA489308_P_NODE_8826_length_372_cov_2.645485_g8750_i0 | PRJNA489308 | 8826 | 372 | 2.645485 | 9.8412042 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 2.35e-13 | NR | TEB19254.1 | 2494336 | g8750 | i0 | 43.2 | 0.709677419354839 | 88 | 45 | 70.2 | 3 | 360 | 100 | 180 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 264 | 75.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 29129243 | 29129243 | PRJNA489308_P_NODE_7629_length_394_cov_1.644860_g7553_i0 | PRJNA489308 | 7629 | 394 | 1.64486 | 6.4807484 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.37e-26 | NR | KAF4659641.1 | 330153 | g7553 | i0 | 43.8 | 0.989847715736041 | 130 | 72 | 99 | 1 | 5 | 394 | 1565 | 1693 | KAF4659641.1 Zinc phosphodiesterase ELAC protein 1 [Perkinsus chesapeaki] | diamond | 390 | 114 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30644898 | 30644898 | PRJNA489308_P_NODE_37733_length_242_cov_1.366864_g37657_i0 | PRJNA489308 | 37733 | 242 | 1.366864 | 3.30781088 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0467 | NR | KAF4724688.1 | 32597 | g37657 | i0 | 40.4 | 0.582644628099174 | 47 | 27 | 58.3 | 1 | 236 | 96 | 188 | 233 | KAF4724688.1 hypothetical protein FOZ62_025349 [Perkinsus olseni] | diamond | 141 | 42.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30929442 | 30929442 | PRJNA489308_P_NODE_5854_length_439_cov_1.513661_g5778_i0 | PRJNA489308 | 5854 | 439 | 1.513661 | 6.64497179 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 214 | 1.82e-66 | NR | XP_002774056.1 | 423536 | g5778 | i0 | 70.3 | 1.01138952164009 | 148 | 42 | 99.8 | 1 | 438 | 1 | 132 | 279 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 444 | 214 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30992703 | 30992703 | PRJNA489308_P_NODE_18954_length_292_cov_1.054795_g18878_i0 | PRJNA489308 | 18954 | 292 | 1.054795 | 3.0800014 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.84e-10 | NR | XP_002771228.1 | 423536 | g18878 | i0 | 65.2 | 2.46575342465753 | 69 | 18 | 70.9 | 1 | 86 | 292 | 2374 | 2436 | XP_002771228.1 succinate dehydrogenase, putative [Perkinsus marinus ATCC 50983] | diamond | 720 | 66.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30992729 | 30992729 | PRJNA489308_P_NODE_4354_length_494_cov_4.380048_g4278_i0 | PRJNA489308 | 4354 | 494 | 4.380048 | 21.63743712 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 2.53e-18 | NR | XP_002767278.1 | 423536 | g4278 | i0 | 45 | 0.674089068825911 | 111 | 52 | 61.9 | 2 | 2 | 307 | 526 | 636 | XP_002767278.1 hypothetical protein Pmar_PMAR024474 [Perkinsus marinus ATCC 50983] | diamond | 333 | 92.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31103320 | 31103320 | PRJNA489308_P_NODE_5515_length_450_cov_1.363395_g5439_i0 | PRJNA489308 | 5515 | 450 | 1.363395 | 6.1352775 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 7.4e-22 | NR | KAF4659641.1 | 330153 | g5439 | i0 | 47.1 | 3.54666666666667 | 121 | 56 | 79.3 | 3 | 86 | 442 | 1443 | 1557 | KAF4659641.1 Zinc phosphodiesterase ELAC protein 1 [Perkinsus chesapeaki] | diamond | 1596 | 103 | 0.990291262135922 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32321303 | 32321303 | PRJNA489308_P_NODE_11259_length_343_cov_1.111111_g11183_i0 | PRJNA489308 | 11259 | 343 | 1.111111 | 3.81111073 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 2.37e-12 | NR | TEB19254.1 | 2494336 | g11183 | i0 | 51.9 | 0.673469387755102 | 77 | 34 | 67.3 | 2 | 342 | 112 | 190 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 231 | 72 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 32368912 | 32368912 | PRJNA489308_P_NODE_13419_length_324_cov_2.820717_g13343_i0 | PRJNA489308 | 13419 | 324 | 2.820717 | 9.13912308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 1.68e-18 | NR | KAF4681912.1 | 32597 | g13343 | i0 | 54.7 | 9.82407407407407 | 75 | 31 | 69.4 | 1 | 2 | 226 | 981 | 1052 | KAF4681912.1 hypothetical protein FOZ60_011353 [Perkinsus olseni] | diamond | 3183 | 90.9 | 0.995599559955996 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32731620 | 32731620 | PRJNA489308_P_NODE_33220_length_248_cov_0.880000_g33144_i0 | PRJNA489308 | 33220 | 248 | 0.88 | 2.1824 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 5.21e-7 | NR | KAF4665641.1 | 330153 | g33144 | i0 | 37 | 2.9758064516129 | 81 | 50 | 96.8 | 1 | 6 | 245 | 1006 | 1086 | KAF4665641.1 hypothetical protein FOL47_004495, partial [Perkinsus chesapeaki] | diamond | 738 | 56.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki |
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);;