contig_metadata
21 rows where bioproject = "PRJNA270367", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1644656 | 1644656 | PRJNA270367_P_NODE_10122_length_418_cov_2.271003_g9920_i0 | PRJNA270367 | 10122 | 418 | 2.271003 | 9.49279254 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 132 | 5.02e-26 | NTclustered | gi|1229163567|ref|XM_022239112.1| | 133434 | g9920 | i0 | 77.477 | 2.90430622009569 | 222 | 48 | 53 | 2 | 6 | 226 | 218 | 438 | PREDICTED: Acanthaster planci 60S ribosomal protein L24-like (LOC110981500), mRNA | blastn | 1214 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 11848651 | 11848651 | PRJNA270367_P_NODE_27490_length_216_cov_1.089820_g27285_i0 | PRJNA270367 | 27490 | 216 | 1.08982 | 2.3540112 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 136 | 2.4e-35 | NR | XP_033638583.1 | 7604 | g27285 | i0 | 90.1 | 26.625 | 71 | 7 | 98.6 | 0 | 2 | 214 | 759 | 829 | XP_033638583.1 DNA-directed RNA polymerase III subunit RPC2-like isoform X2 [Asterias rubens] | diamond | 5751 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 11848913 | 11848913 | PRJNA270367_P_NODE_9910_length_423_cov_2.040107_g9708_i0 | PRJNA270367 | 9910 | 423 | 2.040107 | 8.62965261 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 171 | 1.29e-51 | NR | XP_033110415.1 | 1529436 | g9708 | i0 | 62.6 | 2.95744680851064 | 139 | 23 | 98.6 | 1 | 419 | 3 | 1 | 110 | XP_033110415.1 40S ribosomal protein S18 [Anneissia japonica] | diamond | 1251 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 14399034 | 14399034 | PRJNA270367_P_NODE_27472_length_216_cov_1.245509_g27267_i0 | PRJNA270367 | 27472 | 216 | 1.245509 | 2.69029944 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 196 | 8.319999999999999e-46 | NTclustered | gi|1229177987|ref|XM_022246756.1| | 133434 | g27267 | i0 | 83.981 | 94.9953703703704 | 206 | 31 | 95 | 2 | 8 | 212 | 630 | 426 | PREDICTED: Acanthaster planci 40S ribosomal protein SA-like (LOC110985616), transcript variant X2, mRNA | blastn | 20519 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 16947445 | 16947445 | PRJNA270367_P_NODE_33474_length_189_cov_2.228571_g33269_i0 | PRJNA270367 | 33474 | 189 | 2.228571 | 4.21199919 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 78.7 | 2.68e-10 | NTclustered | gi|1944906316|ref|XM_038209998.1| | 46514 | g33269 | i0 | 79.817 | 17.5767195767196 | 109 | 20 | 57 | 2 | 1 | 108 | 269 | 162 | PREDICTED: Patiria miniata 40S ribosomal protein S25-like (LOC119736015), mRNA | blastn | 3322 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 18221547 | 18221547 | PRJNA270367_P_NODE_13755_length_350_cov_2.000000_g13550_i0 | PRJNA270367 | 13755 | 350 | 2 | 7 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 267 | 1.08e-66 | NTclustered | gi|1229143321|ref|XM_022228209.1| | 133434 | g13550 | i0 | 81.905 | 94.1971428571429 | 315 | 57 | 91 | 0 | 34 | 348 | 522 | 208 | PREDICTED: Acanthaster planci calmodulin-like protein 12 (LOC110975611), mRNA | blastn | 32969 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 19496122 | 19496122 | PRJNA270367_P_NODE_44036_length_164_cov_1.808696_g43831_i0 | PRJNA270367 | 44036 | 164 | 1.808696 | 2.96626144 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 94.4 | 3.01e-22 | NR | KAJ8024202.1 | 206669 | g43831 | i0 | 76.5 | 1.92073170731707 | 51 | 12 | 93.3 | 0 | 2 | 154 | 66 | 116 | KAJ8024202.1 Cathepsin D [Holothuria leucospilota] | diamond | 315 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 22046730 | 22046730 | PRJNA270367_P_NODE_47178_length_158_cov_2.449541_g46973_i0 | PRJNA270367 | 47178 | 158 | 2.449541 | 3.87027478 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 1.07e-7 | NR | XP_041475624.1 | 7654 | g46973 | i0 | 83.9 | 4.82278481012658 | 31 | 5 | 58.9 | 0 | 156 | 64 | 414 | 444 | XP_041475624.1 glutaryl-CoA dehydrogenase, mitochondrial-like [Lytechinus variegatus] | diamond | 762 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27281534 | 27281534 | PRJNA270367_P_NODE_19803_length_272_cov_1.165919_g19598_i0 | PRJNA270367 | 19803 | 272 | 1.165919 | 3.17129968 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 2.18e-28 | NR | XP_038069403.1 | 46514 | g19598 | i0 | 59.8 | 1.91911764705882 | 87 | 34 | 94.9 | 1 | 261 | 4 | 74 | 160 | XP_038069403.1 aspartate aminotransferase, mitochondrial-like [Patiria miniata] | diamond | 522 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28639427 | 28639427 | PRJNA270367_P_NODE_33507_length_189_cov_1.857143_g33302_i0 | PRJNA270367 | 33507 | 189 | 1.857143 | 3.51000027 | root | 1 | Root_unresolved | Root_unresolved | 103 | 5.3199999999999996e-24 | NR | XP_041475517.1 | 7654 | g33302 | i0 | 69.4 | 9.84126984126984 | 62 | 19 | 98.4 | 0 | 2 | 187 | 183 | 244 | XP_041475517.1 delta(24)-sterol reductase-like [Lytechinus variegatus] | diamond | 1860 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28842364 | 28842364 | PRJNA270367_P_NODE_26268_length_222_cov_2.520231_g26063_i0 | PRJNA270367 | 26268 | 222 | 2.520231 | 5.59491282 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 48.1 | 1.95e-4 | NR | XP_030856108.1 | 7668 | g26063 | i0 | 39.7 | 1.56756756756757 | 58 | 35 | 78.4 | 0 | 174 | 1 | 77 | 134 | XP_030856108.1 coatomer subunit zeta-1-like isoform X2 [Strongylocentrotus purpuratus] | diamond | 348 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28891617 | 28891617 | PRJNA270367_P_NODE_40268_length_168_cov_1.310924_g40063_i0 | PRJNA270367 | 40268 | 168 | 1.310924 | 2.20235232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.2 | 3.69e-20 | NR | PIK39720.1 | 307972 | g40063 | i0 | 72.2 | 4.875 | 54 | 15 | 96.4 | 0 | 3 | 164 | 68 | 121 | PIK39720.1 putative ras-related C3 botulinum toxin substrate 1, partial [Apostichopus japonicus] | diamond | 819 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29586141 | 29586141 | PRJNA270367_P_NODE_3010_length_795_cov_9.868633_g2834_i0 | PRJNA270367 | 3010 | 795 | 9.868633 | 78.45563235 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 294 | 7.53e-97 | NR | XP_038051326.1 | 46514 | g2834 | i0 | 60.7 | 16.0075471698113 | 234 | 92 | 88.3 | 0 | 761 | 60 | 13 | 246 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 12726 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29933982 | 29933982 | PRJNA270367_P_NODE_14471_length_338_cov_0.948097_g14266_i0 | PRJNA270367 | 14471 | 338 | 0.948097 | 3.20456786 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.3 | 2.9e-16 | NR | KAJ8019636.1 | 206669 | g14266 | i0 | 44.8 | 2.92011834319527 | 105 | 54 | 89.6 | 2 | 8 | 310 | 574 | 678 | KAJ8019636.1 Villin-1 [Holothuria leucospilota] | diamond | 987 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30042402 | 30042402 | PRJNA270367_P_NODE_10531_length_409_cov_1.472222_g10329_i0 | PRJNA270367 | 10531 | 409 | 1.472222 | 6.02138798 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 61.2 | 7.87e-8 | NR | XP_033123395.1 | 1529436 | g10329 | i0 | 30.5 | 0.960880195599022 | 131 | 77 | 88.8 | 3 | 363 | 1 | 343 | 469 | XP_033123395.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 2-like isoform X1 [Anneissia japonica] | diamond | 393 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30439510 | 30439510 | PRJNA270367_P_NODE_6533_length_531_cov_1.174274_g6337_i0 | PRJNA270367 | 6533 | 531 | 1.174274 | 6.23539494 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 133 | 1.48e-33 | NR | XP_054765848.2 | 7653 | g6337 | i0 | 45.6 | 65.316384180791 | 149 | 54 | 70.1 | 2 | 374 | 3 | 36 | 182 | XP_054765848.2 serine/threonine-protein phosphatase 2A 55 kDa regulatory subunit B delta isoform-like [Lytechinus pictus] | diamond | 34683 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30534038 | 30534038 | PRJNA270367_P_NODE_34393_length_186_cov_1.138686_g34188_i0 | PRJNA270367 | 34393 | 186 | 1.138686 | 2.11795596 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 54.7 | 1.05e-6 | NR | XP_063955700.1 | 7653 | g34188 | i0 | 44.3 | 5.69354838709677 | 61 | 31 | 96.8 | 2 | 5 | 184 | 97 | 155 | XP_063955700.1 proprotein convertase subtilisin/kexin type 5-like [Lytechinus pictus] | diamond | 1059 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30863836 | 30863836 | PRJNA270367_P_NODE_31754_length_196_cov_1.414966_g31549_i0 | PRJNA270367 | 31754 | 196 | 1.414966 | 2.77333336 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 77 | 1.53e-15 | NR | XP_033630296.1 | 7604 | g31549 | i0 | 55.4 | 0.994897959183674 | 65 | 26 | 99.5 | 2 | 195 | 1 | 87 | 148 | XP_033630296.1 uncharacterized protein LOC117292375 [Asterias rubens] | diamond | 195 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32350536 | 32350536 | PRJNA270367_P_NODE_45059_length_163_cov_1.552632_g44854_i0 | PRJNA270367 | 45059 | 163 | 1.552632 | 2.53079016 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 70.5 | 8.63e-13 | NR | XP_033625152.1 | 7604 | g44854 | i0 | 56.6 | 0.975460122699387 | 53 | 23 | 97.5 | 0 | 1 | 159 | 67 | 119 | XP_033625152.1 proteasome subunit beta type-4-like [Asterias rubens] | diamond | 159 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32382022 | 32382022 | PRJNA270367_P_NODE_39679_length_169_cov_0.866667_g39474_i0 | PRJNA270367 | 39679 | 169 | 0.866667 | 1.46466723 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 87.4 | 2.5e-18 | NR | XP_022109192.1 | 133434 | g39474 | i0 | 64.3 | 1.98816568047337 | 56 | 20 | 99.4 | 0 | 2 | 169 | 586 | 641 | XP_022109192.1 piwi-like protein 1 [Acanthaster planci] | diamond | 336 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32746867 | 32746867 | PRJNA270367_P_NODE_45500_length_163_cov_0.912281_g45295_i0 | PRJNA270367 | 45500 | 163 | 0.912281 | 1.48701803 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 43.5 | 0.00409 | NR | KAJ8045514.1 | 206669 | g45295 | i0 | 50 | 1.63803680981595 | 42 | 21 | 77.3 | 0 | 3 | 128 | 115 | 156 | KAJ8045514.1 SAYSvFN domain-containing protein 1 [Holothuria leucospilota] | diamond | 267 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;