contig_metadata
23 rows where bioproject = "PRJNA924320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4727571 | 4727571 | PRJNA924320_S_NODE_17384_length_245_cov_1.301020_g17242_i0 | PRJNA924320 | 17384 | 245 | 1.30102 | 3.187499 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.35e-30 | NR | KAF4687968.1 | 32597 | g17242 | i0 | 79.5 | 4.82448979591837 | 78 | 16 | 95.5 | 0 | 245 | 12 | 66 | 143 | KAF4687968.1 Protein transport protein Sec61 subunit alpha [Perkinsus olseni] | diamond | 1182 | 122 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 18751039 | 18751039 | PRJNA924320_S_NODE_995_length_884_cov_10.970060_g919_i0 | PRJNA924320 | 995 | 884 | 10.97006 | 96.9753304 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 8.11e-32 | NR | TEB19254.1 | 2494336 | g919 | i0 | 33.7 | 0.906108597285068 | 267 | 155 | 84.5 | 8 | 839 | 93 | 1 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 801 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 26620353 | 26620353 | PRJNA924320_S_NODE_7221_length_358_cov_1.650485_g7079_i0 | PRJNA924320 | 7221 | 358 | 1.650485 | 5.9087363 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 5e-6 | NR | KAF4671986.1 | 32597 | g7079 | i0 | 62.9 | 1.46648044692737 | 35 | 13 | 29.3 | 0 | 1 | 105 | 67 | 101 | KAF4671986.1 hypothetical protein FOL46_009662 [Perkinsus olseni] | diamond | 525 | 55.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26834908 | 26834908 | PRJNA924320_S_NODE_12701_length_279_cov_1.552174_g12559_i0 | PRJNA924320 | 12701 | 279 | 1.552174 | 4.33056546 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 9.07e-14 | NR | KAF4716272.1 | 32597 | g12559 | i0 | 49.3 | 1.52688172043011 | 69 | 34 | 73.1 | 1 | 6 | 209 | 40 | 108 | KAF4716272.1 hypothetical protein FOZ63_026040 [Perkinsus olseni] | diamond | 426 | 71.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27435794 | 27435794 | PRJNA924320_S_NODE_9923_length_311_cov_1.736641_g9781_i0 | PRJNA924320 | 9923 | 311 | 1.736641 | 5.40095351 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 5.6e-21 | NR | TEB19254.1 | 2494336 | g9781 | i0 | 51 | 0.92604501607717 | 96 | 39 | 84.9 | 2 | 2 | 265 | 168 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 288 | 94.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 27600846 | 27600846 | PRJNA924320_S_NODE_29064_length_201_cov_1.552632_g28922_i0 | PRJNA924320 | 29064 | 201 | 1.552632 | 3.12079032 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 7.35e-13 | NR | KAF4712232.1 | 32597 | g28922 | i0 | 51.5 | 4.92537313432836 | 66 | 32 | 98.5 | 0 | 4 | 201 | 89 | 154 | KAF4712232.1 oligosaccharyl transferase stt3 subunit, partial [Perkinsus olseni] | diamond | 990 | 72.4 | 0.994475138121547 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28098517 | 28098517 | PRJNA924320_S_NODE_4525_length_443_cov_2.794416_g4384_i0 | PRJNA924320 | 4525 | 443 | 2.794416 | 12.37926288 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 2.19e-16 | NR | KAF4657698.1 | 330153 | g4384 | i0 | 38.5 | 0.826185101580135 | 122 | 73 | 82.6 | 2 | 378 | 13 | 236 | 355 | KAF4657698.1 Kinesin-like protein kif24 [Perkinsus chesapeaki] | diamond | 366 | 86.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28319568 | 28319568 | PRJNA924320_S_NODE_17746_length_243_cov_1.314433_g17604_i0 | PRJNA924320 | 17746 | 243 | 1.314433 | 3.19407219 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 4.78e-24 | NR | KAF4721191.1 | 32597 | g17604 | i0 | 63.6 | 2.85185185185185 | 77 | 26 | 95.1 | 1 | 5 | 235 | 174 | 248 | KAF4721191.1 hypothetical protein FOZ63_016636 [Perkinsus olseni] | diamond | 693 | 102 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28831954 | 28831954 | PRJNA924320_S_NODE_8028_length_342_cov_1.215017_g7886_i0 | PRJNA924320 | 8028 | 342 | 1.215017 | 4.15535814 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 0.00289 | NR | KAF4657659.1 | 32597 | g7886 | i0 | 41.1 | 3.21929824561404 | 56 | 33 | 49.1 | 0 | 177 | 10 | 91 | 146 | KAF4657659.1 hypothetical protein FOZ61_006140 [Perkinsus olseni] | diamond | 1101 | 47.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28919332 | 28919332 | PRJNA924320_S_NODE_24928_length_213_cov_1.524390_g24786_i0 | PRJNA924320 | 24928 | 213 | 1.52439 | 3.2469507 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.24e-4 | NR | KAF4711357.1 | 32597 | g24786 | i0 | 58.8 | 2.3943661971831 | 34 | 14 | 47.9 | 0 | 4 | 105 | 299 | 332 | KAF4711357.1 hypothetical protein FOZ63_028272, partial [Perkinsus olseni] | diamond | 510 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29266607 | 29266607 | PRJNA924320_S_NODE_11849_length_287_cov_2.399160_g11707_i0 | PRJNA924320 | 11849 | 287 | 2.39916 | 6.8855892 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00107 | NR | KAF4673020.1 | 330153 | g11707 | i0 | 29.1 | 2.11149825783972 | 79 | 55 | 82.6 | 1 | 278 | 42 | 459 | 536 | KAF4673020.1 signal recognition particle subunit srp68 [Perkinsus chesapeaki] | diamond | 606 | 47.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29329967 | 29329967 | PRJNA924320_S_NODE_47389_length_166_cov_1.743590_g47247_i0 | PRJNA924320 | 47389 | 166 | 1.74359 | 2.8943594 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 5.86e-7 | NR | XP_002788655.1 | 423536 | g47247 | i0 | 42 | 4.08433734939759 | 50 | 29 | 90.4 | 0 | 150 | 1 | 22 | 71 | XP_002788655.1 protein disulfide isomerase, putative [Perkinsus marinus ATCC 50983] | diamond | 678 | 55.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29361583 | 29361583 | PRJNA924320_S_NODE_14209_length_266_cov_1.691244_g14067_i0 | PRJNA924320 | 14209 | 266 | 1.691244 | 4.49870904 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 4.46e-9 | NR | KAF4687771.1 | 32597 | g14067 | i0 | 43.9 | 2.77443609022556 | 82 | 44 | 90.2 | 2 | 266 | 27 | 129 | 210 | KAF4687771.1 hypothetical protein FOZ62_004224 [Perkinsus olseni] | diamond | 738 | 62.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29550795 | 29550795 | PRJNA924320_S_NODE_36290_length_185_cov_0.941176_g36148_i0 | PRJNA924320 | 36290 | 185 | 0.941176 | 1.7411756 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 4.42e-5 | NR | KAF4754253.1 | 32597 | g36148 | i0 | 40.3 | 2.01081081081081 | 62 | 35 | 98.9 | 2 | 184 | 2 | 71 | 131 | KAF4754253.1 marginal zone B and B1 cell-specific protein, partial [Perkinsus olseni] | diamond | 372 | 50.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29866806 | 29866806 | PRJNA924320_S_NODE_33451_length_191_cov_0.922535_g33309_i0 | PRJNA924320 | 33451 | 191 | 0.922535 | 1.76204185 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 4.78e-5 | NR | KAF4684566.1 | 32597 | g33309 | i0 | 48.8 | 4.24083769633508 | 43 | 22 | 67.5 | 0 | 144 | 16 | 283 | 325 | KAF4684566.1 hypothetical protein FOZ60_007695 [Perkinsus olseni] | diamond | 810 | 50.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30404288 | 30404288 | PRJNA924320_S_NODE_10573_length_302_cov_2.968379_g10431_i0 | PRJNA924320 | 10573 | 302 | 2.968379 | 8.96450458 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0134 | NR | TEB19254.1 | 2494336 | g10431 | i0 | 39.6 | 0.95364238410596 | 96 | 50 | 89.4 | 3 | 19 | 288 | 66 | 159 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 288 | 44.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30941200 | 30941200 | PRJNA924320_S_NODE_854_length_941_cov_3.133408_g781_i0 | PRJNA924320 | 854 | 941 | 3.133408 | 29.48536928 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.53e-5 | NR | KAF4661184.1 | 32597 | g781 | i0 | 72.7 | 0.433581296493092 | 33 | 9 | 10.5 | 0 | 172 | 270 | 77 | 109 | KAF4661184.1 hypothetical protein FOZ61_003450 [Perkinsus olseni] | diamond | 408 | 57 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31383650 | 31383650 | PRJNA924320_S_NODE_676_length_1032_cov_9.282808_g613_i0 | PRJNA924320 | 676 | 1032 | 9.282808 | 95.79857856 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 1.04e-48 | NR | TEB19254.1 | 2494336 | g613 | i0 | 42.4 | 0.767441860465116 | 264 | 140 | 74.1 | 4 | 982 | 218 | 3 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 792 | 174 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31415136 | 31415136 | PRJNA924320_S_NODE_25156_length_212_cov_2.693252_g25014_i0 | PRJNA924320 | 25156 | 212 | 2.693252 | 5.70969424 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 1.4e-14 | NR | KAF4748103.1 | 32597 | g25014 | i0 | 46.2 | 2.20754716981132 | 78 | 31 | 94.8 | 1 | 210 | 10 | 172 | 249 | KAF4748103.1 hypothetical protein FOZ62_030105, partial [Perkinsus olseni] | diamond | 468 | 75.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31865004 | 31865004 | PRJNA924320_S_NODE_9257_length_321_cov_1.500000_g9115_i0 | PRJNA924320 | 9257 | 321 | 1.5 | 4.815 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 6.56e-31 | NR | KAF4730055.1 | 32597 | g9115 | i0 | 72.2 | 4.14953271028037 | 90 | 25 | 84.1 | 0 | 321 | 52 | 53 | 142 | KAF4730055.1 Kinesin, partial [Perkinsus olseni] | diamond | 1332 | 125 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31952805 | 31952805 | PRJNA924320_S_NODE_9637_length_315_cov_2.375940_g9495_i0 | PRJNA924320 | 9637 | 315 | 2.37594 | 7.484211 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 1.39e-5 | NR | KAF4656929.1 | 32597 | g9495 | i0 | 37.5 | 1.34285714285714 | 72 | 42 | 66.7 | 2 | 63 | 272 | 139 | 209 | KAF4656929.1 hypothetical protein FOZ61_006606, partial [Perkinsus olseni] | diamond | 423 | 53.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32427556 | 32427556 | PRJNA924320_S_NODE_42199_length_173_cov_1.604839_g42057_i0 | PRJNA924320 | 42199 | 173 | 1.604839 | 2.77637147 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 3.21e-5 | NR | KAF4729468.1 | 32597 | g42057 | i0 | 58.1 | 2.94797687861272 | 43 | 18 | 74.6 | 0 | 130 | 2 | 82 | 124 | KAF4729468.1 hypothetical protein FOZ63_026808 [Perkinsus olseni] | diamond | 510 | 50.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32490932 | 32490932 | PRJNA924320_S_NODE_19379_length_235_cov_0.838710_g19237_i0 | PRJNA924320 | 19379 | 235 | 0.83871 | 1.9709685 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 8.43e-8 | NR | TEB19254.1 | 2494336 | g19237 | i0 | 45.1 | 0.906382978723404 | 71 | 39 | 90.6 | 0 | 215 | 3 | 110 | 180 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 213 | 58.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 |
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);;