contig_metadata
12 rows where bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2128692 | 2128692 | PRJNA876641_P_NODE_8502_length_291_cov_1.389908_g8428_i0 | PRJNA876641 | 8502 | 291 | 1.389908 | 4.04463228 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.0899999999999999e-43 | NR | KAF4712660.1 | 32597 | g8428 | i0 | 71.3 | 10.5257731958763 | 94 | 27 | 96.9 | 0 | 290 | 9 | 23 | 116 | KAF4712660.1 iso-1-cytochrome c [Perkinsus olseni] | diamond | 3063 | 147 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 7231535 | 7231535 | PRJNA876641_P_NODE_7546_length_305_cov_1.353448_g7472_i0 | PRJNA876641 | 7546 | 305 | 1.353448 | 4.1280164 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.42e-36 | NR | XP_002774056.1 | 423536 | g7472 | i0 | 77.6 | 0.836065573770492 | 85 | 19 | 83.6 | 0 | 3 | 257 | 230 | 314 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 255 | 135 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 8506282 | 8506282 | PRJNA876641_P_NODE_8447_length_291_cov_2.293578_g8373_i0 | PRJNA876641 | 8447 | 291 | 2.293578 | 6.67431198 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 3.3399999999999993e-31 | NTclustered | gi|294925483|ref|XM_002778887.1| | 423536 | g8373 | i0 | 80.928 | 25.4707903780069 | 194 | 31 | 66 | 5 | 1 | 191 | 244 | 434 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 7412 | 148 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 12332256 | 12332256 | PRJNA876641_P_NODE_18050_length_248_cov_0.880000_g17976_i0 | PRJNA876641 | 18050 | 248 | 0.88 | 2.1824 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.65e-29 | NTclustered | gi|294933094|ref|XM_002780549.1| | 423536 | g17976 | i0 | 90.654 | 47.2056451612903 | 107 | 8 | 43 | 2 | 128 | 233 | 595 | 490 | Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA | blastn | 11707 | 141 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 18704562 | 18704562 | PRJNA876641_P_NODE_18355_length_248_cov_0.880000_g18281_i0 | PRJNA876641 | 18355 | 248 | 0.88 | 2.1824 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.34e-4 | NTclustered | gi|294897524|ref|XM_002775945.1| | 423536 | g18281 | i0 | 97.143 | 4.20564516129032 | 35 | 1 | 14 | 0 | 11 | 45 | 620 | 586 | Perkinsus marinus ATCC 50983 Ran-binding protein, putative, mRNA | blastn | 1043 | 60.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 18704744 | 18704744 | PRJNA876641_P_NODE_7455_length_306_cov_1.978541_g7381_i0 | PRJNA876641 | 7455 | 306 | 1.978541 | 6.05433546 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 8.739999999999999e-45 | NR | KAF4686433.1 | 32597 | g7381 | i0 | 73 | 3.93137254901961 | 100 | 27 | 98 | 0 | 304 | 5 | 75 | 174 | KAF4686433.1 40S ribosomal protein S6 [Perkinsus olseni] | diamond | 1203 | 157 | 0.993630573248408 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 18704777 | 18704777 | PRJNA876641_P_NODE_9435_length_285_cov_1.806604_g9361_i0 | PRJNA876641 | 9435 | 285 | 1.806604 | 5.1488214 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 4.28e-20 | NTclustered | gi|294925483|ref|XM_002778887.1| | 423536 | g9361 | i0 | 83.065 | 9.65964912280702 | 124 | 19 | 43 | 2 | 15 | 137 | 322 | 444 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 2753 | 111 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27687456 | 27687456 | PRJNA876641_P_NODE_3164_length_413_cov_4.135294_g3090_i0 | PRJNA876641 | 3164 | 413 | 4.135294 | 17.07876422 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 5.25e-20 | NR | TEB19254.1 | 2494336 | g3090 | i0 | 44.3 | 0.76997578692494 | 106 | 55 | 77 | 2 | 4 | 321 | 157 | 258 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 318 | 93.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30213073 | 30213073 | PRJNA876641_P_NODE_1272_length_589_cov_2.908915_g1199_i0 | PRJNA876641 | 1272 | 589 | 2.908915 | 17.13350935 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1e-88 | NR | XP_002778466.1 | 423536 | g1199 | i0 | 71.4 | 0.942275042444822 | 185 | 52 | 93.7 | 1 | 555 | 4 | 1 | 185 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 555 | 268 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31991422 | 31991422 | PRJNA876641_P_NODE_19938_length_245_cov_2.122093_g19864_i0 | PRJNA876641 | 19938 | 245 | 2.122093 | 5.19912785 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 9.63e-18 | NR | KAF4653884.1 | 32597 | g19864 | i0 | 54.3 | 3.99183673469388 | 81 | 36 | 99.2 | 1 | 1 | 243 | 446 | 525 | KAF4653884.1 hypothetical protein FOZ61_008630 [Perkinsus olseni] | diamond | 978 | 87 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32054722 | 32054722 | PRJNA876641_P_NODE_19098_length_247_cov_0.885057_g19024_i0 | PRJNA876641 | 19098 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 7.75e-11 | NR | KAF4757260.1 | 32597 | g19024 | i0 | 40.7 | 7.87044534412955 | 81 | 47 | 98.4 | 1 | 3 | 245 | 89 | 168 | KAF4757260.1 hypothetical protein FOZ63_034007 [Perkinsus olseni] | diamond | 1944 | 67.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32276491 | 32276491 | PRJNA876641_P_NODE_21038_length_244_cov_0.900585_g20964_i0 | PRJNA876641 | 21038 | 244 | 0.900585 | 2.1974274 | Cryptophyceae | 3027 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 3.36e-25 | NR | KAF4670674.1 | 32597 | g20964 | i0 | 66.7 | 18.7254098360656 | 69 | 23 | 84.8 | 0 | 210 | 4 | 1 | 69 | KAF4670674.1 Ubiquitin-conjugating enzyme E2 D3 [Perkinsus olseni] | diamond | 4569 | 101 | 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);;