contig_metadata
26 rows where bioproject = "PRJNA594101", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 566914 | 566914 | PRJNA594101_S_NODE_11061_length_494_cov_3.643705_g10760_i0 | PRJNA594101 | 11061 | 494 | 3.643705 | 17.9999027 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 8.01e-5 | NTclustered | gi|294876113|ref|XM_002767512.1| | 423536 | g10760 | i0 | 97.222 | 0.0728744939271255 | 36 | 1 | 7 | 0 | 23 | 58 | 11659 | 11694 | Perkinsus marinus ATCC 50983 ciliary dynein heavy chain, putative, mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 1842561 | 1842561 | PRJNA594101_S_NODE_26742_length_328_cov_2.325490_g26440_i0 | PRJNA594101 | 26742 | 328 | 2.32549 | 7.6276072 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|294875641|ref|XM_002767369.1| | 423536 | g26440 | i0 | 100 | 0.0884146341463415 | 29 | 0 | 9 | 0 | 29 | 57 | 1479 | 1451 | Perkinsus marinus ATCC 50983 RNA-binding protein, putative, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26826745 | 26826745 | PRJNA594101_S_NODE_39581_length_276_cov_3.108374_g39279_i0 | PRJNA594101 | 39581 | 276 | 3.108374 | 8.57911224 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00235 | NR | KAF4670611.1 | 330153 | g39279 | i0 | 35.8 | 3.1195652173913 | 53 | 34 | 57.6 | 0 | 271 | 113 | 242 | 294 | KAF4670611.1 hypothetical protein FOL47_001934 [Perkinsus chesapeaki] | diamond | 861 | 46.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 26890128 | 26890128 | PRJNA594101_S_NODE_13661_length_447_cov_2.438503_g13359_i0 | PRJNA594101 | 13661 | 447 | 2.438503 | 10.90010841 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.83e-12 | NR | XP_002781557.1 | 423536 | g13359 | i0 | 33.3 | 2.39597315436242 | 117 | 78 | 78.5 | 0 | 361 | 11 | 1372 | 1488 | XP_002781557.1 cytoplasmic dynein heavy chain, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 1071 | 75.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27269331 | 27269331 | PRJNA594101_S_NODE_14543_length_435_cov_0.964088_g14241_i0 | PRJNA594101 | 14543 | 435 | 0.964088 | 4.1937828 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 2.68e-7 | NR | KAF4721267.1 | 32597 | g14241 | i0 | 63.4 | 1.13103448275862 | 41 | 15 | 28.3 | 0 | 432 | 310 | 194 | 234 | KAF4721267.1 hypothetical protein FOZ63_001744 [Perkinsus olseni] | diamond | 492 | 59.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28167116 | 28167116 | PRJNA594101_S_NODE_6645_length_633_cov_2.241071_g6350_i0 | PRJNA594101 | 6645 | 633 | 2.241071 | 14.18597943 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 2.12e-71 | NR | KAF4661621.1 | 32597 | g6350 | i0 | 65.1 | 6.93364928909953 | 209 | 58 | 99.1 | 2 | 2 | 628 | 1962 | 2155 | KAF4661621.1 hypothetical protein FOZ61_003069 [Perkinsus olseni] | diamond | 4389 | 246 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29006516 | 29006516 | PRJNA594101_S_NODE_29768_length_313_cov_4.962500_g29466_i0 | PRJNA594101 | 29768 | 313 | 4.9625 | 15.532625 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 1.35e-5 | NR | KAF4656929.1 | 32597 | g29466 | i0 | 37.5 | 1.35143769968051 | 72 | 42 | 67.1 | 2 | 75 | 284 | 139 | 209 | KAF4656929.1 hypothetical protein FOZ61_006606, partial [Perkinsus olseni] | diamond | 423 | 53.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29258401 | 29258401 | PRJNA594101_S_NODE_23929_length_345_cov_1.860294_g23627_i0 | PRJNA594101 | 23929 | 345 | 1.860294 | 6.4180143 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0459 | NR | XP_002780532.1 | 423536 | g23627 | i0 | 29.5 | 0.91304347826087 | 105 | 66 | 87.8 | 2 | 345 | 43 | 88 | 188 | XP_002780532.1 Be158, putative [Perkinsus marinus ATCC 50983] | diamond | 315 | 43.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29461219 | 29461219 | PRJNA594101_S_NODE_15570_length_420_cov_2.804035_g15268_i0 | PRJNA594101 | 15570 | 420 | 2.804035 | 11.776947 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 5.36e-66 | NR | AND95702.1 | 32597 | g15268 | i0 | 79.3 | 8 | 140 | 29 | 100 | 0 | 420 | 1 | 336 | 475 | AND95702.1 Aconitate hydratase, cytoplasmic, partial [Perkinsus olseni] | diamond | 3360 | 226 | 0.991150442477876 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29511171 | 29511171 | PRJNA594101_S_NODE_59290_length_214_cov_9.531915_g58988_i0 | PRJNA594101 | 59290 | 214 | 9.531915 | 20.3982981 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00154 | NR | KAF4667841.1 | 32597 | g58988 | i0 | 51.3 | 0.981308411214953 | 39 | 19 | 54.7 | 0 | 153 | 37 | 42 | 80 | KAF4667841.1 hypothetical protein FOL46_002324 [Perkinsus olseni] | diamond | 210 | 46.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30030085 | 30030085 | PRJNA594101_S_NODE_20151_length_373_cov_2.560000_g19849_i0 | PRJNA594101 | 20151 | 373 | 2.56 | 9.5488 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.92e-19 | NR | KAF4670479.1 | 32597 | g19849 | i0 | 54 | 3.50670241286863 | 87 | 39 | 70 | 1 | 373 | 113 | 791 | 876 | KAF4670479.1 H(+)-transporting V0 sector ATPase subunit a [Perkinsus olseni] | diamond | 1308 | 94.4 | 0.995762711864407 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30124558 | 30124558 | PRJNA594101_S_NODE_44032_length_263_cov_1.505263_g43730_i0 | PRJNA594101 | 44032 | 263 | 1.505263 | 3.95884169 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.84e-5 | NR | KAF4699664.1 | 32597 | g43730 | i0 | 37 | 10.8821292775665 | 73 | 46 | 83.3 | 0 | 17 | 235 | 290 | 362 | KAF4699664.1 hypothetical protein FOZ63_002035 [Perkinsus olseni] | diamond | 2862 | 52.8 | 0.992424242424242 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30838044 | 30838044 | PRJNA594101_S_NODE_28514_length_319_cov_1.768293_g28212_i0 | PRJNA594101 | 28514 | 319 | 1.768293 | 5.64085467 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0107 | NR | KAF4694714.1 | 32597 | g28212 | i0 | 28.4 | 3.41379310344828 | 88 | 62 | 82.8 | 1 | 265 | 2 | 1263 | 1349 | KAF4694714.1 hypothetical protein FOZ60_007227 [Perkinsus olseni] | diamond | 1089 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30946414 | 30946414 | PRJNA594101_S_NODE_37494_length_283_cov_1.833333_g37192_i0 | PRJNA594101 | 37494 | 283 | 1.833333 | 5.18833239 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 1.95e-13 | NR | XP_002775223.1 | 423536 | g37192 | i0 | 40 | 7.29328621908127 | 85 | 51 | 90.1 | 0 | 258 | 4 | 2065 | 2149 | XP_002775223.1 dynein beta chain, ciliary, putative [Perkinsus marinus ATCC 50983] | diamond | 2064 | 75.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31027823 | 31027823 | PRJNA594101_S_NODE_55995_length_243_cov_0.876471_g55693_i0 | PRJNA594101 | 55995 | 243 | 0.876471 | 2.12982453 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.02e-10 | NR | KAF4655791.1 | 330153 | g55693 | i0 | 38 | 5.85185185185185 | 79 | 48 | 97.5 | 1 | 241 | 5 | 308 | 385 | KAF4655791.1 hypothetical protein FOL47_009278 [Perkinsus chesapeaki] | diamond | 1422 | 67 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31610224 | 31610224 | PRJNA594101_S_NODE_14236_length_439_cov_0.945355_g13934_i0 | PRJNA594101 | 14236 | 439 | 0.945355 | 4.15010845 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00524 | NR | KAF4726345.1 | 32597 | g13934 | i0 | 30.3 | 9.24601366742597 | 76 | 53 | 51.9 | 0 | 196 | 423 | 718 | 793 | KAF4726345.1 hypothetical protein FOZ63_002044 [Perkinsus olseni] | diamond | 4059 | 47.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31659843 | 31659843 | PRJNA594101_S_NODE_44057_length_263_cov_1.315789_g43755_i0 | PRJNA594101 | 44057 | 263 | 1.315789 | 3.46052507 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 2.07e-11 | NR | XP_002779276.1 | 423536 | g43755 | i0 | 39 | 7.96197718631179 | 77 | 45 | 87.8 | 1 | 261 | 31 | 139 | 213 | XP_002779276.1 cathepsin z, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 2094 | 69.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31849713 | 31849713 | PRJNA594101_S_NODE_25117_length_338_cov_0.969811_g24815_i0 | PRJNA594101 | 25117 | 338 | 0.969811 | 3.27796118 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 4.04e-5 | NR | KAF4741080.1 | 32597 | g24815 | i0 | 32.3 | 5.29881656804734 | 99 | 67 | 87.9 | 0 | 297 | 1 | 161 | 259 | KAF4741080.1 Dynein heavy chain 1, axonemal, partial [Perkinsus olseni] | diamond | 1791 | 52.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31881285 | 31881285 | PRJNA594101_S_NODE_47137_length_255_cov_1.087912_g46835_i0 | PRJNA594101 | 47137 | 255 | 1.087912 | 2.7741756 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0442 | NR | KAF4697749.1 | 32597 | g46835 | i0 | 34.3 | 1.64705882352941 | 70 | 46 | 82.4 | 0 | 247 | 38 | 1611 | 1680 | KAF4697749.1 hypothetical protein FOZ60_000093 [Perkinsus olseni] | diamond | 420 | 42.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32134660 | 32134660 | PRJNA594101_S_NODE_24538_length_341_cov_1.667910_g24236_i0 | PRJNA594101 | 24538 | 341 | 1.66791 | 5.6875731 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 6.03e-39 | NR | XP_002777422.1 | 423536 | g24236 | i0 | 59.3 | 4.88269794721408 | 113 | 46 | 99.4 | 0 | 1 | 339 | 190 | 302 | XP_002777422.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 1665 | 149 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32148037 | 32148037 | PRJNA594101_S_NODE_13538_length_449_cov_2.082447_g13236_i0 | PRJNA594101 | 13538 | 449 | 2.082447 | 9.35018703 | root | 1 | Root_unresolved | Root_unresolved | 160 | 3.56e-46 | NR | KAF4650436.1 | 330153 | g13236 | i0 | 54.7 | 15.5412026726058 | 150 | 56 | 98.2 | 2 | 442 | 2 | 33 | 173 | KAF4650436.1 hypothetical protein FOL47_001145, partial [Perkinsus chesapeaki] | diamond | 6978 | 161 | 0.993788819875776 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32261410 | 32261410 | PRJNA594101_S_NODE_34438_length_294_cov_1.742081_g34136_i0 | PRJNA594101 | 34438 | 294 | 1.742081 | 5.12171814 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.33e-6 | NR | KAF4675603.1 | 330153 | g34136 | i0 | 36.9 | 0.663265306122449 | 65 | 37 | 64.3 | 2 | 292 | 104 | 96 | 158 | KAF4675603.1 hypothetical protein FOL47_007555 [Perkinsus chesapeaki] | diamond | 195 | 55.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32306496 | 32306496 | PRJNA594101_S_NODE_33719_length_297_cov_1.361607_g33417_i0 | PRJNA594101 | 33719 | 297 | 1.361607 | 4.04397279 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 3.87e-36 | NR | KAF4740523.1 | 32597 | g33417 | i0 | 64.4 | 15.6161616161616 | 90 | 32 | 90.9 | 0 | 8 | 277 | 49 | 138 | KAF4740523.1 hypothetical protein FOZ63_031744 [Perkinsus olseni] | diamond | 4638 | 134 | 0.992537313432836 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32496190 | 32496190 | PRJNA594101_S_NODE_27219_length_326_cov_1.185771_g26917_i0 | PRJNA594101 | 27219 | 326 | 1.185771 | 3.86561346 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.1200000000000003e-27 | NR | KAF4743652.1 | 32597 | g26917 | i0 | 50 | 3.97546012269939 | 108 | 54 | 99.4 | 0 | 3 | 326 | 100 | 207 | KAF4743652.1 hypothetical protein FOZ63_029988, partial [Perkinsus olseni] | diamond | 1296 | 111 | 0.990990990990991 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32608990 | 32608990 | PRJNA594101_S_NODE_40860_length_272_cov_1.839196_g40558_i0 | PRJNA594101 | 40860 | 272 | 1.839196 | 5.00261312 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0166 | NR | KAF4665500.1 | 330153 | g40558 | i0 | 42.9 | 1.08088235294118 | 49 | 28 | 54 | 0 | 17 | 163 | 144 | 192 | KAF4665500.1 hypothetical protein FOL47_004534 [Perkinsus chesapeaki] | diamond | 294 | 43.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32735119 | 32735119 | PRJNA594101_S_NODE_5960_length_667_cov_2.072391_g5671_i0 | PRJNA594101 | 5960 | 667 | 2.072391 | 13.82284797 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 0.00472 | NR | KAF4656436.1 | 32597 | g5671 | i0 | 29 | 2.48275862068966 | 176 | 111 | 75.6 | 4 | 642 | 139 | 111 | 280 | KAF4656436.1 hypothetical protein FOL46_007831 [Perkinsus olseni] | diamond | 1656 | 49.3 | 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);;