contig_metadata
19 rows where bioproject = "PRJNA849822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838530 | 838530 | PRJNA849822_P_NODE_1861_length_1196_cov_2.574354_g1751_i0 | PRJNA849822 | 1861 | 1196 | 2.574354 | 30.78927384 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 2.01e-145 | NR | XP_002774056.1 | 423536 | g1751 | i0 | 65.7 | 0.775083612040134 | 309 | 103 | 76.8 | 2 | 1195 | 278 | 6 | 314 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 927 | 425 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 5942013 | 5942013 | PRJNA849822_P_NODE_8745_length_510_cov_5.466819_g8573_i0 | PRJNA849822 | 8745 | 510 | 5.466819 | 27.8807769 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 2.07e-80 | NTclustered | gi|294891115|ref|XM_002773382.1| | 423536 | g8573 | i0 | 82.432 | 74.8764705882353 | 370 | 53 | 71 | 12 | 53 | 416 | 438 | 75 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 38187 | 313 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 22515320 | 22515320 | PRJNA849822_P_NODE_1958_length_1174_cov_3.544959_g1751_i1 | PRJNA849822 | 1958 | 1174 | 3.544959 | 41.61781866 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 2.079999999999999e-143 | NR | XP_002774056.1 | 423536 | g1751 | i1 | 66.7 | 0.766609880749574 | 300 | 98 | 76.1 | 1 | 4 | 897 | 15 | 314 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 900 | 420 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26841921 | 26841921 | PRJNA849822_P_NODE_39261_length_246_cov_1.352601_g39087_i0 | PRJNA849822 | 39261 | 246 | 1.352601 | 3.32739846 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 7.29e-13 | NR | KAF4722150.1 | 32597 | g39087 | i0 | 57.1 | 11.6219512195122 | 70 | 30 | 85.4 | 0 | 37 | 246 | 2 | 71 | KAF4722150.1 hypothetical protein FOZ62_026828 [Perkinsus olseni] | diamond | 2859 | 73.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28413064 | 28413064 | PRJNA849822_P_NODE_6466_length_608_cov_2.306542_g6297_i0 | PRJNA849822 | 6466 | 608 | 2.306542 | 14.02377536 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 245 | 2.4100000000000003e-79 | NR | XP_002778466.1 | 423536 | g6297 | i0 | 61.6 | 2.78782894736842 | 190 | 72 | 93.3 | 1 | 608 | 42 | 3 | 192 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 1695 | 245 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28444716 | 28444716 | PRJNA849822_P_NODE_7746_length_548_cov_2.524211_g7574_i0 | PRJNA849822 | 7746 | 548 | 2.524211 | 13.83267628 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 0.00794 | NR | KAF4657269.1 | 330153 | g7574 | i0 | 61.3 | 0.16970802919708 | 31 | 11 | 17 | 1 | 378 | 286 | 439 | 468 | KAF4657269.1 hypothetical protein FOL47_008531 [Perkinsus chesapeaki] | diamond | 93 | 48.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28705499 | 28705499 | PRJNA849822_P_NODE_15847_length_365_cov_1.068493_g15673_i0 | PRJNA849822 | 15847 | 365 | 1.068493 | 3.89999945 | root | 1 | Root_unresolved | Root_unresolved | 126 | 4.16e-32 | NR | TEB20199.1 | 2494336 | g15673 | i0 | 51.3 | 1.93972602739726 | 117 | 55 | 96.2 | 1 | 359 | 9 | 237 | 351 | TEB20199.1 hypothetical protein C9890_0096 [Perkinsus sp. BL_2016] | diamond | 708 | 126 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28760220 | 28760220 | PRJNA849822_P_NODE_43007_length_242_cov_0.923077_g42833_i0 | PRJNA849822 | 43007 | 242 | 0.923077 | 2.23384634 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 1.88e-7 | NR | TEB18997.1 | 2494336 | g42833 | i0 | 34.7 | 1.72314049586777 | 75 | 49 | 93 | 0 | 11 | 235 | 585 | 659 | TEB18997.1 oxidoreductase [Perkinsus sp. BL_2016] | diamond | 417 | 57.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28854844 | 28854844 | PRJNA849822_P_NODE_38868_length_247_cov_0.896552_g38694_i0 | PRJNA849822 | 38868 | 247 | 0.896552 | 2.21448344 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 5.45e-8 | NR | KAF4649636.1 | 32597 | g38694 | i0 | 41.7 | 2.62348178137652 | 72 | 42 | 87.4 | 0 | 30 | 245 | 103 | 174 | KAF4649636.1 hypothetical protein FOZ61_001118, partial [Perkinsus olseni] | diamond | 648 | 59.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29557731 | 29557731 | PRJNA849822_P_NODE_20930_length_316_cov_3.551440_g20756_i0 | PRJNA849822 | 20930 | 316 | 3.55144 | 11.2225504 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.11e-11 | NR | ABY27182.1 | 31276 | g20756 | i0 | 50.7 | 2.90506329113924 | 75 | 34 | 70.3 | 2 | 293 | 72 | 11 | 83 | ABY27182.1 acidic ribosomal protein P1 [Perkinsus marinus] | diamond | 918 | 67 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29580870 | 29580870 | PRJNA849822_P_NODE_17130_length_351_cov_0.834532_g16956_i0 | PRJNA849822 | 17130 | 351 | 0.834532 | 2.92920732 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 6.41e-16 | NR | KAF4690687.1 | 32597 | g16956 | i0 | 38.3 | 5.36752136752137 | 128 | 68 | 100 | 2 | 351 | 1 | 373 | 500 | KAF4690687.1 hypothetical protein FOZ60_017055 [Perkinsus olseni] | diamond | 1884 | 83.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30244631 | 30244631 | PRJNA849822_P_NODE_28032_length_276_cov_1.137931_g27858_i0 | PRJNA849822 | 28032 | 276 | 1.137931 | 3.14068956 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 7.05e-29 | NR | XP_002774056.1 | 423536 | g27858 | i0 | 75.7 | 1.60869565217391 | 74 | 18 | 80.4 | 0 | 274 | 53 | 243 | 316 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 444 | 115 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30844918 | 30844918 | PRJNA849822_P_NODE_33474_length_253_cov_0.866667_g33300_i0 | PRJNA849822 | 33474 | 253 | 0.866667 | 2.19266751 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 4.66e-13 | NR | KAF4710916.1 | 32597 | g33300 | i0 | 44.7 | 4.50592885375494 | 76 | 41 | 90.1 | 1 | 26 | 253 | 20 | 94 | KAF4710916.1 hypothetical protein FOZ63_019925, partial [Perkinsus olseni] | diamond | 1140 | 70.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31350631 | 31350631 | PRJNA849822_P_NODE_33656_length_253_cov_0.866667_g33482_i0 | PRJNA849822 | 33656 | 253 | 0.866667 | 2.19266751 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 7.33e-12 | NR | XP_002781944.1 | 423536 | g33482 | i0 | 47.8 | 4.70750988142292 | 69 | 35 | 80.6 | 1 | 247 | 44 | 615 | 683 | XP_002781944.1 membrane glycoprotein yil173w precursor, putative [Perkinsus marinus ATCC 50983] | diamond | 1191 | 70.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31413799 | 31413799 | PRJNA849822_P_NODE_25416_length_288_cov_1.427907_g25242_i0 | PRJNA849822 | 25416 | 288 | 1.427907 | 4.11237216 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 1.09e-6 | NR | KAF4652386.1 | 32597 | g25242 | i0 | 58.3 | 1.6875 | 48 | 20 | 50 | 0 | 1 | 144 | 241 | 288 | KAF4652386.1 Ethanolamine-phosphate cytidylyltransferase [Perkinsus olseni] | diamond | 486 | 56.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31508816 | 31508816 | PRJNA849822_P_NODE_26596_length_282_cov_1.521531_g26422_i0 | PRJNA849822 | 26596 | 282 | 1.521531 | 4.29071742 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 9.9e-6 | NR | KAF4691940.1 | 32597 | g26422 | i0 | 56.4 | 0.840425531914894 | 39 | 17 | 41.5 | 0 | 22 | 138 | 293 | 331 | KAF4691940.1 OTU domain, ubiquitin aldehyde binding [Perkinsus olseni] | diamond | 237 | 53.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31730002 | 31730002 | PRJNA849822_P_NODE_42637_length_242_cov_2.307692_g42463_i0 | PRJNA849822 | 42637 | 242 | 2.307692 | 5.58461464 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00306 | NR | XP_002778833.1 | 423536 | g42463 | i0 | 24.4 | 0.966942148760331 | 78 | 59 | 96.7 | 0 | 239 | 6 | 248 | 325 | XP_002778833.1 NAD-specific glutamate dehydrogenase, putative [Perkinsus marinus ATCC 50983] | diamond | 234 | 45.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32655102 | 32655102 | PRJNA849822_P_NODE_21020_length_316_cov_1.283951_g20846_i0 | PRJNA849822 | 21020 | 316 | 1.283951 | 4.05728516 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 4.71e-22 | NR | KAF4724606.1 | 32597 | g20846 | i0 | 49.5 | 6.86392405063291 | 103 | 51 | 96.8 | 1 | 311 | 6 | 452 | 554 | KAF4724606.1 hypothetical protein FOZ63_020143 [Perkinsus olseni] | diamond | 2169 | 101 | 0.99009900990099 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32678405 | 32678405 | PRJNA849822_P_NODE_16420_length_358_cov_1.343860_g16246_i0 | PRJNA849822 | 16420 | 358 | 1.34386 | 4.8110188 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 2.25e-19 | NR | KAF4652556.1 | 32597 | g16246 | i0 | 45 | 3.76256983240223 | 111 | 59 | 91.3 | 1 | 327 | 1 | 705 | 815 | KAF4652556.1 AarF domain containing kinase 2, variant 2 [Perkinsus olseni] | diamond | 1347 | 93.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);;