contig_metadata
13 rows where bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2088736 | 2088736 | PRJNA812715_P_NODE_34202_length_502_cov_1.435897_g32420_i0 | PRJNA812715 | 34202 | 502 | 1.435897 | 7.20820294 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.44e-26 | NR | KAF4690981.1 | 32597 | g32420 | i0 | 72.2 | 4.65537848605578 | 72 | 20 | 43 | 0 | 501 | 286 | 303 | 374 | KAF4690981.1 Methionine aminopeptidase 1 [Perkinsus olseni] | diamond | 2337 | 114 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 17390939 | 17390939 | PRJNA812715_P_NODE_20354_length_750_cov_6.382570_g18742_i0 | PRJNA812715 | 20354 | 750 | 6.38257 | 47.869275 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 5.69e-18 | NTclustered | gi|294874782|ref|XM_002767050.1| | 423536 | g18742 | i0 | 93.056 | 0.146666666666667 | 72 | 5 | 10 | 0 | 80 | 151 | 8 | 79 | Perkinsus marinus ATCC 50983 60S ribosomal protein L29, putative, mRNA | blastn | 110 | 106 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 19939075 | 19939075 | PRJNA812715_P_NODE_15856_length_913_cov_4.935714_g14398_i0 | PRJNA812715 | 15856 | 913 | 4.935714 | 45.06306882 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.05e-31 | NR | TEB19254.1 | 2494336 | g14398 | i0 | 33.7 | 0.877327491785323 | 267 | 155 | 81.8 | 8 | 838 | 92 | 1 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 801 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 26737355 | 26737355 | PRJNA812715_P_NODE_13581_length_1025_cov_3.782563_g12248_i0 | PRJNA812715 | 13581 | 1025 | 3.782563 | 38.77127075 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.5199999999999998e-47 | NR | TEB19254.1 | 2494336 | g12248 | i0 | 41.7 | 0.772682926829268 | 264 | 142 | 74.6 | 4 | 993 | 229 | 3 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 792 | 171 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 26936453 | 26936453 | PRJNA812715_P_NODE_55822_length_355_cov_1.365248_g54023_i0 | PRJNA812715 | 55822 | 355 | 1.365248 | 4.8466304 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.8e-11 | NR | XP_002765897.1 | 423536 | g54023 | i0 | 41 | 2.49295774647887 | 100 | 58 | 84.5 | 1 | 38 | 337 | 104 | 202 | XP_002765897.1 conserved hypothetical protein, partial [Perkinsus marinus ATCC 50983] | diamond | 885 | 69.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28507176 | 28507176 | PRJNA812715_P_NODE_93547_length_263_cov_1.215789_g91746_i0 | PRJNA812715 | 93547 | 263 | 1.215789 | 3.19752507 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 8.93e-10 | NR | KAF4653556.1 | 330153 | g91746 | i0 | 39 | 1.83650190114068 | 82 | 44 | 86.7 | 1 | 260 | 33 | 827 | 908 | KAF4653556.1 hypothetical protein FOL47_010443, partial [Perkinsus chesapeaki] | diamond | 483 | 64.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29801494 | 29801494 | PRJNA812715_P_NODE_123291_length_233_cov_2.406250_g121490_i0 | PRJNA812715 | 123291 | 233 | 2.40625 | 5.6065625 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.44e-29 | NR | TEB20956.1 | 2494336 | g121490 | i0 | 66.2 | 0.991416309012876 | 77 | 26 | 99.1 | 0 | 1 | 231 | 207 | 283 | TEB20956.1 Kinase domain containing protein [Perkinsus sp. BL_2016] | diamond | 231 | 118 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30433816 | 30433816 | PRJNA812715_P_NODE_116093_length_244_cov_0.900585_g114292_i0 | PRJNA812715 | 116093 | 244 | 0.900585 | 2.1974274 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.31e-4 | NR | KAF4670764.1 | 32597 | g114292 | i0 | 35 | 2.95081967213115 | 80 | 51 | 97.1 | 1 | 3 | 239 | 594 | 673 | KAF4670764.1 hypothetical protein FOZ61_008780 [Perkinsus olseni] | diamond | 720 | 49.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30812564 | 30812564 | PRJNA812715_P_NODE_66114_length_317_cov_2.512295_g64314_i0 | PRJNA812715 | 66114 | 317 | 2.512295 | 7.96397515 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 3.42e-12 | NR | XP_002788346.1 | 423536 | g64314 | i0 | 67.3 | 0.463722397476341 | 49 | 16 | 46.4 | 0 | 316 | 170 | 682 | 730 | XP_002788346.1 Stt3 protein, putative [Perkinsus marinus ATCC 50983] | diamond | 147 | 72.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31254954 | 31254954 | PRJNA812715_P_NODE_26295_length_613_cov_1.672222_g24568_i0 | PRJNA812715 | 26295 | 613 | 1.672222 | 10.25072086 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 9.35e-21 | NR | XP_002778425.1 | 423536 | g24568 | i0 | 40 | 1.99673735725938 | 145 | 74 | 66.1 | 2 | 6 | 410 | 152 | 293 | XP_002778425.1 Enkurin, putative [Perkinsus marinus ATCC 50983] | diamond | 1224 | 98.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31453691 | 31453691 | PRJNA812715_P_NODE_26676_length_606_cov_1.551595_g24940_i0 | PRJNA812715 | 26676 | 606 | 1.551595 | 9.4026657 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 317 | 1.3399999999999997e-107 | NR | TEB14221.1 | 2494336 | g24940 | i0 | 78.1 | 7.61386138613861 | 192 | 42 | 95 | 0 | 30 | 605 | 1 | 192 | TEB14221.1 Ribosomal protein L15 [Perkinsus sp. BL_2016] | diamond | 4614 | 317 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31855893 | 31855893 | PRJNA812715_P_NODE_19617_length_771_cov_2.703438_g18036_i0 | PRJNA812715 | 19617 | 771 | 2.703438 | 20.84350698 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 1.66e-12 | NR | KAF4662880.1 | 330153 | g18036 | i0 | 29.9 | 0.782101167315175 | 201 | 118 | 73.5 | 6 | 19 | 585 | 89 | 278 | KAF4662880.1 hypothetical protein FOL47_006022 [Perkinsus chesapeaki] | diamond | 603 | 77 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32425553 | 32425553 | PRJNA812715_P_NODE_49359_length_386_cov_1.204473_g47562_i0 | PRJNA812715 | 49359 | 386 | 1.204473 | 4.64926578 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 1.25e-5 | NR | KAF4666138.1 | 330153 | g47562 | i0 | 33.9 | 0.893782383419689 | 115 | 73 | 87 | 3 | 338 | 3 | 46 | 160 | KAF4666138.1 Radial spoke head protein 9 [Perkinsus chesapeaki] | diamond | 345 | 54.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki |
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);;