RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA930380 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
26651836 26651836 PRJNA930380_P_NODE_7021_length_287_cov_1.121495_g6968_i0 PRJNA930380 7021 287 1.121495 3.21869065 Metazoa 33208 Echinodermata other_Eukaryota 45.1 0.00893   NR XP_071476149.1 105358 g6968 i0 40.5 2.45644599303136 42 25 43.9 0 3 128 197 238 XP_071476149.1 uncharacterized protein [Diadema antillarum] diamond 705 45.4 0.993392070484582 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
26739614 26739614 PRJNA930380_P_NODE_5641_length_293_cov_1.400000_g5588_i0 PRJNA930380 5641 293 1.4 4.102 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 50.4 1.35e-4   NR KAJ8049923.1 206669 g5588 i0 34.7 0.972696245733788 95 36 97.3 2 289 5 524 592 KAJ8049923.1 hypothetical protein HOLleu_02889 [Holothuria leucospilota] diamond 285 50.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
28130549 28130549 PRJNA930380_P_NODE_5745_length_292_cov_2.506849_g5692_i0 PRJNA930380 5745 292 2.506849 7.31999908 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 45.4 0.00724   NR PIK41221.1 307972 g5692 i0 35.2 2.18835616438356 71 46 72.9 0 220 8 42 112 PIK41221.1 reverse transcriptase-like protein [Apostichopus japonicus] diamond 639 45.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
28130551 28130551 PRJNA930380_P_NODE_7005_length_287_cov_1.266355_g6952_i0 PRJNA930380 7005 287 1.266355 3.63443885 Lytechinus pictus 7653 Echinodermata other_Eukaryota 43.5 0.0314   NR XP_063962141.1 7653 g6952 i0 47.2 0.376306620209059 36 19 37.6 0 173 280 196 231 XP_063962141.1 uncharacterized protein LOC135155811 [Lytechinus pictus] diamond 108 43.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
28256542 28256542 PRJNA930380_P_NODE_10306_length_268_cov_1.420513_g10253_i0 PRJNA930380 10306 268 1.420513 3.80697484 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 65.5 5.01e-10   NR XP_030831942.1 7668 g10253 i0 60.8 2.28358208955224 51 20 57.1 0 266 114 562 612 XP_030831942.1 uncharacterized protein K02A2.6-like [Strongylocentrotus purpuratus] diamond 612 65.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
29235604 29235604 PRJNA930380_P_NODE_9589_length_273_cov_2.570000_g9536_i0 PRJNA930380 9589 273 2.57 7.0161 Diadema antillarum 105358 Echinodermata other_Eukaryota 61.6 1.21e-8   NR XP_071479491.1 105358 g9536 i0 45.1 0.901098901098901 82 45 90.1 0 27 272 678 759 XP_071479491.1 uncharacterized protein [Diadema antillarum] diamond 246 61.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
29740435 29740435 PRJNA930380_P_NODE_9170_length_276_cov_1.517241_g9117_i0 PRJNA930380 9170 276 1.517241 4.18758516 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 56.6 7.34e-7   NR XP_030848373.1 7668 g9117 i0 49.1 1.90217391304348 55 28 59.8 0 81 245 685 739 XP_030848373.1 uncharacterized protein LOC592250 [Strongylocentrotus purpuratus] diamond 525 56.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
29772093 29772093 PRJNA930380_P_NODE_7351_length_285_cov_1.943396_g7298_i0 PRJNA930380 7351 285 1.943396 5.5386786 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 55.1 2.86e-6   NR XP_030848373.1 7668 g7298 i0 58.8 4.90526315789474 51 20 53.7 1 132 284 677 726 XP_030848373.1 uncharacterized protein LOC592250 [Strongylocentrotus purpuratus] diamond 1398 55.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
29930364 29930364 PRJNA930380_P_NODE_9451_length_274_cov_1.970149_g9398_i0 PRJNA930380 9451 274 1.970149 5.39820826 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 68.2 4.43e-11   NR KAJ8034091.1 206669 g9398 i0 49.3 4.2043795620438 75 38 82.1 0 37 261 70 144 KAJ8034091.1 hypothetical protein HOLleu_24517 [Holothuria leucospilota] diamond 1152 68.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
29961781 29961781 PRJNA930380_P_NODE_7691_length_284_cov_1.246445_g7638_i0 PRJNA930380 7691 284 1.246445 3.5399038 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 51.2 6.38e-5   NR KAJ8039461.1 206669 g7638 i0 34.8 2.58802816901408 69 45 72.9 0 283 77 327 395 KAJ8039461.1 hypothetical protein HOLleu_17189 [Holothuria leucospilota] diamond 735 51.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
30530387 30530387 PRJNA930380_P_NODE_6013_length_291_cov_1.876147_g5960_i0 PRJNA930380 6013 291 1.876147 5.45958777 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 75.1 2.76e-14   NR PIK44744.1 307972 g5960 i0 56.1 1.36082474226804 66 29 68 0 3 200 31 96 PIK44744.1 hypothetical protein BSL78_18416 [Apostichopus japonicus] diamond 396 75.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
30751732 30751732 PRJNA930380_P_NODE_5454_length_294_cov_1.484163_g5401_i0 PRJNA930380 5454 294 1.484163 4.36343922 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 74.3 5.35e-13   NR XP_041483986.1 7654 g5401 i0 37 1.02040816326531 100 60 99 1 3 293 211 310 XP_041483986.1 uncharacterized protein LOC121430697 [Lytechinus variegatus] diamond 300 74.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
30846463 30846463 PRJNA930380_P_NODE_6154_length_290_cov_2.838710_g6101_i0 PRJNA930380 6154 290 2.83871 8.232259 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 60.8 1.63e-8   NR PIK42871.1 307972 g6101 i0 54.9 2.65862068965517 51 23 52.8 0 288 136 185 235 PIK42871.1 putative neutral ceramidase C [Apostichopus japonicus] diamond 771 60.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
31257202 31257202 PRJNA930380_P_NODE_6615_length_288_cov_3.725581_g6562_i0 PRJNA930380 6615 288 3.725581 10.72967328 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 56.2 4.86e-7   NR XP_030834536.1 7668 g6562 i0 45.6 1.77083333333333 57 31 59.4 0 12 182 145 201 XP_030834536.1 uncharacterized protein LOC115921318 [Strongylocentrotus purpuratus] diamond 510 56.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
31833438 31833438 PRJNA930380_P_NODE_5557_length_293_cov_2.500000_g5504_i0 PRJNA930380 5557 293 2.5 7.325 Metazoa 33208 Echinodermata other_Eukaryota 80.9 5.92e-17   NR XP_063962059.1 7653 g5504 i0 52.7 1.41296928327645 74 35 75.8 0 3 224 39 112 XP_063962059.1 uncharacterized protein LOC135155767 [Lytechinus pictus] diamond 414 80.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
31928501 31928501 PRJNA930380_P_NODE_9677_length_273_cov_1.395000_g9624_i0 PRJNA930380 9677 273 1.395 3.80835 Metazoa 33208 Echinodermata other_Eukaryota 43.1 0.0388   NR XP_003724061.1 7668 g9624 i0 35.5 1.95604395604396 62 36 63.7 1 98 271 596 657 XP_003724061.1 uncharacterized protein LOC763238 [Strongylocentrotus purpuratus] diamond 534 43.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
32238183 32238183 PRJNA930380_P_NODE_4158_length_319_cov_0.780488_g4105_i0 PRJNA930380 4158 319 0.780488 2.48975672 Patiria miniata 46514 Echinodermata other_Eukaryota 68.6 7.89e-11   NR XP_038049729.1 46514 g4105 i0 50.8 2.96238244514107 63 31 59.2 0 130 318 452 514 XP_038049729.1 uncharacterized protein LOC119723237 [Patiria miniata] diamond 945 68.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
32806221 32806221 PRJNA930380_P_NODE_9800_length_272_cov_1.547739_g9747_i0 PRJNA930380 9800 272 1.547739 4.20985008 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 50.1 4.23e-5   NR KAJ8021194.1 206669 g9747 i0 52.6 0.419117647058824 38 18 41.9 0 6 119 109 146 KAJ8021194.1 hypothetical protein HOLleu_38321 [Holothuria leucospilota] diamond 114 50.1 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);;