contig_metadata
17 rows where bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170525 | 2170525 | PRJNA915212_P_NODE_2242_length_439_cov_1.600000_g2206_i0 | PRJNA915212 | 2242 | 439 | 1.6 | 7.024 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 3.01e-70 | NR | XP_002774056.1 | 423536 | g2206 | i0 | 74.1 | 0.977220956719818 | 143 | 37 | 97.7 | 0 | 4 | 432 | 158 | 300 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 429 | 224 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 11098622 | 11098622 | PRJNA915212_P_NODE_12229_length_166_cov_0.871795_g12191_i0 | PRJNA915212 | 12229 | 166 | 0.871795 | 1.4471797 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.37e-12 | NTclustered | gi|294904388|ref|XM_002777538.1| | 423536 | g12191 | i0 | 94.545 | 0.662650602409639 | 55 | 3 | 33 | 0 | 1 | 55 | 347 | 401 | Perkinsus marinus ATCC 50983 succinate dehydrogenase, putative, mRNA | blastn | 110 | 86.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 12374311 | 12374311 | PRJNA915212_P_NODE_530_length_916_cov_2.363322_g509_i0 | PRJNA915212 | 530 | 916 | 2.363322 | 21.64802952 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 7.659999999999999e-32 | NR | TEB19254.1 | 2494336 | g509 | i0 | 33.7 | 0.874454148471616 | 267 | 155 | 81.6 | 8 | 870 | 124 | 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 | |||
| 22572176 | 22572176 | PRJNA915212_P_NODE_10498_length_178_cov_1.186047_g10460_i0 | PRJNA915212 | 10498 | 178 | 1.186047 | 2.11116366 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 6.76e-26 | NTclustered | gi|294936906|ref|XM_002781860.1| | 423536 | g10460 | i0 | 80 | 33.7415730337079 | 175 | 35 | 98 | 0 | 4 | 178 | 265 | 439 | Perkinsus marinus ATCC 50983 translation elongation factor EF-1, subunit alpha,, putative, mRNA | blastn | 6006 | 130 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 25121273 | 25121273 | PRJNA915212_P_NODE_8960_length_194_cov_1.758621_g8922_i0 | PRJNA915212 | 8960 | 194 | 1.758621 | 3.41172474 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.46e-33 | NTclustered | gi|294953618|ref|XM_002787808.1| | 423536 | g8922 | i0 | 86.014 | 4.91237113402062 | 143 | 20 | 74 | 0 | 51 | 193 | 463 | 321 | Perkinsus marinus ATCC 50983 40S ribosomal protein S14, putative, mRNA | blastn | 953 | 154 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26612874 | 26612874 | PRJNA915212_P_NODE_2161_length_448_cov_1.491228_g2125_i0 | PRJNA915212 | 2161 | 448 | 1.491228 | 6.68070144 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.2299999999999997e-55 | NR | KAF4675666.1 | 330153 | g2125 | i0 | 59.7 | 9.08035714285714 | 154 | 55 | 98.4 | 1 | 444 | 4 | 205 | 358 | KAF4675666.1 hypothetical protein FOL47_007438 [Perkinsus chesapeaki] | diamond | 4068 | 191 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27031813 | 27031813 | PRJNA915212_P_NODE_10382_length_179_cov_1.176923_g10344_i0 | PRJNA915212 | 10382 | 179 | 1.176923 | 2.10669217 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 4.7e-13 | NR | KAF4716524.1 | 32597 | g10344 | i0 | 58.6 | 8.69832402234637 | 58 | 23 | 95.5 | 1 | 2 | 172 | 84 | 141 | KAF4716524.1 hypothetical protein FOZ63_019133, partial [Perkinsus olseni] | diamond | 1557 | 70.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27530121 | 27530121 | PRJNA915212_P_NODE_443_length_995_cov_2.469345_g425_i0 | PRJNA915212 | 443 | 995 | 2.469345 | 24.56998275 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 5.78e-48 | NR | TEB19254.1 | 2494336 | g425 | i0 | 42.8 | 0.795979899497487 | 264 | 139 | 76.9 | 5 | 89 | 853 | 3 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 792 | 172 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 27751385 | 27751385 | PRJNA915212_P_NODE_544_length_901_cov_2.539906_g522_i0 | PRJNA915212 | 544 | 901 | 2.539906 | 22.884553059999998 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 3.4499999999999993e-68 | NR | TEB19254.1 | 2494336 | g522 | i0 | 47.7 | 0.872364039955605 | 262 | 130 | 84.9 | 2 | 864 | 100 | 2 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 786 | 223 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28895034 | 28895034 | PRJNA915212_P_NODE_13248_length_164_cov_0.886957_g13210_i0 | PRJNA915212 | 13248 | 164 | 0.886957 | 1.45460948 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 2.69e-6 | NR | KAF4660361.1 | 330153 | g13210 | i0 | 40.4 | 24.4207317073171 | 52 | 31 | 95.1 | 0 | 158 | 3 | 290 | 341 | KAF4660361.1 hypothetical protein FOL47_007195 [Perkinsus chesapeaki] | diamond | 4005 | 53.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29045814 | 29045814 | PRJNA915212_P_NODE_928_length_691_cov_2.591900_g898_i0 | PRJNA915212 | 928 | 691 | 2.5919 | 17.910029 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 1.14e-14 | NR | TEB19254.1 | 2494336 | g898 | i0 | 29.6 | 0.998552821997106 | 230 | 142 | 91.2 | 5 | 636 | 7 | 2 | 231 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 690 | 82 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30056050 | 30056050 | PRJNA915212_P_NODE_9211_length_191_cov_1.795775_g9173_i0 | PRJNA915212 | 9211 | 191 | 1.795775 | 3.42993025 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 2.36e-15 | NR | XP_002777422.1 | 423536 | g9173 | i0 | 57.4 | 0.958115183246073 | 61 | 26 | 95.8 | 0 | 189 | 7 | 194 | 254 | XP_002777422.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 183 | 79.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30467262 | 30467262 | PRJNA915212_P_NODE_4713_length_277_cov_1.342105_g4675_i0 | PRJNA915212 | 4713 | 277 | 1.342105 | 3.71763085 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.45e-8 | NR | TEB19254.1 | 2494336 | g4675 | i0 | 46.8 | 0.671480144404332 | 62 | 33 | 67.1 | 0 | 18 | 203 | 136 | 197 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 186 | 60.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31351830 | 31351830 | PRJNA915212_P_NODE_2556_length_405_cov_3.966292_g2520_i0 | PRJNA915212 | 2556 | 405 | 3.966292 | 16.0634826 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 3.35e-10 | NR | TEB19254.1 | 2494336 | g2520 | i0 | 38.1 | 0.992592592592593 | 134 | 74 | 92.6 | 3 | 375 | 1 | 3 | 136 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 402 | 67 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31383529 | 31383529 | PRJNA915212_P_NODE_776_length_756_cov_2.466761_g749_i0 | PRJNA915212 | 776 | 756 | 2.466761 | 18.64871316 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 7.06e-27 | NR | TEB19254.1 | 2494336 | g749 | i0 | 32.4 | 1.01587301587302 | 256 | 150 | 94 | 7 | 44 | 754 | 1 | 252 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 768 | 115 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 32047734 | 32047734 | PRJNA915212_P_NODE_4198_length_297_cov_1.649194_g4160_i0 | PRJNA915212 | 4198 | 297 | 1.649194 | 4.89810618 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.0899999999999998e-40 | NR | XP_002778466.1 | 423536 | g4160 | i0 | 74.4 | 1.81818181818182 | 90 | 23 | 90.9 | 0 | 19 | 288 | 1 | 90 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 540 | 141 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32111013 | 32111013 | PRJNA915212_P_NODE_1178_length_618_cov_2.771529_g1146_i0 | PRJNA915212 | 1178 | 618 | 2.771529 | 17.12804922 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.22e-14 | NR | TEB19254.1 | 2494336 | g1146 | i0 | 28.4 | 0.975728155339806 | 201 | 127 | 90.3 | 4 | 584 | 27 | 2 | 200 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 603 | 81.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 |
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);;