contig_metadata
16 rows where bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192419 | 192419 | PRJNA1078753_P_NODE_13841_length_316_cov_1.189300_g13645_i0 | PRJNA1078753 | 13841 | 316 | 1.1893 | 3.758188 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 4.75e-30 | NTclustered | gi|347516615|gb|HQ339915.1| | 32597 | g13645 | i0 | 78.481 | 41.876582278481 | 237 | 40 | 75 | 7 | 81 | 316 | 310 | 536 | Perkinsus olseni strain ALG1 heat shock protein 90 gene, partial cds | blastn | 13233 | 145 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 14221339 | 14221339 | PRJNA1078753_P_NODE_34732_length_246_cov_1.335260_g34536_i0 | PRJNA1078753 | 34732 | 246 | 1.33526 | 3.2847396 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 7.71e-27 | NTclustered | gi|294925728|ref|XM_002778944.1| | 423536 | g34536 | i0 | 85.385 | 1.96341463414634 | 130 | 17 | 52 | 2 | 5 | 133 | 253 | 125 | Perkinsus marinus ATCC 50983 40S ribosomal protein S11, putative, mRNA | blastn | 483 | 134 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 21869245 | 21869245 | PRJNA1078753_P_NODE_1478_length_786_cov_4.214586_g1311_i0 | PRJNA1078753 | 1478 | 786 | 4.214586 | 33.12664596 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 347 | 7.9e-117 | NR | XP_002774056.1 | 423536 | g1311 | i0 | 65.7 | 1.88931297709924 | 248 | 82 | 93.5 | 2 | 50 | 784 | 4 | 251 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 1485 | 347 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26837579 | 26837579 | PRJNA1078753_P_NODE_41021_length_242_cov_0.911243_g40825_i0 | PRJNA1078753 | 41021 | 242 | 0.911243 | 2.20520806 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 8.06e-4 | NR | KAF4726173.1 | 32597 | g40825 | i0 | 42.6 | 2.67768595041322 | 54 | 30 | 66.9 | 1 | 76 | 237 | 3 | 55 | KAF4726173.1 hypothetical protein FOZ62_019881, partial [Perkinsus olseni] | diamond | 648 | 44.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27280280 | 27280280 | PRJNA1078753_P_NODE_35523_length_246_cov_0.890173_g35327_i0 | PRJNA1078753 | 35523 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.87e-37 | NR | KAF4676554.1 | 32597 | g35327 | i0 | 74.1 | 5.92682926829268 | 81 | 21 | 98.8 | 0 | 2 | 244 | 688 | 768 | KAF4676554.1 hypothetical protein FOL46_000016 [Perkinsus olseni] | diamond | 1458 | 143 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27469860 | 27469860 | PRJNA1078753_P_NODE_43923_length_238_cov_2.600000_g43727_i0 | PRJNA1078753 | 43923 | 238 | 2.6 | 6.188 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 3.19e-18 | NR | KAF4701558.1 | 32597 | g43727 | i0 | 45.6 | 17.8613445378151 | 79 | 43 | 99.6 | 0 | 237 | 1 | 59 | 137 | KAF4701558.1 Protein transport protein Sec61 subunit alpha [Perkinsus olseni] | diamond | 4251 | 85.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27541511 | 27541511 | PRJNA1078753_P_NODE_3044_length_576_cov_3.326044_g2852_i0 | PRJNA1078753 | 3044 | 576 | 3.326044 | 19.15801344 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 247 | 2.84e-80 | NR | XP_002778466.1 | 423536 | g2852 | i0 | 62.1 | 2.96354166666667 | 190 | 71 | 98.4 | 1 | 570 | 4 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 1707 | 247 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27564217 | 27564217 | PRJNA1078753_P_NODE_6664_length_416_cov_1.346939_g6468_i0 | PRJNA1078753 | 6664 | 416 | 1.346939 | 5.60326624 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 5.04e-24 | NR | KAF4665274.1 | 32597 | g6468 | i0 | 46.8 | 16.6875 | 109 | 55 | 76.4 | 1 | 28 | 345 | 234 | 342 | KAF4665274.1 Ca(2+)-dependent cysteine protease [Perkinsus olseni] | diamond | 6942 | 108 | 0.990740740740741 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28038185 | 28038185 | PRJNA1078753_P_NODE_24605_length_260_cov_1.427807_g24409_i0 | PRJNA1078753 | 24605 | 260 | 1.427807 | 3.7122982 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.98e-8 | NR | KAF4690325.1 | 32597 | g24409 | i0 | 40.8 | 3.27692307692308 | 71 | 40 | 79.6 | 1 | 254 | 48 | 304 | 374 | KAF4690325.1 putative E3 ubiquitin-protein ligase herc3 [Perkinsus olseni] | diamond | 852 | 61.2 | 0.993464052287582 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29277827 | 29277827 | PRJNA1078753_P_NODE_25069_length_258_cov_1.448649_g24873_i0 | PRJNA1078753 | 25069 | 258 | 1.448649 | 3.73751442 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 4.39e-33 | NR | KAF4660984.1 | 330153 | g24873 | i0 | 66.7 | 0.976744186046512 | 84 | 27 | 97.7 | 1 | 254 | 3 | 226 | 308 | KAF4660984.1 hypothetical protein FOL47_006890 [Perkinsus chesapeaki] | diamond | 252 | 127 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29774498 | 29774498 | PRJNA1078753_P_NODE_23251_length_265_cov_1.781250_g23055_i0 | PRJNA1078753 | 23251 | 265 | 1.78125 | 4.7203125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.43e-4 | NR | KAF4659229.1 | 330153 | g23055 | i0 | 57.4 | 8.29811320754717 | 54 | 20 | 57.7 | 2 | 157 | 5 | 247 | 300 | KAF4659229.1 mitochondrial processing peptidase beta subunit [Perkinsus chesapeaki] | diamond | 2199 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30541367 | 30541367 | PRJNA1078753_P_NODE_42453_length_241_cov_1.375000_g42257_i0 | PRJNA1078753 | 42453 | 241 | 1.375 | 3.31375 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 9.65e-18 | NR | KAF4729287.1 | 32597 | g42257 | i0 | 63.2 | 0.70954356846473 | 57 | 21 | 71 | 0 | 1 | 171 | 56 | 112 | KAF4729287.1 hypothetical protein FOZ63_024682, partial [Perkinsus olseni] | diamond | 171 | 81.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30920755 | 30920755 | PRJNA1078753_P_NODE_9074_length_368_cov_1.688136_g8878_i0 | PRJNA1078753 | 9074 | 368 | 1.688136 | 6.21234048 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 4.63e-11 | NR | KAF4737230.1 | 32597 | g8878 | i0 | 43.2 | 3.57065217391304 | 88 | 45 | 71.7 | 1 | 366 | 103 | 38 | 120 | KAF4737230.1 hypothetical protein FOZ63_005478, partial [Perkinsus olseni] | diamond | 1314 | 67.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31639041 | 31639041 | PRJNA1078753_P_NODE_28816_length_250_cov_0.870056_g28620_i0 | PRJNA1078753 | 28816 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 5.46e-13 | NR | KAF4677538.1 | 330153 | g28620 | i0 | 49.3 | 5.604 | 69 | 32 | 82.8 | 1 | 44 | 250 | 65 | 130 | KAF4677538.1 hypothetical protein FOL47_000926 [Perkinsus chesapeaki] | diamond | 1401 | 73.9 | 0.995940460081191 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31670741 | 31670741 | PRJNA1078753_P_NODE_30037_length_249_cov_1.312500_g29841_i0 | PRJNA1078753 | 30037 | 249 | 1.3125 | 3.268125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.0012 | NR | KAF4679912.1 | 32597 | g29841 | i0 | 37 | 3.79518072289157 | 81 | 50 | 96.4 | 1 | 244 | 5 | 109 | 189 | KAF4679912.1 Tubulin tyrosine ligase-like, member [Perkinsus olseni] | diamond | 945 | 47 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31711002 | 31711002 | PRJNA1078753_P_NODE_30917_length_249_cov_0.875000_g30721_i0 | PRJNA1078753 | 30917 | 249 | 0.875 | 2.17875 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00588 | NR | XP_002785076.1 | 423536 | g30721 | i0 | 73.3 | 0.72289156626506 | 30 | 8 | 36.1 | 0 | 238 | 149 | 372 | 401 | XP_002785076.1 Heterogeneous nuclear ribonucleoprotein 27C, putative [Perkinsus marinus ATCC 50983] | diamond | 180 | 45.1 | 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);;