contig_metadata
21 rows where bioproject = "PRJNA335774", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940576 | 2940576 | PRJNA335774_P_NODE_10023_length_459_cov_1.095855_g9871_i0 | PRJNA335774 | 10023 | 459 | 1.095855 | 5.02997445 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 1.13e-73 | NR | KAF4700315.1 | 32597 | g9871 | i0 | 73 | 21.843137254902 | 152 | 41 | 99.3 | 0 | 2 | 457 | 14 | 165 | KAF4700315.1 Arf GTPase arf1 [Perkinsus olseni] | diamond | 10026 | 228 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 8043665 | 8043665 | PRJNA335774_P_NODE_29407_length_290_cov_1.050691_g29255_i0 | PRJNA335774 | 29407 | 290 | 1.050691 | 3.0470039 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.3899999999999996e-42 | NR | KAF4662583.1 | 330153 | g29255 | i0 | 72.9 | 7.9448275862069 | 96 | 26 | 99.3 | 0 | 3 | 290 | 117 | 212 | KAF4662583.1 hypothetical protein FOL47_006179 [Perkinsus chesapeaki] | diamond | 2304 | 152 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 11869038 | 11869038 | PRJNA335774_P_NODE_30930_length_283_cov_1.466667_g30778_i0 | PRJNA335774 | 30930 | 283 | 1.466667 | 4.15066761 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.43e-20 | NR | KAF4657297.1 | 32597 | g30778 | i0 | 67.5 | 0.848056537102474 | 80 | 26 | 84.8 | 0 | 4 | 243 | 315 | 394 | KAF4657297.1 U4 u6 small nuclear ribonucleoprotein [Perkinsus olseni] | diamond | 240 | 94 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 19515926 | 19515926 | PRJNA335774_P_NODE_15896_length_376_cov_2.702970_g15744_i0 | PRJNA335774 | 15896 | 376 | 2.70297 | 10.1631672 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.0499999999999998e-34 | NTclustered | gi|294881230|ref|XM_002769261.1| | 423536 | g15744 | i0 | 78.244 | 16.2021276595745 | 262 | 48 | 68 | 7 | 9 | 265 | 306 | 49 | Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA | blastn | 6092 | 159 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26631513 | 26631513 | PRJNA335774_P_NODE_35981_length_262_cov_1.481481_g35829_i0 | PRJNA335774 | 35981 | 262 | 1.481481 | 3.88148022 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.11e-14 | NR | KAF4675656.1 | 330153 | g35829 | i0 | 50.7 | 0.767175572519084 | 67 | 33 | 76.7 | 0 | 255 | 55 | 127 | 193 | KAF4675656.1 hypothetical protein FOL47_007428 [Perkinsus chesapeaki] | diamond | 201 | 77.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 26947963 | 26947963 | PRJNA335774_P_NODE_18582_length_353_cov_1.096429_g18430_i0 | PRJNA335774 | 18582 | 353 | 1.096429 | 3.87039437 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0149 | NR | KAF4690192.1 | 32597 | g18430 | i0 | 46.2 | 0.662889518413598 | 39 | 21 | 33.1 | 0 | 349 | 233 | 1023 | 1061 | KAF4690192.1 hypothetical protein FOZ60_000546 [Perkinsus olseni] | diamond | 234 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27675138 | 27675138 | PRJNA335774_P_NODE_42764_length_247_cov_0.885057_g42612_i0 | PRJNA335774 | 42764 | 247 | 0.885057 | 2.18609079 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 4.13e-5 | NR | KAF4659573.1 | 32597 | g42612 | i0 | 34.9 | 5.35627530364372 | 63 | 39 | 74.1 | 2 | 246 | 64 | 1087 | 1149 | KAF4659573.1 hypothetical protein FOZ61_004654 [Perkinsus olseni] | diamond | 1323 | 51.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27818656 | 27818656 | PRJNA335774_P_NODE_21824_length_330_cov_1.190661_g21672_i0 | PRJNA335774 | 21824 | 330 | 1.190661 | 3.9291813 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 2.95e-7 | NR | KAF4759208.1 | 32597 | g21672 | i0 | 29.3 | 4.09090909090909 | 133 | 63 | 97.3 | 4 | 3 | 323 | 356 | 483 | KAF4759208.1 hypothetical protein FOZ63_031254, partial [Perkinsus olseni] | diamond | 1350 | 58.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28874621 | 28874621 | PRJNA335774_P_NODE_16108_length_374_cov_1.820598_g15956_i0 | PRJNA335774 | 16108 | 374 | 1.820598 | 6.80903652 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.42e-8 | NR | KAF4736437.1 | 32597 | g15956 | i0 | 33.1 | 0.970588235294118 | 121 | 70 | 91.4 | 5 | 13 | 354 | 195 | 311 | KAF4736437.1 hypothetical protein FOZ62_016183, partial [Perkinsus olseni] | diamond | 363 | 62.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28874649 | 28874649 | PRJNA335774_P_NODE_48508_length_241_cov_0.916667_g48356_i0 | PRJNA335774 | 48508 | 241 | 0.916667 | 2.20916747 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.53e-4 | NR | KAF4664286.1 | 330153 | g48356 | i0 | 47.1 | 0.634854771784232 | 51 | 25 | 61 | 1 | 94 | 240 | 688 | 738 | KAF4664286.1 hypothetical protein FOL47_005217 [Perkinsus chesapeaki] | diamond | 153 | 48.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28969495 | 28969495 | PRJNA335774_P_NODE_38808_length_251_cov_1.235955_g38656_i0 | PRJNA335774 | 38808 | 251 | 1.235955 | 3.10224705 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 7.66e-5 | NR | KAF4741144.1 | 32597 | g38656 | i0 | 82.6 | 0.274900398406374 | 23 | 4 | 27.5 | 0 | 4 | 72 | 16 | 38 | KAF4741144.1 hypothetical protein FOZ62_006983, partial [Perkinsus olseni] | diamond | 69 | 48.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29190525 | 29190525 | PRJNA335774_P_NODE_10529_length_449_cov_1.617021_g10377_i0 | PRJNA335774 | 10529 | 449 | 1.617021 | 7.26042429 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 9.12e-5 | NR | KAF4736437.1 | 32597 | g10377 | i0 | 28.7 | 4.10913140311804 | 143 | 91 | 94.2 | 5 | 26 | 448 | 119 | 252 | KAF4736437.1 hypothetical protein FOZ62_016183, partial [Perkinsus olseni] | diamond | 1845 | 52.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29397154 | 29397154 | PRJNA335774_P_NODE_42129_length_248_cov_0.880000_g41977_i0 | PRJNA335774 | 42129 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 1.27e-6 | NR | KAF4722627.1 | 32597 | g41977 | i0 | 40.3 | 4.68145161290323 | 77 | 46 | 93.1 | 0 | 248 | 18 | 49 | 125 | KAF4722627.1 hypothetical protein FOZ63_029349, partial [Perkinsus olseni] | diamond | 1161 | 53.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29554835 | 29554835 | PRJNA335774_P_NODE_4950_length_619_cov_1.641026_g4805_i0 | PRJNA335774 | 4950 | 619 | 1.641026 | 10.15795094 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 6.33e-60 | NR | KAF4686835.1 | 32597 | g4805 | i0 | 50.2 | 8.98061389337641 | 207 | 94 | 98.9 | 3 | 617 | 6 | 417 | 617 | KAF4686835.1 hypothetical protein FOZ60_004759 [Perkinsus olseni] | diamond | 5559 | 209 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29916817 | 29916817 | PRJNA335774_P_NODE_10271_length_454_cov_1.834646_g10119_i0 | PRJNA335774 | 10271 | 454 | 1.834646 | 8.32929284 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0236 | NR | XP_002774905.1 | 423536 | g10119 | i0 | 38.3 | 0.753303964757709 | 60 | 37 | 39.6 | 0 | 172 | 351 | 259 | 318 | XP_002774905.1 hypothetical protein Pmar_PMAR007438 [Perkinsus marinus ATCC 50983] | diamond | 342 | 45.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29979834 | 29979834 | PRJNA335774_P_NODE_18291_length_355_cov_1.453901_g18139_i0 | PRJNA335774 | 18291 | 355 | 1.453901 | 5.16134855 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 6.67e-4 | NR | KAF4754063.1 | 32597 | g18139 | i0 | 40.7 | 1.58028169014084 | 54 | 29 | 45.6 | 1 | 117 | 278 | 228 | 278 | KAF4754063.1 hypothetical protein FOZ62_024433, partial [Perkinsus olseni] | diamond | 561 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30169258 | 30169258 | PRJNA335774_P_NODE_2552_length_806_cov_1.922237_g2424_i0 | PRJNA335774 | 2552 | 806 | 1.922237 | 15.49323022 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 7.39e-15 | NR | KAF4727543.1 | 32597 | g2424 | i0 | 25.6 | 2.06575682382134 | 277 | 178 | 97.9 | 11 | 804 | 16 | 50 | 312 | KAF4727543.1 hypothetical protein FOZ63_008444, partial [Perkinsus olseni] | diamond | 1665 | 84.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30313614 | 30313614 | PRJNA335774_P_NODE_38992_length_251_cov_0.865169_g38840_i0 | PRJNA335774 | 38992 | 251 | 0.865169 | 2.17157419 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00243 | NR | KAF4686953.1 | 32597 | g38840 | i0 | 68.8 | 1.17131474103586 | 32 | 10 | 38.2 | 0 | 9 | 104 | 293 | 324 | KAF4686953.1 T-complex-associated testis-expressed protein 1 [Perkinsus olseni] | diamond | 294 | 46.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32002911 | 32002911 | PRJNA335774_P_NODE_29398_length_290_cov_1.059908_g29246_i0 | PRJNA335774 | 29398 | 290 | 1.059908 | 3.0737332 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 4.469999999999999e-42 | NR | KAF4675070.1 | 32597 | g29246 | i0 | 72.9 | 6.95172413793103 | 96 | 26 | 99.3 | 0 | 290 | 3 | 608 | 703 | KAF4675070.1 hypothetical protein FOL46_002986 [Perkinsus olseni] | diamond | 2016 | 156 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32192812 | 32192812 | PRJNA335774_P_NODE_36198_length_261_cov_1.638298_g36046_i0 | PRJNA335774 | 36198 | 261 | 1.638298 | 4.27595778 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 6.08e-30 | NR | XP_002785451.1 | 423536 | g36046 | i0 | 57.3 | 5.6551724137931 | 82 | 35 | 94.3 | 0 | 260 | 15 | 687 | 768 | XP_002785451.1 wd-repeat protein, putative [Perkinsus marinus ATCC 50983] | diamond | 1476 | 122 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32887083 | 32887083 | PRJNA335774_P_NODE_41040_length_249_cov_0.875000_g40888_i0 | PRJNA335774 | 41040 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00336 | NR | KAF4751301.1 | 32597 | g40888 | i0 | 44.7 | 1.69879518072289 | 47 | 26 | 56.6 | 0 | 222 | 82 | 37 | 83 | KAF4751301.1 hypothetical protein FOZ62_008849, partial [Perkinsus olseni] | diamond | 423 | 44.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);;