RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA515078", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 20 ✖

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA515078 · 20 ✖
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
6214404 6214404 PRJNA515078_P_NODE_16365_length_215_cov_10.629213_g16132_i0 PRJNA515078 16365 215 10.629213 22.85280795 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 176 1.08e-39   NTclustered gi|2037992749|ref|XM_041609273.1| 7654 g16132 i0 86.709 102.651162790698 158 21 73 0 35 192 2208 2365 PREDICTED: Lytechinus variegatus polyubiquitin-C-like (LOC121415894), mRNA blastn 22070 176 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
19612839 19612839 PRJNA515078_P_NODE_17136_length_211_cov_0.896552_g16903_i0 PRJNA515078 17136 211 0.896552 1.89172472 Lytechinus pictus 7653 Echinodermata other_Eukaryota 71.3 5.12e-8   NTclustered gi|2707418199|ref|XM_054900116.2| 7653 g16903 i0 83.117 0.5260663507109 77 13 36 0 8 84 361 437 PREDICTED: Lytechinus pictus arylsulfatase-like (LOC129262077), mRNA blastn 111 71.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
19612975 19612975 PRJNA515078_P_NODE_3916_length_489_cov_2.042035_g3684_i0 PRJNA515078 3916 489 2.042035 9.98555115 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 223 9.68e-71   NR XP_038051326.1 46514 g3684 i0 70.4 16.5950920245399 142 42 87.1 0 1 426 104 245 XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] diamond 8115 225 0.991111111111111 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
22787984 22787984 PRJNA515078_P_NODE_18658_length_201_cov_1.286585_g18425_i0 PRJNA515078 18658 201 1.286585 2.58603585 Metazoa 33208 Echinodermata other_Eukaryota 61.2 5.2e-10   NR XP_022088887.1 133434 g18425 i0 68.6 1.53731343283582 35 11 52.2 0 199 95 88 122 XP_022088887.1 lipopolysaccharide-induced tumor necrosis factor-alpha factor homolog [Acanthaster planci] diamond 309 61.6 0.993506493506494 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
24712902 24712902 PRJNA515078_P_NODE_21420_length_187_cov_2.086667_g21187_i0 PRJNA515078 21420 187 2.086667 3.90206729 Acanthaster planci 133434 Echinodermata other_Eukaryota 56.5 0.001   NTclustered gi|1229183801|ref|XM_022249885.1| 133434 g21187 i0 100 0.481283422459893 30 0 16 0 158 187 1500 1529 PREDICTED: Acanthaster planci protein starmaker-like (LOC110987288), transcript variant X1, mRNA blastn 90 56.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
26744002 26744002 PRJNA515078_P_NODE_5221_length_415_cov_24.164021_g4988_i0 PRJNA515078 5221 415 24.164021 100.28068715 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 125 2.55e-34   NR XP_022087362.1 133434 g4988 i0 65.5 5.06746987951807 87 30 62.9 0 27 287 3 89 XP_022087362.1 probable 60S ribosomal protein L37-A isoform X2 [Acanthaster planci] diamond 2103 126 0.992063492063492 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
27330169 27330169 PRJNA515078_P_NODE_22083_length_184_cov_2.387755_g21850_i0 PRJNA515078 22083 184 2.387755 4.3934692 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 47.4 3.72e-4   NR PIK40980.1 307972 g21850 i0 61.8 3.21195652173913 34 13 55.4 0 3 104 269 302 PIK40980.1 cell division cycle 2 [Apostichopus japonicus] diamond 591 47.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
27534962 27534962 PRJNA515078_P_NODE_12223_length_254_cov_2.336406_g11990_i0 PRJNA515078 12223 254 2.336406 5.93447124 Metazoa 33208 Echinodermata other_Eukaryota 108 5.81e-27   NR XP_033635647.1 7604 g11990 i0 60.8 8.58661417322835 79 31 93.3 0 2 238 176 254 XP_033635647.1 40S ribosomal protein S4, X isoform-like isoform X2 [Asterias rubens] diamond 2181 108 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
28008726 28008726 PRJNA515078_P_NODE_19505_length_196_cov_2.943396_g19272_i0 PRJNA515078 19505 196 2.943396 5.76905616 root 1 Root_unresolved Root_unresolved 50.1 5.25e-5   NR XP_022094228.1 133434 g19272 i0 76.9 5.3265306122449 26 6 39.8 0 2 79 516 541 XP_022094228.1 alpha-aminoadipic semialdehyde dehydrogenase-like [Acanthaster planci] diamond 1044 50.4 0.994047619047619 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
28561623 28561623 PRJNA515078_P_NODE_21947_length_185_cov_1.317568_g21714_i0 PRJNA515078 21947 185 1.317568 2.4375008 Patiria miniata 46514 Echinodermata other_Eukaryota 110 5.889999999999999e-28   NR XP_038051326.1 46514 g21714 i0 76.7 19.4594594594595 60 14 97.3 0 184 5 171 230 XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] diamond 3600 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
28688039 28688039 PRJNA515078_P_NODE_31887_length_155_cov_1.838983_g31654_i0 PRJNA515078 31887 155 1.838983 2.85042365 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 42.7 0.0102   NR KAJ8023994.1 206669 g31654 i0 50 0.696774193548387 36 18 69.7 0 47 154 2 37 KAJ8023994.1 Glutathione S-transferase theta-1 [Holothuria leucospilota] diamond 108 42.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
29176969 29176969 PRJNA515078_P_NODE_14909_length_227_cov_1.847368_g14676_i0 PRJNA515078 14909 227 1.847368 4.19352536 Metazoa 33208 Echinodermata other_Eukaryota 97.8 1.28e-21   NR XP_030834372.1 7668 g14676 i0 54.1 5.84140969162996 74 34 97.8 0 226 5 4219 4292 XP_030834372.1 uncharacterized protein LOC764665 [Strongylocentrotus purpuratus] diamond 1326 97.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
30456713 30456713 PRJNA515078_P_NODE_9113_length_302_cov_1.735849_g8880_i0 PRJNA515078 9113 302 1.735849 5.24226398 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 80.1 5.86e-15   NR PIK41094.1 307972 g8880 i0 47.1 1.01324503311258 102 44 99.3 3 1 300 1927 2020 PIK41094.1 putative fibrocystin-L, partial [Apostichopus japonicus] diamond 306 80.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
30551006 30551006 PRJNA515078_P_NODE_8313_length_318_cov_1.274021_g8080_i0 PRJNA515078 8313 318 1.274021 4.05138678 Anneissia japonica 1529436 Echinodermata other_Eukaryota 88.2 1.09e-18   NR XP_033110696.1 1529436 g8080 i0 42.6 14.8584905660377 101 54 95.3 1 317 15 97 193 XP_033110696.1 gamma-interferon-inducible lysosomal thiol reductase-like [Anneissia japonica] diamond 4725 88.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
30835451 30835451 PRJNA515078_P_NODE_32374_length_154_cov_1.965812_g32141_i0 PRJNA515078 32374 154 1.965812 3.02735048 Patiria miniata 46514 Echinodermata other_Eukaryota 93.6 1.38e-20   NR XP_038049857.1 46514 g32141 i0 72.5 3.97402597402597 51 14 99.4 0 1 153 178 228 XP_038049857.1 intraflagellar transport protein 80 homolog isoform X1 [Patiria miniata] diamond 612 93.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
30945788 30945788 PRJNA515078_P_NODE_33714_length_152_cov_1.017391_g33481_i0 PRJNA515078 33714 152 1.017391 1.54643432 Echinoidea 7625 Echinodermata other_Eukaryota 65.9 7.44e-11   NR XP_041466381.1 7654 g33481 i0 58 2.84210526315789 50 21 98.7 0 1 150 173 222 XP_041466381.1 inositol-3-phosphate synthase 1-A-like [Lytechinus variegatus] diamond 432 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
31229827 31229827 PRJNA515078_P_NODE_20195_length_193_cov_1.500000_g19962_i0 PRJNA515078 20195 193 1.5 2.895 Metazoa 33208 Echinodermata other_Eukaryota 59.7 2.03e-8   NR XP_071504792.1 105358 g19962 i0 44.4 11.8911917098446 45 25 69.9 0 138 4 31 75 XP_071504792.1 major vault protein [Diadema antillarum] diamond 2295 59.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
31246240 31246240 PRJNA515078_P_NODE_19655_length_196_cov_1.220126_g19422_i0 PRJNA515078 19655 196 1.220126 2.39144696 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 47.4 3.29e-4   NR XP_041474395.1 7654 g19422 i0 45.3 0.811224489795918 53 24 73.5 1 49 192 6 58 XP_041474395.1 apolipoprotein D-like [Lytechinus variegatus] diamond 159 47.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
32432271 32432271 PRJNA515078_P_NODE_17899_length_206_cov_1.295858_g17666_i0 PRJNA515078 17899 206 1.295858 2.66946748 Metazoa 33208 Echinodermata other_Eukaryota 109 4.12e-27   NR XP_033638822.1 7604 g17666 i0 69.1 3.96116504854369 68 21 99 0 206 3 118 185 XP_033638822.1 opioid growth factor receptor-like protein 1 [Asterias rubens] diamond 816 110 0.990909090909091 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
32432278 32432278 PRJNA515078_P_NODE_6099_length_381_cov_5.116279_g5866_i0 PRJNA515078 6099 381 5.116279 19.49302299 root 1 Root_unresolved Root_unresolved 82 1.15e-15   NR KAJ8043311.1 206669 g5866 i0 43.3 7.85826771653543 90 51 70.9 0 270 1 33 122 KAJ8043311.1 Glutathione S-transferase theta-1 [Holothuria leucospilota] diamond 2994 82 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;