contig_metadata
19 rows where bioproject = "PRJNA966993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1265534 | 1265534 | PRJNA966993_P_NODE_4441_length_976_cov_2.354374_g4131_i0 | PRJNA966993 | 4441 | 976 | 2.354374 | 22.97869024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 9.740000000000001e-64 | NR | KAF4684109.1 | 32597 | g4131 | i0 | 41.2 | 3.44569672131148 | 289 | 147 | 84.2 | 5 | 913 | 92 | 257 | 537 | KAF4684109.1 hypothetical protein FOZ63_025580 [Perkinsus olseni] | diamond | 3363 | 223 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 7320307 | 7320307 | PRJNA966993_P_NODE_50766_length_304_cov_1.831169_g50314_i0 | PRJNA966993 | 50766 | 304 | 1.831169 | 5.56675376 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.17e-53 | NR | KAF4716638.1 | 32597 | g50314 | i0 | 86.6 | 10.3026315789474 | 97 | 13 | 95.7 | 0 | 13 | 303 | 1 | 97 | KAF4716638.1 Isocitrate dehydrogenase [NADP], mitochondrial precursor (Oxalosuccinate decarboxylase), partial [Perkinsus olseni] | diamond | 3132 | 174 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 8595664 | 8595664 | PRJNA966993_P_NODE_9947_length_663_cov_4.788136_g9525_i0 | PRJNA966993 | 9947 | 663 | 4.788136 | 31.74534168 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 332 | 1.91e-111 | NR | XP_002774056.1 | 423536 | g9525 | i0 | 75.8 | 0.95475113122172 | 211 | 51 | 95.5 | 0 | 5 | 637 | 105 | 315 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 633 | 332 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 14019389 | 14019389 | PRJNA966993_P_NODE_46671_length_316_cov_1.884774_g46219_i0 | PRJNA966993 | 46671 | 316 | 1.884774 | 5.95588584 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 4.51e-8 | NR | TEB19254.1 | 2494336 | g46219 | i0 | 44.7 | 0.892405063291139 | 94 | 44 | 81.6 | 3 | 259 | 2 | 56 | 149 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 282 | 60.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 16245268 | 16245268 | PRJNA966993_P_NODE_73833_length_264_cov_1.738220_g73381_i0 | PRJNA966993 | 73833 | 264 | 1.73822 | 4.5889008 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 5.37e-36 | NR | KAF4657124.1 | 330153 | g73381 | i0 | 76.4 | 1.64772727272727 | 72 | 17 | 81.8 | 0 | 217 | 2 | 19 | 90 | KAF4657124.1 Eukaryotic translation initiation factor 5A-1 [Perkinsus chesapeaki] | diamond | 435 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 17520264 | 17520264 | PRJNA966993_P_NODE_50374_length_305_cov_2.844828_g49922_i0 | PRJNA966993 | 50374 | 305 | 2.844828 | 8.6767254 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.7600000000000002e-26 | NR | KAF4685574.1 | 32597 | g49922 | i0 | 72.4 | 1.14098360655738 | 58 | 16 | 57 | 0 | 129 | 302 | 115 | 172 | KAF4685574.1 hypothetical protein FOZ62_006760, partial [Perkinsus olseni] | diamond | 348 | 109 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 17520422 | 17520422 | PRJNA966993_P_NODE_67314_length_274_cov_1.532338_g66862_i0 | PRJNA966993 | 67314 | 274 | 1.532338 | 4.19860612 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.3e-19 | NTclustered | gi|294932372|ref|XM_002780194.1| | 423536 | g66862 | i0 | 89.535 | 0.313868613138686 | 86 | 8 | 31 | 1 | 174 | 259 | 151 | 67 | Perkinsus marinus ATCC 50983 40S ribosomal protein S25, putative, mRNA | blastn | 86 | 108 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 21344261 | 21344261 | PRJNA966993_P_NODE_41017_length_336_cov_2.752852_g40565_i0 | PRJNA966993 | 41017 | 336 | 2.752852 | 9.24958272 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 2.32e-15 | NR | KAF4669736.1 | 330153 | g40565 | i0 | 41.3 | 0.973214285714286 | 109 | 54 | 97.3 | 2 | 328 | 2 | 338 | 436 | KAF4669736.1 hypothetical protein FOL47_002386 [Perkinsus chesapeaki] | diamond | 327 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 22619137 | 22619137 | PRJNA966993_P_NODE_28718_length_395_cov_1.913043_g28266_i0 | PRJNA966993 | 28718 | 395 | 1.913043 | 7.55651985 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 5.94e-45 | NTclustered | gi|294953686|ref|XM_002787842.1| | 423536 | g28266 | i0 | 76.88 | 2.2379746835443 | 359 | 73 | 90 | 10 | 32 | 385 | 31 | 384 | Perkinsus marinus ATCC 50983 40S ribosomal protein S6, putative, mRNA | blastn | 884 | 195 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27784247 | 27784247 | PRJNA966993_P_NODE_45704_length_319_cov_3.130081_g45252_i0 | PRJNA966993 | 45704 | 319 | 3.130081 | 9.98495839 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 2.53e-14 | NR | XP_002782567.1 | 423536 | g45252 | i0 | 47.4 | 0.893416927899687 | 95 | 48 | 89.3 | 1 | 31 | 315 | 4 | 96 | XP_002782567.1 Basic endochitinase 1 precursor, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 285 | 77.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28036750 | 28036750 | PRJNA966993_P_NODE_73785_length_264_cov_2.026178_g73333_i0 | PRJNA966993 | 73785 | 264 | 2.026178 | 5.34910992 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00543 | NR | KAF4661184.1 | 32597 | g73333 | i0 | 73.1 | 0.590909090909091 | 26 | 7 | 29.5 | 0 | 263 | 186 | 84 | 109 | KAF4661184.1 hypothetical protein FOZ61_003450 [Perkinsus olseni] | diamond | 156 | 45.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28920543 | 28920543 | PRJNA966993_P_NODE_68788_length_272_cov_1.417085_g68336_i0 | PRJNA966993 | 68788 | 272 | 1.417085 | 3.8544712 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 2.91e-10 | NR | KAF4654467.1 | 32597 | g68336 | i0 | 39.3 | 2.94485294117647 | 89 | 52 | 98.2 | 1 | 267 | 1 | 1090 | 1176 | KAF4654467.1 Programmed cell death protein 4 [Perkinsus olseni] | diamond | 801 | 66.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29205025 | 29205025 | PRJNA966993_P_NODE_16369_length_517_cov_2.427928_g15927_i0 | PRJNA966993 | 16369 | 517 | 2.427928 | 12.55238776 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.25e-42 | NR | KAF4658211.1 | 330153 | g15927 | i0 | 54.4 | 3.40618955512573 | 160 | 73 | 92.8 | 0 | 517 | 38 | 231 | 390 | KAF4658211.1 hypothetical protein FOL47_008124 [Perkinsus chesapeaki] | diamond | 1761 | 161 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29495353 | 29495353 | PRJNA966993_P_NODE_48330_length_311_cov_1.294118_g47878_i0 | PRJNA966993 | 48330 | 311 | 1.294118 | 4.02470698 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.51e-4 | NR | KAF4704744.1 | 32597 | g47878 | i0 | 35 | 8.91318327974277 | 100 | 64 | 95.5 | 1 | 299 | 3 | 127 | 226 | KAF4704744.1 Dynein heavy chain 10, axonemal [Perkinsus olseni] | diamond | 2772 | 50.8 | 0.992125984251969 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30221716 | 30221716 | PRJNA966993_P_NODE_39932_length_340_cov_2.812734_g39480_i0 | PRJNA966993 | 39932 | 340 | 2.812734 | 9.5632956 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 3.88e-29 | NR | KAF4732395.1 | 32597 | g39480 | i0 | 63.7 | 19.4205882352941 | 91 | 33 | 80.3 | 0 | 1 | 273 | 109 | 199 | KAF4732395.1 60S ribosomal protein L7A, partial [Perkinsus olseni] | diamond | 6603 | 114 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30600834 | 30600834 | PRJNA966993_P_NODE_75593_length_261_cov_2.436170_g75141_i0 | PRJNA966993 | 75593 | 261 | 2.43617 | 6.3584037 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 3.53e-15 | NR | KAF4669530.1 | 32597 | g75141 | i0 | 48.2 | 13.8735632183908 | 83 | 41 | 94.3 | 2 | 7 | 252 | 72 | 153 | KAF4669530.1 hypothetical protein FOL46_001353 [Perkinsus olseni] | diamond | 3621 | 80.1 | 0.990012484394507 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30657755 | 30657755 | PRJNA966993_P_NODE_22453_length_443_cov_5.762162_g22006_i0 | PRJNA966993 | 22453 | 443 | 5.762162 | 25.52637766 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 99.8 | 2.33e-22 | NR | TEB19254.1 | 2494336 | g22006 | i0 | 44.2 | 0.873589164785553 | 129 | 67 | 86.7 | 3 | 442 | 59 | 139 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 387 | 99.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30664117 | 30664117 | PRJNA966993_P_NODE_49573_length_308_cov_1.638298_g49121_i0 | PRJNA966993 | 49573 | 308 | 1.638298 | 5.04595784 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 1.18e-42 | NR | KAF4671046.1 | 32597 | g49121 | i0 | 69.6 | 6.80844155844156 | 102 | 31 | 99.4 | 0 | 306 | 1 | 142 | 243 | KAF4671046.1 hypothetical protein FOZ61_006864 [Perkinsus olseni] | diamond | 2097 | 155 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32680987 | 32680987 | PRJNA966993_P_NODE_88500_length_247_cov_2.637931_g88048_i0 | PRJNA966993 | 88500 | 247 | 2.637931 | 6.51568957 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 1.02e-4 | NR | KAF4728112.1 | 32597 | g88048 | i0 | 36.7 | 3.04858299595142 | 60 | 38 | 72.9 | 0 | 7 | 186 | 55 | 114 | KAF4728112.1 hypothetical protein FOZ62_025876 [Perkinsus olseni] | diamond | 753 | 50.1 | 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);;