contig_metadata
18 rows where bioproject = "PRJNA274362", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2921304 | 2921304 | PRJNA274362_S_NODE_28143_length_178_cov_6.023256_g28023_i0 | PRJNA274362 | 28143 | 178 | 6.023256 | 10.72139568 | Apostichopus californicus | 2032702 | Echinodermata | other_Eukaryota | 316 | 4.8399999999999983e-82 | NTclustered | gi|110826348|gb|DQ777087.1| | 2032702 | g28023 | i0 | 98.876 | 26.3426966292135 | 178 | 1 | 100 | 1 | 1 | 178 | 313 | 137 | Parastichopus californicus voucher AMCC 113282 28S ribosomal RNA gene, partial sequence | blastn | 4689 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus californicus | |
| 5473930 | 5473930 | PRJNA274362_S_NODE_2365_length_528_cov_7.693111_g2248_i0 | PRJNA274362 | 2365 | 528 | 7.693111 | 40.61962608 | Psychropotes longicauda | 55639 | Echinodermata | other_Eukaryota | 130 | 2.33e-25 | NTclustered | gi|2370359|emb|Z80946.1| | 55639 | g2248 | i0 | 78.469 | 9.30681818181818 | 209 | 38 | 39 | 7 | 1 | 206 | 351 | 555 | P.longicauda partial 28S rRNA gene | blastn | 4914 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Elasipodida | Psychropotidae | Psychropotes | Psychropotes longicauda | |
| 6748436 | 6748436 | PRJNA274362_S_NODE_32506_length_168_cov_1.310924_g32386_i0 | PRJNA274362 | 32506 | 168 | 1.310924 | 2.20235232 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1826622945|ref|XR_004444679.1| | 1529436 | g32386 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 76 | 103 | 553 | 526 | PREDICTED: Anneissia japonica uncharacterized LOC117103909 (LOC117103909), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 6748586 | 6748586 | PRJNA274362_S_NODE_5846_length_348_cov_9.096990_g5726_i0 | PRJNA274362 | 5846 | 348 | 9.09699 | 31.6575252 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 638 | 1.99e-178 | NTclustered | gi|329790855|dbj|AB595140.1| | 307972 | g5726 | i0 | 99.713 | 97.1781609195402 | 348 | 1 | 100 | 0 | 1 | 348 | 365 | 18 | Apostichopus japonicus gene for 18S rRNA, partial sequence | blastn | 33818 | 638 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 7436520 | 7436520 | PRJNA274362_S_NODE_27126_length_181_cov_10.022727_g27006_i0 | PRJNA274362 | 27126 | 181 | 10.022727 | 18.14113587 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 213 | 6.66e-51 | NTclustered | gi|15208480|gb|AY026367.1| | 7641 | g27006 | i0 | 89.08 | 96.1602209944751 | 174 | 15 | 96 | 3 | 3 | 176 | 1811 | 1980 | Arbacia punctulata 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17405 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Arbacioida | Arbaciidae | Arbacia | Arbacia punctulata | |
| 8023918 | 8023918 | PRJNA274362_S_NODE_2347_length_530_cov_7.738046_g2230_i0 | PRJNA274362 | 2347 | 530 | 7.738046 | 41.0116438 | Diplodontias miliaris | 992819 | Echinodermata | other_Eukaryota | 368 | 4.55e-97 | NTclustered | gi|84043352|gb|DQ297130.1| | 992819 | g2230 | i0 | 80.074 | 23.0264150943396 | 542 | 70 | 100 | 32 | 1 | 530 | 533 | 18 | Asterodon miliaris 28S ribosomal RNA gene, partial sequence | blastn | 12204 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Odontasteridae | Diplodontias | Diplodontias miliaris | |
| 8711309 | 8711309 | PRJNA274362_S_NODE_37007_length_162_cov_9.070796_g36887_i0 | PRJNA274362 | 37007 | 162 | 9.070796 | 14.69468952 | Apostichopus | 307971 | Echinodermata | other_Eukaryota | 300 | 4.36e-77 | NTclustered | gi|329790855|dbj|AB595140.1| | 307972 | g36887 | i0 | 100 | 101.018518518519 | 162 | 0 | 100 | 0 | 1 | 162 | 1482 | 1643 | Apostichopus japonicus gene for 18S rRNA, partial sequence | blastn | 16365 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 11261826 | 11261826 | PRJNA274362_S_NODE_5229_length_365_cov_8.838608_g5109_i0 | PRJNA274362 | 5229 | 365 | 8.838608 | 32.2609192 | Apostichopus | 307971 | Echinodermata | other_Eukaryota | 675 | 0 | NTclustered | gi|329790855|dbj|AB595140.1| | 307972 | g5109 | i0 | 100 | 102.523287671233 | 365 | 0 | 100 | 0 | 1 | 365 | 982 | 618 | Apostichopus japonicus gene for 18S rRNA, partial sequence | blastn | 37421 | 675 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 13124381 | 13124381 | PRJNA274362_S_NODE_23031_length_194_cov_4.937931_g22911_i0 | PRJNA274362 | 23031 | 194 | 4.937931 | 9.57958614 | Pteraster pulvillus | 335715 | Echinodermata | other_Eukaryota | 167 | 5.7299999999999995e-37 | NTclustered | gi|82623462|gb|DQ273721.1| | 335715 | g22911 | i0 | 96.078 | 99.2371134020619 | 102 | 4 | 53 | 0 | 6 | 107 | 105 | 4 | Pteraster pulvillus isolate 2 28S ribosomal RNA gene, partial sequence | blastn | 19252 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Velatida | Pterasteridae | Pteraster | Pteraster pulvillus | |
| 13124723 | 13124723 | PRJNA274362_S_NODE_5891_length_347_cov_11.912752_g5771_i0 | PRJNA274362 | 5891 | 347 | 11.912752 | 41.33724944 | Cucumaria salma | 122241 | Echinodermata | other_Eukaryota | 233 | 1.09e-56 | NTclustered | gi|11494219|gb|AF212170.1|AF212170 | 122241 | g5771 | i0 | 79.614 | 34.7636887608069 | 363 | 45 | 100 | 24 | 1 | 347 | 3036 | 3385 | Cucumaria salma internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 12063 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Dendrochirotida | Cucumariidae | Cucumaria | Cucumaria salma | |
| 15673633 | 15673633 | PRJNA274362_S_NODE_773_length_838_cov_2.569075_g703_i0 | PRJNA274362 | 773 | 838 | 2.569075 | 21.5288485 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 236 | 5.81e-71 | NR | XP_022088858.1 | 133434 | g703 | i0 | 74 | 27.5727923627685 | 150 | 39 | 53.7 | 0 | 1 | 450 | 311 | 460 | XP_022088858.1 elongation factor 1-alpha [Acanthaster planci] | diamond | 23106 | 236 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 15673653 | 15673653 | PRJNA274362_S_NODE_8833_length_289_cov_7.900000_g8713_i0 | PRJNA274362 | 8833 | 289 | 7.9 | 22.831 | Holothuria sanctori | 491806 | Echinodermata | other_Eukaryota | 272 | 1.89e-68 | NTclustered | gi|1059433196|dbj|LC177083.1| | 491806 | g8713 | i0 | 84 | 65.1280276816609 | 300 | 31 | 99 | 13 | 1 | 288 | 1046 | 752 | Holothuria sanctori mitochondrial gene for 28S ribosomal RNA, partial sequence, isolate: Hsa-16S7 | blastn | 18822 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria sanctori | |
| 16947711 | 16947711 | PRJNA274362_S_NODE_12754_length_248_cov_3.743719_g12634_i0 | PRJNA274362 | 12754 | 248 | 3.743719 | 9.28442312 | Xyloplax janetae | 478272 | Echinodermata | other_Eukaryota | 189 | 1.6399999999999996e-43 | NTclustered | gi|87621801|gb|DQ380246.1| | 478272 | g12634 | i0 | 90.845 | 40.1209677419355 | 142 | 10 | 57 | 2 | 64 | 205 | 171 | 33 | Xyloplax janetae voucher FMNH 12460 28S ribosomal RNA gene, partial sequence | blastn | 9950 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Peripodida | Xyloplacidae | Xyloplax | Xyloplax janetae | |
| 24596870 | 24596870 | PRJNA274362_S_NODE_3340_length_450_cov_6.605985_g3220_i0 | PRJNA274362 | 3340 | 450 | 6.605985 | 29.7269325 | Linckia laevigata | 109185 | Echinodermata | other_Eukaryota | 171 | 1.15e-37 | NTclustered | gi|1806649380|dbj|LC505033.1| | 109185 | g3220 | i0 | 87.333 | 40.8311111111111 | 150 | 17 | 50 | 2 | 13 | 161 | 7079 | 7227 | Linckia laevigata NSMT:E-12913 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, external transcribed spacer region, partial and complete sequence | blastn | 18374 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Ophidiasteridae | Linckia | Linckia laevigata | |
| 26775454 | 26775454 | PRJNA274362_S_NODE_4961_length_374_cov_2.775385_g4841_i0 | PRJNA274362 | 4961 | 374 | 2.775385 | 10.3799399 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 149 | 9.24e-44 | NR | XP_033632396.1 | 7604 | g4841 | i0 | 67.3 | 13.2032085561497 | 113 | 37 | 90.6 | 0 | 343 | 5 | 5 | 117 | XP_033632396.1 60S ribosomal protein L31-like [Asterias rubens] | diamond | 4938 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27832108 | 27832108 | PRJNA274362_S_NODE_1784_length_599_cov_1.923636_g1676_i0 | PRJNA274362 | 1784 | 599 | 1.923636 | 11.52257964 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 103 | 1.1e-22 | NR | XP_033117238.1 | 1529436 | g1676 | i0 | 83.3 | 1.14190317195326 | 54 | 9 | 27 | 0 | 3 | 164 | 240 | 293 | XP_033117238.1 ADP/ATP translocase 1-like [Anneissia japonica] | diamond | 684 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29554685 | 29554685 | PRJNA274362_S_NODE_16290_length_224_cov_1.382857_g16170_i0 | PRJNA274362 | 16290 | 224 | 1.382857 | 3.09759968 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 93.6 | 1.46e-22 | NR | XP_033641585.1 | 7604 | g16170 | i0 | 69.4 | 5.31696428571429 | 72 | 22 | 96.4 | 0 | 2 | 217 | 50 | 121 | XP_033641585.1 40S ribosomal protein S25-like [Asterias rubens] | diamond | 1191 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32823716 | 32823716 | PRJNA274362_S_NODE_16440_length_223_cov_1.649425_g16320_i0 | PRJNA274362 | 16440 | 223 | 1.649425 | 3.67821775 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 115 | 3.52e-30 | NR | XP_033640423.1 | 7604 | g16320 | i0 | 75.7 | 1.99103139013453 | 74 | 18 | 99.6 | 0 | 223 | 2 | 56 | 129 | XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens] | diamond | 444 | 115 | 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);;