contig_metadata
21 rows where bioproject = "PRJNA793147", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 777586 | 777586 | PRJNA793147_P_NODE_28501_length_312_cov_2.370370_g28235_i0 | PRJNA793147 | 28501 | 312 | 2.37037 | 7.3955544 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 132 | 5.4e-37 | NR | XP_033647181.1 | 7604 | g28235 | i0 | 76.2 | 8.07692307692308 | 84 | 20 | 80.8 | 0 | 3 | 254 | 85 | 168 | XP_033647181.1 actin-related protein 2/3 complex subunit 4 [Asterias rubens] | diamond | 2520 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 778018 | 778018 | PRJNA793147_P_NODE_51041_length_235_cov_0.867470_g50775_i0 | PRJNA793147 | 51041 | 235 | 0.86747 | 2.0385545 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 127 | 1.89e-32 | NR | XP_041476787.1 | 7654 | g50775 | i0 | 74.4 | 5.91063829787234 | 78 | 20 | 99.6 | 0 | 1 | 234 | 281 | 358 | XP_041476787.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase-like [Lytechinus variegatus] | diamond | 1389 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 5880882 | 5880882 | PRJNA793147_P_NODE_14165_length_452_cov_4.660574_g13899_i0 | PRJNA793147 | 14165 | 452 | 4.660574 | 21.06579448 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 271 | 6.15e-88 | NR | XP_030854228.1 | 7668 | g13899 | i0 | 87.3 | 4.95796460176991 | 150 | 19 | 99.6 | 0 | 450 | 1 | 219 | 368 | XP_030854228.1 actin-related protein 2 isoform X3 [Strongylocentrotus purpuratus] | diamond | 2241 | 273 | 0.992673992673993 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 12256916 | 12256916 | PRJNA793147_P_NODE_12470_length_486_cov_9.417266_g12204_i0 | PRJNA793147 | 12470 | 486 | 9.417266 | 45.76791276 | Paracentrotus lividus | 7656 | Echinodermata | other_Eukaryota | 322 | 3.27e-83 | NTclustered | gi|557665|emb|X76081.1| | 7656 | g12204 | i0 | 80.779 | 89.9115226337449 | 411 | 79 | 85 | 0 | 53 | 463 | 475 | 65 | P.lividus H3.3 Histone mRNA | blastn | 43697 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Paracentrotus | Paracentrotus lividus | |
| 22455244 | 22455244 | PRJNA793147_P_NODE_48318_length_241_cov_4.337209_g48052_i0 | PRJNA793147 | 48318 | 241 | 4.337209 | 10.45267369 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 104 | 5.9e-18 | NTclustered | gi|1229139618|ref|XM_022226212.1| | 133434 | g48052 | i0 | 92.958 | 5.58921161825726 | 71 | 5 | 29 | 0 | 169 | 239 | 1567 | 1497 | PREDICTED: Acanthaster planci tubulin alpha chain-like (LOC110974513), mRNA | blastn | 1347 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 26651189 | 26651189 | PRJNA793147_P_NODE_33241_length_291_cov_1.436937_g32975_i0 | PRJNA793147 | 33241 | 291 | 1.436937 | 4.18148667 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 116 | 4.26e-28 | NR | XP_033646621.1 | 7604 | g32975 | i0 | 60.6 | 3.85567010309278 | 94 | 37 | 96.9 | 0 | 291 | 10 | 376 | 469 | XP_033646621.1 translation initiation factor eIF-2B subunit delta-like [Asterias rubens] | diamond | 1122 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27306799 | 27306799 | PRJNA793147_P_NODE_62863_length_222_cov_2.549020_g62597_i0 | PRJNA793147 | 62863 | 222 | 2.54902 | 5.6588244 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 114 | 3.7699999999999995e-30 | NR | XP_054759019.2 | 7653 | g62597 | i0 | 75.7 | 35.5675675675676 | 70 | 17 | 94.6 | 0 | 212 | 3 | 35 | 104 | XP_054759019.2 AP-2 complex subunit sigma [Lytechinus pictus] | diamond | 7896 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27780479 | 27780479 | PRJNA793147_P_NODE_43864_length_254_cov_2.329730_g43598_i0 | PRJNA793147 | 43864 | 254 | 2.32973 | 5.9175142 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 45.8 | 0.00335 | NR | XP_071511151.1 | 105358 | g43598 | i0 | 43.8 | 0.566929133858268 | 48 | 26 | 56.7 | 1 | 9 | 152 | 145 | 191 | XP_071511151.1 lupus La protein homolog, partial [Diadema antillarum] | diamond | 144 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27906371 | 27906371 | PRJNA793147_P_NODE_46965_length_245_cov_2.454545_g46699_i0 | PRJNA793147 | 46965 | 245 | 2.454545 | 6.01363525 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 72.8 | 2.25e-13 | NR | XP_033101881.1 | 1529436 | g46699 | i0 | 50 | 0.930612244897959 | 76 | 38 | 93.1 | 0 | 228 | 1 | 112 | 187 | XP_033101881.1 V-type proton ATPase subunit E-like [Anneissia japonica] | diamond | 228 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27915658 | 27915658 | PRJNA793147_P_NODE_62065_length_226_cov_0.917197_g61799_i0 | PRJNA793147 | 62065 | 226 | 0.917197 | 2.07286522 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 103 | 8.91e-24 | NR | XP_033639904.1 | 7604 | g61799 | i0 | 71.8 | 19.7920353982301 | 71 | 20 | 94.2 | 0 | 3 | 215 | 376 | 446 | XP_033639904.1 tubulin gamma-1 chain [Asterias rubens] | diamond | 4473 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28231277 | 28231277 | PRJNA793147_P_NODE_62926_length_221_cov_2.743421_g62660_i0 | PRJNA793147 | 62926 | 221 | 2.743421 | 6.06296041 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 107 | 7.16e-28 | NR | XP_041457170.1 | 7654 | g62660 | i0 | 63 | 14.8642533936652 | 73 | 27 | 99.1 | 0 | 221 | 3 | 25 | 97 | XP_041457170.1 ubiquitin-conjugating enzyme E2 L3-like [Lytechinus variegatus] | diamond | 3285 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28547532 | 28547532 | PRJNA793147_P_NODE_59807_length_228_cov_0.905660_g59541_i0 | PRJNA793147 | 59807 | 228 | 0.90566 | 2.0649048 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 43.9 | 0.0118 | NR | KAJ8046817.1 | 206669 | g59541 | i0 | 35.1 | 1.88157894736842 | 74 | 47 | 96.1 | 1 | 8 | 226 | 134 | 207 | KAJ8046817.1 G-patch domain and KOW motifs-containing protein [Holothuria leucospilota] | diamond | 429 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28610463 | 28610463 | PRJNA793147_P_NODE_43107_length_257_cov_1.148936_g42841_i0 | PRJNA793147 | 43107 | 257 | 1.148936 | 2.95276552 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 134 | 8.92e-37 | NR | XP_054774624.2 | 7653 | g42841 | i0 | 71.8 | 5.95330739299611 | 85 | 24 | 99.2 | 0 | 256 | 2 | 75 | 159 | XP_054774624.2 transaldolase-like [Lytechinus pictus] | diamond | 1530 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 28980353 | 28980353 | PRJNA793147_P_NODE_50528_length_235_cov_1.734940_g50262_i0 | PRJNA793147 | 50528 | 235 | 1.73494 | 4.077109 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 60.8 | 1.4e-8 | NR | KAJ8042965.1 | 206669 | g50262 | i0 | 35.9 | 0.995744680851064 | 78 | 48 | 97 | 1 | 235 | 8 | 570 | 647 | KAJ8042965.1 Beta-adrenergic receptor kinase 2 [Holothuria leucospilota] | diamond | 234 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29169749 | 29169749 | PRJNA793147_P_NODE_43549_length_255_cov_2.123656_g43283_i0 | PRJNA793147 | 43549 | 255 | 2.123656 | 5.4153228 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 62.4 | 5.05e-9 | NR | XP_022079891.1 | 133434 | g43283 | i0 | 41.1 | 1.05882352941176 | 90 | 40 | 90.6 | 2 | 244 | 14 | 68 | 157 | XP_022079891.1 secretin receptor-like [Acanthaster planci] | diamond | 270 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29936673 | 29936673 | PRJNA793147_P_NODE_48531_length_241_cov_1.465116_g48265_i0 | PRJNA793147 | 48531 | 241 | 1.465116 | 3.53092956 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 63.5 | 1.62e-9 | NR | XP_063963722.1 | 7653 | g48265 | i0 | 39.7 | 5.82572614107884 | 78 | 45 | 97.1 | 1 | 6 | 239 | 277 | 352 | XP_063963722.1 deleted in malignant brain tumors 1 protein-like [Lytechinus pictus] | diamond | 1404 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30031437 | 30031437 | PRJNA793147_P_NODE_21851_length_356_cov_1.972125_g21585_i0 | PRJNA793147 | 21851 | 356 | 1.972125 | 7.020765 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 129 | 2.65e-36 | NR | XP_022087362.1 | 133434 | g21585 | i0 | 69.6 | 5.81460674157303 | 92 | 27 | 77.5 | 1 | 352 | 77 | 5 | 95 | XP_022087362.1 probable 60S ribosomal protein L37-A isoform X2 [Acanthaster planci] | diamond | 2070 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30821266 | 30821266 | PRJNA793147_P_NODE_31514_length_298_cov_1.786026_g31248_i0 | PRJNA793147 | 31514 | 298 | 1.786026 | 5.32235748 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 100 | 1.03e-23 | NR | XP_022085354.1 | 133434 | g31248 | i0 | 52.2 | 2.82885906040268 | 92 | 43 | 91.6 | 1 | 295 | 23 | 134 | 225 | XP_022085354.1 calcyclin-binding protein-like [Acanthaster planci] | diamond | 843 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31033544 | 31033544 | PRJNA793147_P_NODE_13155_length_472_cov_1.387097_g12889_i0 | PRJNA793147 | 13155 | 472 | 1.387097 | 6.54709784 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 134 | 2.41e-33 | NR | XP_003726783.2 | 7668 | g12889 | i0 | 42.1 | 2.9364406779661 | 152 | 74 | 92.8 | 3 | 33 | 470 | 147 | 290 | XP_003726783.2 cubilin [Strongylocentrotus purpuratus] | diamond | 1386 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32212751 | 32212751 | PRJNA793147_P_NODE_5278_length_796_cov_5.294360_g5051_i0 | PRJNA793147 | 5278 | 796 | 5.29436 | 42.1431056 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 63.5 | 2.83e-7 | NR | XP_063968845.1 | 7653 | g5051 | i0 | 24.1 | 1.03266331658291 | 170 | 100 | 55 | 4 | 169 | 606 | 1390 | 1554 | XP_063968845.1 uncharacterized protein LOC129281952 isoform X5 [Lytechinus pictus] | diamond | 822 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 32235461 | 32235461 | PRJNA793147_P_NODE_52398_length_234_cov_0.872727_g52132_i0 | PRJNA793147 | 52398 | 234 | 0.872727 | 2.04218118 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 72 | 1.67e-12 | NR | XP_022099353.1 | 133434 | g52132 | i0 | 42.1 | 0.974358974358974 | 76 | 43 | 97.4 | 1 | 4 | 231 | 668 | 742 | XP_022099353.1 peregrin-like isoform X3 [Acanthaster planci] | diamond | 228 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;