contig_metadata
11 rows where bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6555253 | 6555253 | PRJNA1059246_P_NODE_59586_length_258_cov_1.248649_g58960_i0 | PRJNA1059246 | 59586 | 258 | 1.248649 | 3.22151442 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 7.98e-42 | NTclustered | gi|1027589964|gb|KR704816.1| | 32597 | g58960 | i0 | 81.034 | 46.4883720930233 | 232 | 42 | 90 | 2 | 6 | 236 | 831 | 1061 | Perkinsus olseni Isocitrate dehydrogenase (IDH) mRNA, complete cds | blastn | 11994 | 183 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 14205533 | 14205533 | PRJNA1059246_P_NODE_22352_length_477_cov_2.888614_g21730_i0 | PRJNA1059246 | 22352 | 477 | 2.888614 | 13.77868878 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.13e-8 | NR | XP_002778973.1 | 423536 | g21730 | i0 | 38.8 | 1.93081761006289 | 103 | 58 | 61.6 | 3 | 37 | 330 | 12 | 114 | XP_002778973.1 46 kDa FK506-binding nuclear protein, putative [Perkinsus marinus ATCC 50983] | diamond | 921 | 63.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 15479502 | 15479502 | PRJNA1059246_P_NODE_10313_length_750_cov_1.189069_g9765_i0 | PRJNA1059246 | 10313 | 750 | 1.189069 | 8.9180175 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 240 | 1.27e-76 | NR | KAF4686610.1 | 32597 | g9765 | i0 | 60.6 | 0.752 | 188 | 73 | 74.8 | 1 | 32 | 592 | 3 | 190 | KAF4686610.1 hypothetical protein FOZ60_005038 [Perkinsus olseni] | diamond | 564 | 240 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26655256 | 26655256 | PRJNA1059246_P_NODE_59181_length_259_cov_1.655914_g58555_i0 | PRJNA1059246 | 59181 | 259 | 1.655914 | 4.28881726 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 8.929999999999999e-31 | NR | KAF4704039.1 | 32597 | g58555 | i0 | 66.3 | 3.98455598455598 | 86 | 29 | 99.6 | 0 | 258 | 1 | 132 | 217 | KAF4704039.1 Spliceosome RNA helicase ddx39b, partial [Perkinsus olseni] | diamond | 1032 | 119 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26750117 | 26750117 | PRJNA1059246_P_NODE_63941_length_249_cov_0.875000_g63315_i0 | PRJNA1059246 | 63941 | 249 | 0.875 | 2.17875 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 7.24e-12 | NR | KAF4665292.1 | 330153 | g63315 | i0 | 41.8 | 0.807228915662651 | 67 | 39 | 80.7 | 0 | 216 | 16 | 3387 | 3453 | KAF4665292.1 putative ATP-dependent RNA helicase ddx60 [Perkinsus chesapeaki] | diamond | 201 | 70.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28258825 | 28258825 | PRJNA1059246_P_NODE_56326_length_269_cov_1.571429_g55700_i0 | PRJNA1059246 | 56326 | 269 | 1.571429 | 4.22714401 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 7.26e-23 | NR | KAF4675784.1 | 32597 | g55700 | i0 | 56.1 | 4.5724907063197 | 82 | 36 | 91.4 | 0 | 23 | 268 | 9 | 90 | KAF4675784.1 Cytoplasmic dynein 1 intermediate chain 2 [Perkinsus olseni] | diamond | 1230 | 103 | 0.990291262135922 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29656010 | 29656010 | PRJNA1059246_P_NODE_61290_length_251_cov_1.882022_g60664_i0 | PRJNA1059246 | 61290 | 251 | 1.882022 | 4.72387522 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 1.03e-4 | NR | KAF4665930.1 | 330153 | g60664 | i0 | 41.9 | 2.50996015936255 | 74 | 36 | 81.3 | 4 | 235 | 32 | 262 | 334 | KAF4665930.1 hypothetical protein FOL47_004349 [Perkinsus chesapeaki] | diamond | 630 | 50.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29814207 | 29814207 | PRJNA1059246_P_NODE_62711_length_250_cov_0.870056_g62085_i0 | PRJNA1059246 | 62711 | 250 | 0.870056 | 2.17514 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 1.09e-14 | NR | XP_002764574.1 | 423536 | g62085 | i0 | 43.6 | 0.936 | 78 | 44 | 93.6 | 0 | 248 | 15 | 11 | 88 | XP_002764574.1 abc transporter, putative [Perkinsus marinus ATCC 50983] | diamond | 234 | 73.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31638943 | 31638943 | PRJNA1059246_P_NODE_62136_length_251_cov_0.865169_g61510_i0 | PRJNA1059246 | 62136 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 2.86e-8 | NR | KAF4755265.1 | 32597 | g61510 | i0 | 44.8 | 6.27490039840637 | 67 | 37 | 80.1 | 0 | 9 | 209 | 19 | 85 | KAF4755265.1 Prefoldin subunit 4, partial [Perkinsus olseni] | diamond | 1575 | 56.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32461746 | 32461746 | PRJNA1059246_P_NODE_59179_length_259_cov_1.655914_g58553_i0 | PRJNA1059246 | 59179 | 259 | 1.655914 | 4.28881726 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 4.79e-16 | NR | KAF4650494.1 | 32597 | g58553 | i0 | 47.1 | 15.3359073359073 | 85 | 45 | 98.5 | 0 | 1 | 255 | 197 | 281 | KAF4650494.1 Alpha-centractin, partial [Perkinsus olseni] | diamond | 3972 | 82.8 | 0.995169082125604 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32902847 | 32902847 | PRJNA1059246_P_NODE_51840_length_284_cov_0.829384_g51214_i0 | PRJNA1059246 | 51840 | 284 | 0.829384 | 2.35545056 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 7.75e-7 | NR | KAF4710660.1 | 32597 | g51214 | i0 | 43.1 | 4.56338028169014 | 72 | 36 | 73.9 | 2 | 212 | 3 | 68 | 136 | KAF4710660.1 hypothetical protein FOZ63_014795, partial [Perkinsus olseni] | diamond | 1296 | 56.6 | 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);;