contig_metadata
15 rows where bioproject = "PRJNA928559", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4731191 | 4731191 | PRJNA928559_P_NODE_161244_length_276_cov_2.014778_g159675_i0 | PRJNA928559 | 161244 | 276 | 2.014778 | 5.5607872800000004 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 1.25e-39 | NR | KAF4720670.1 | 32597 | g159675 | i0 | 73.9 | 7 | 92 | 24 | 100 | 0 | 1 | 276 | 180 | 271 | KAF4720670.1 T-complex protein 1 subunit epsilon [Perkinsus olseni] | diamond | 1932 | 146 | 0.993150684931507 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 12382184 | 12382184 | PRJNA928559_P_NODE_18010_length_742_cov_2.159940_g16573_i0 | PRJNA928559 | 18010 | 742 | 2.15994 | 16.0267548 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 9.149999999999999e-56 | NR | KAF4653858.1 | 330153 | g16573 | i0 | 42.8 | 2.92318059299191 | 243 | 126 | 97 | 5 | 2 | 721 | 369 | 601 | KAF4653858.1 hypothetical protein FOL47_010271 [Perkinsus chesapeaki] | diamond | 2169 | 198 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 21306270 | 21306270 | PRJNA928559_P_NODE_58477_length_454_cov_2.293963_g56910_i0 | PRJNA928559 | 58477 | 454 | 2.293963 | 10.41459202 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 6.93e-76 | NR | TEB18614.1 | 2494336 | g56910 | i0 | 78.1 | 31.9162995594714 | 151 | 33 | 99.8 | 0 | 454 | 2 | 79 | 229 | TEB18614.1 adenosine tri phosphatase [Perkinsus sp. BL_2016] | diamond | 14490 | 241 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 26676341 | 26676341 | PRJNA928559_P_NODE_44321_length_508_cov_2.855172_g42763_i0 | PRJNA928559 | 44321 | 508 | 2.855172 | 14.50427376 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 6.8e-45 | NR | KAF4685574.1 | 32597 | g42763 | i0 | 58.7 | 2.81102362204724 | 121 | 50 | 71.5 | 0 | 382 | 20 | 115 | 235 | KAF4685574.1 hypothetical protein FOZ62_006760, partial [Perkinsus olseni] | diamond | 1428 | 159 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27593697 | 27593697 | PRJNA928559_P_NODE_59544_length_451_cov_1.195767_g57977_i0 | PRJNA928559 | 59544 | 451 | 1.195767 | 5.39290917 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.1e-13 | NR | KAF4677161.1 | 330153 | g57977 | i0 | 33.3 | 3.83813747228381 | 156 | 97 | 99.1 | 3 | 5 | 451 | 483 | 638 | KAF4677161.1 cytochrome P450 monooxygenase 9 [Perkinsus chesapeaki] | diamond | 1731 | 77.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27790252 | 27790252 | PRJNA928559_P_NODE_50604_length_482_cov_1.462103_g49042_i0 | PRJNA928559 | 50604 | 482 | 1.462103 | 7.04733646 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.04e-19 | NR | XP_002781727.1 | 423536 | g49042 | i0 | 53.7 | 2.43360995850622 | 82 | 37 | 51 | 1 | 96 | 341 | 64 | 144 | XP_002781727.1 U2 small nuclear ribonucleoprotein, auxiliary factor, small subunit, putative [Perkinsus marinus ATCC 50983] | diamond | 1173 | 94.4 | 0.991525423728813 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27916244 | 27916244 | PRJNA928559_P_NODE_214885_length_242_cov_0.923077_g213316_i0 | PRJNA928559 | 214885 | 242 | 0.923077 | 2.23384634 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.25e-18 | NR | KAF4723439.1 | 32597 | g213316 | i0 | 55.7 | 14.9876033057851 | 70 | 31 | 86.8 | 0 | 5 | 214 | 220 | 289 | KAF4723439.1 hypothetical protein FOZ62_025243, partial [Perkinsus olseni] | diamond | 3627 | 89.7 | 0.992196209587514 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28200369 | 28200369 | PRJNA928559_P_NODE_224366_length_225_cov_4.414474_g222797_i0 | PRJNA928559 | 224366 | 225 | 4.414474 | 9.9325665 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 2.38e-31 | NR | KAF4698419.1 | 32597 | g222797 | i0 | 75.7 | 7.89333333333333 | 74 | 18 | 98.7 | 0 | 223 | 2 | 135 | 208 | KAF4698419.1 hypothetical protein FOZ62_011793 [Perkinsus olseni] | diamond | 1776 | 122 | 0.991803278688525 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28382858 | 28382858 | PRJNA928559_P_NODE_211266_length_243_cov_1.694118_g209697_i0 | PRJNA928559 | 211266 | 243 | 1.694118 | 4.11670674 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 2.36e-6 | NR | XP_002778557.1 | 423536 | g209697 | i0 | 39 | 1.35802469135802 | 59 | 36 | 72.8 | 0 | 240 | 64 | 758 | 816 | XP_002778557.1 hypothetical protein Pmar_PMAR007760 [Perkinsus marinus ATCC 50983] | diamond | 330 | 54.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29589498 | 29589498 | PRJNA928559_P_NODE_209690_length_244_cov_0.912281_g208121_i0 | PRJNA928559 | 209690 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.43e-7 | NR | KAF4653409.1 | 32597 | g208121 | i0 | 36.5 | 2.38524590163934 | 63 | 40 | 77.5 | 0 | 1 | 189 | 123 | 185 | KAF4653409.1 Vacuolar protein sorting-associated protein ist1 [Perkinsus olseni] | diamond | 582 | 57.4 | 0.993031358885017 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29898530 | 29898530 | PRJNA928559_P_NODE_168451_length_269_cov_2.693878_g166882_i0 | PRJNA928559 | 168451 | 269 | 2.693878 | 7.24653182 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 9.72e-10 | NR | KAF4676510.1 | 330153 | g166882 | i0 | 40 | 1.17100371747212 | 105 | 45 | 97 | 3 | 265 | 5 | 379 | 483 | KAF4676510.1 hypothetical protein FOL47_005946 [Perkinsus chesapeaki] | diamond | 315 | 64.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30435898 | 30435898 | PRJNA928559_P_NODE_55753_length_463_cov_2.264103_g54186_i0 | PRJNA928559 | 55753 | 463 | 2.264103 | 10.48279689 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.07e-11 | NR | XP_002779425.1 | 423536 | g54186 | i0 | 34.7 | 0.971922246220302 | 150 | 95 | 95.2 | 3 | 20 | 460 | 2785 | 2934 | XP_002779425.1 dynein-1-alpha heavy chain, flagellar inner arm I1 complex, putative [Perkinsus marinus ATCC 50983] | diamond | 450 | 73.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32016246 | 32016246 | PRJNA928559_P_NODE_211958_length_243_cov_0.917647_g210389_i0 | PRJNA928559 | 211958 | 243 | 0.917647 | 2.22988221 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.64e-22 | NR | KAF4657124.1 | 330153 | g210389 | i0 | 54.3 | 2.96296296296296 | 81 | 37 | 100 | 0 | 243 | 1 | 18 | 98 | KAF4657124.1 Eukaryotic translation initiation factor 5A-1 [Perkinsus chesapeaki] | diamond | 720 | 94 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32371635 | 32371635 | PRJNA928559_P_NODE_169539_length_268_cov_2.471795_g167970_i0 | PRJNA928559 | 169539 | 268 | 2.471795 | 6.6244106 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00218 | NR | KAF4661246.1 | 330153 | g167970 | i0 | 32.6 | 2.88805970149254 | 89 | 42 | 98.5 | 2 | 3 | 266 | 633 | 704 | KAF4661246.1 H(+)-transporting V0 sector ATPase subunit a [Perkinsus chesapeaki] | diamond | 774 | 47 | 0.991489361702128 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32781586 | 32781586 | PRJNA928559_P_NODE_32020_length_580_cov_4.893491_g30489_i0 | PRJNA928559 | 32020 | 580 | 4.893491 | 28.3822478 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.13e-23 | NR | KAF4684998.1 | 32597 | g30489 | i0 | 35.7 | 3.02068965517241 | 196 | 108 | 97.2 | 6 | 571 | 8 | 82 | 267 | KAF4684998.1 Protein phosphatase PP2A regulatory subunit B, partial [Perkinsus olseni] | diamond | 1752 | 105 | 0.990476190476191 | 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);;