contig_metadata
12 rows where bioproject = "PRJNA312899", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14408980 | 14408980 | PRJNA312899_P_NODE_71272_length_190_cov_3.617021_g70830_i0 | PRJNA312899 | 71272 | 190 | 3.617021 | 6.8723399 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|1752336476|ref|XM_030981414.1| | 7668 | g70830 | i0 | 100 | 0.442105263157895 | 28 | 0 | 15 | 0 | 130 | 157 | 480 | 507 | PREDICTED: Strongylocentrotus purpuratus calcium-binding protein P-like (LOC115922487), transcript variant X1, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26599136 | 26599136 | PRJNA312899_P_NODE_13601_length_512_cov_7.611231_g13171_i0 | PRJNA312899 | 13601 | 512 | 7.611231 | 38.96950272 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 199 | 8.76e-60 | NR | XP_038058443.1 | 46514 | g13171 | i0 | 63.8 | 6.515625 | 160 | 53 | 93.8 | 2 | 482 | 3 | 19 | 173 | XP_038058443.1 isocitrate dehydrogenase [NAD] subunit alpha, mitochondrial-like isoform X1 [Patiria miniata] | diamond | 3336 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26599149 | 26599149 | PRJNA312899_P_NODE_28901_length_344_cov_7.376271_g28459_i0 | PRJNA312899 | 28901 | 344 | 7.376271 | 25.37437224 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 125 | 1.16e-30 | NR | KAJ8023724.1 | 206669 | g28459 | i0 | 53.1 | 0.98546511627907 | 113 | 52 | 97.7 | 1 | 1 | 336 | 181 | 293 | KAJ8023724.1 hypothetical protein HOLleu_36243 [Holothuria leucospilota] | diamond | 339 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27154631 | 27154631 | PRJNA312899_P_NODE_34782_length_308_cov_4.610039_g34340_i0 | PRJNA312899 | 34782 | 308 | 4.6100390000000004 | 14.19892012 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 106 | 3.94e-24 | NR | XP_071506195.1 | 105358 | g34340 | i0 | 46 | 2.94155844155844 | 100 | 54 | 97.4 | 0 | 305 | 6 | 491 | 590 | XP_071506195.1 DNA mismatch repair protein Mlh1-like [Diadema antillarum] | diamond | 906 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27344917 | 27344917 | PRJNA312899_P_NODE_2683_length_1018_cov_41.602683_g2465_i0 | PRJNA312899 | 2683 | 1018 | 41.602683 | 423.51531294 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 104 | 4.42e-22 | NR | XP_033635952.1 | 7604 | g2465 | i0 | 27.8 | 1.49705304518664 | 252 | 135 | 72.5 | 7 | 945 | 208 | 41 | 251 | XP_033635952.1 dehydrodolichyl diphosphate synthase complex subunit Nus1-like [Asterias rubens] | diamond | 1524 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27439782 | 27439782 | PRJNA312899_P_NODE_4303_length_860_cov_11.636252_g4022_i0 | PRJNA312899 | 4303 | 860 | 11.636252 | 100.0717672 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 3.42e-70 | NR | XP_783742.2 | 7668 | g4022 | i0 | 47.4 | 14.0686046511628 | 272 | 133 | 94.2 | 7 | 2 | 811 | 1 | 264 | XP_783742.2 26S proteasome non-ATPase regulatory subunit 8 [Strongylocentrotus purpuratus] | diamond | 12099 | 229 | 0.995633187772926 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28558760 | 28558760 | PRJNA312899_P_NODE_19587_length_426_cov_5.299735_g19146_i0 | PRJNA312899 | 19587 | 426 | 5.299735 | 22.5768711 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 65.9 | 2.3e-9 | NR | XP_071492519.1 | 105358 | g19146 | i0 | 35.6 | 6.71830985915493 | 149 | 74 | 97.9 | 5 | 6 | 422 | 662 | 798 | XP_071492519.1 tuftelin-interacting protein 11-like [Diadema antillarum] | diamond | 2862 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29411012 | 29411012 | PRJNA312899_P_NODE_51169_length_242_cov_7.663212_g50727_i0 | PRJNA312899 | 51169 | 242 | 7.663212 | 18.54497304 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 45.8 | 0.00303 | NR | XP_033125405.1 | 1529436 | g50727 | i0 | 42.3 | 1.28925619834711 | 52 | 28 | 62 | 1 | 242 | 93 | 261 | 312 | XP_033125405.1 serine/threonine-protein kinase 10-like isoform X2 [Anneissia japonica] | diamond | 312 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30390700 | 30390700 | PRJNA312899_P_NODE_7573_length_678_cov_7.806041_g7206_i0 | PRJNA312899 | 7573 | 678 | 7.806041 | 52.92495798 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 134 | 2.84e-33 | NR | XP_033645786.1 | 7604 | g7206 | i0 | 36.4 | 3.46902654867257 | 198 | 111 | 85 | 6 | 103 | 678 | 155 | 343 | XP_033645786.1 elongator complex protein 4-like isoform X2 [Asterias rubens] | diamond | 2352 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30534105 | 30534105 | PRJNA312899_P_NODE_30613_length_333_cov_2.859155_g30171_i0 | PRJNA312899 | 30613 | 333 | 2.859155 | 9.52098615 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 71.6 | 8.41e-13 | NR | KAJ8030686.1 | 206669 | g30171 | i0 | 44.4 | 4.16216216216216 | 99 | 38 | 89.2 | 2 | 332 | 36 | 100 | 181 | KAJ8030686.1 Ras-related protein O-Krev [Holothuria leucospilota] | diamond | 1386 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31324090 | 31324090 | PRJNA312899_P_NODE_38495_length_289_cov_4.879167_g38053_i0 | PRJNA312899 | 38495 | 289 | 4.879167 | 14.10079263 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 76.3 | 1.1e-13 | NR | KAJ8023724.1 | 206669 | g38053 | i0 | 49.3 | 1.49480968858131 | 73 | 37 | 75.8 | 0 | 71 | 289 | 365 | 437 | KAJ8023724.1 hypothetical protein HOLleu_36243 [Holothuria leucospilota] | diamond | 432 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32034192 | 32034192 | PRJNA312899_P_NODE_10658_length_579_cov_11.983019_g10244_i0 | PRJNA312899 | 10658 | 579 | 11.983019 | 69.38168001 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 50.1 | 0.00232 | NR | XP_033634017.1 | 7604 | g10244 | i0 | 38.5 | 1.19170984455959 | 52 | 31 | 26.9 | 1 | 479 | 324 | 240 | 290 | XP_033634017.1 protein mono-ADP-ribosyltransferase PARP12-like [Asterias rubens] | diamond | 690 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens |
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);;