RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA657860" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 5

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA657860 · 20 ✖

analysis 1

  • diamond · 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
19752477 19752477 PRJNA657860_P_NODE_896_length_351_cov_1.187898_g840_i0 PRJNA657860 896 351 1.187898 4.16952198 Limulus polyphemus 6850 Arthropoda Arthropoda 200 7.54e-60   NR XP_022243606.1 6850 g840 i0 77.6 0.991452991452991 116 26 99.1 0 350 3 130 245 XP_022243606.1 aldehyde dehydrogenase, mitochondrial-like [Limulus polyphemus] diamond 348 200 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
24851702 24851702 PRJNA657860_P_NODE_2940_length_172_cov_1.148148_g2884_i0 PRJNA657860 2940 172 1.148148 1.97481456 Ditylenchus destructor 166010 Nematoda Nematoda 103 1.18e-27   NR KAI1722231.1 166010 g2884 i0 92.9 0.976744186046512 56 4 97.7 0 3 170 7 62 KAI1722231.1 ribosomal l38e protein family domain-containing protein [Ditylenchus destructor] diamond 168 103 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Anguinidae Ditylenchus Ditylenchus destructor
26954633 26954633 PRJNA657860_P_NODE_2862_length_175_cov_1.673913_g2806_i0 PRJNA657860 2862 175 1.673913 2.92934775 Octopus vulgaris 6645 Mollusca Mollusca 105 3.77e-28   NR CAI9724014.1 6645 g2806 i0 92.6 0.925714285714286 54 4 92.6 0 175 14 36 89 CAI9724014.1 c oxidase subunit 7A-related, mitochondrial [Octopus vulgaris] diamond 162 105 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
27207579 27207579 PRJNA657860_P_NODE_1662_length_246_cov_2.583732_g1606_i0 PRJNA657860 1662 246 2.583732 6.35598072 Steinernema carpocapsae 34508 Nematoda Nematoda 71.2 7.61e-13   NR TKR72964.1 34508 g1606 i0 55.6 0.658536585365854 54 23 64.6 1 183 25 5 58 TKR72964.1 hypothetical protein L596_020342 [Steinernema carpocapsae] diamond 162 71.2 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Steinernematidae Steinernema Steinernema carpocapsae
28060435 28060435 PRJNA657860_P_NODE_525_length_480_cov_1.821670_g469_i0 PRJNA657860 525 480 1.82167 8.744016 Palaemon carinicauda 392227 Arthropoda Arthropoda 138 5.02e-36   NR XP_068221602.1 392227 g469 i0 45.4 1.01875 163 78 100 6 480 1 184 338 XP_068221602.1 uncharacterized protein [Palaemon carinicauda] diamond 489 138 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
28167533 28167533 PRJNA657860_P_NODE_3625_length_154_cov_1.931624_g3569_i0 PRJNA657860 3625 154 1.931624 2.97470096 Octopus 6643 Mollusca Mollusca 62.8 9.09e-10   NR CAI9720287.1 6645 g3569 i0 68.1 1.83116883116883 47 15 91.6 0 6 146 717 763 CAI9720287.1 and LDL-receptor class A domain-containing 2-like [Octopus vulgaris] diamond 282 62.8 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
28313172 28313172 PRJNA657860_P_NODE_2726_length_180_cov_1.090909_g2670_i0 PRJNA657860 2726 180 1.090909 1.9636362 Octopus vulgaris 6645 Mollusca Mollusca 76.6 1.01e-16   NR CAI9726847.1 6645 g2670 i0 76.7 0.716666666666667 43 10 71.7 0 178 50 32 74 CAI9726847.1 Hypothetical predicted protein [Octopus vulgaris] diamond 129 76.6 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
28660492 28660492 PRJNA657860_P_NODE_3127_length_167_cov_0.884615_g3071_i0 PRJNA657860 3127 167 0.884615 1.47730705 Engystomops pustulosus 76066 Chordata Chordata 58.2 4.12e-8   NR KAG8566174.1 76066 g3071 i0 56.6 21.1437125748503 53 23 95.2 0 9 167 1 53 KAG8566174.1 hypothetical protein GDO81_013129 [Engystomops pustulosus] diamond 3531 58.2 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
28925057 28925057 PRJNA657860_P_NODE_2108_length_209_cov_1.534884_g2052_i0 PRJNA657860 2108 209 1.534884 3.20790756 Octopus 6643 Mollusca Mollusca 107 4.1e-25   NR CAI9720287.1 6645 g2052 i0 66.7 1.98086124401914 69 23 99 0 3 209 534 602 CAI9720287.1 and LDL-receptor class A domain-containing 2-like [Octopus vulgaris] diamond 414 107 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
29291844 29291844 PRJNA657860_P_NODE_2209_length_204_cov_0.868263_g2153_i0 PRJNA657860 2209 204 0.868263 1.77125652 Elephas maximus indicus 99487 Chordata Chordata 42.4 0.0285   NR XP_049736108.1 99487 g2153 i0 35.2 0.794117647058823 54 33 79.4 1 3 164 122 173 XP_049736108.1 synaptophysin-like protein 2 isoform X1 [Elephas maximus indicus] diamond 162 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Proboscidea Elephantidae Elephas Elephas maximus
29733656 29733656 PRJNA657860_P_NODE_1770_length_236_cov_1.311558_g1714_i0 PRJNA657860 1770 236 1.311558 3.09527688 Octopus vulgaris 6645 Mollusca Mollusca 55.5 4.76e-7   NR CAI9738413.1 6645 g1714 i0 96.2 0.330508474576271 26 1 33.1 0 234 157 168 193 CAI9738413.1 Hypothetical predicted protein [Octopus vulgaris] diamond 78 55.5 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
29892008 29892008 PRJNA657860_P_NODE_2751_length_179_cov_1.084507_g2695_i0 PRJNA657860 2751 179 1.084507 1.94126753 Octopus vulgaris 6645 Mollusca Mollusca 100 9.84e-23   NR CAI9743194.1 6645 g2695 i0 78.6 0.93854748603352 56 12 93.9 0 168 1 3223 3278 CAI9743194.1 apolipophorins-like [Octopus vulgaris] diamond 168 100 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
30112870 30112870 PRJNA657860_P_NODE_3732_length_152_cov_0.982609_g3676_i0 PRJNA657860 3732 152 0.982609 1.49356568 Patella vulgata 6465 Mollusca Mollusca 51.2 1.08e-5   NR XP_050390247.1 6465 g3676 i0 47.9 2.84210526315789 48 25 94.7 0 9 152 152 199 XP_050390247.1 cAMP-dependent protein kinase regulatory subunit isoform X2 [Patella vulgata] diamond 432 51.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
30586734 30586734 PRJNA657860_P_NODE_373_length_585_cov_2.257299_g320_i0 PRJNA657860 373 585 2.257299 13.20519915 Panonychus citri 50023 Arthropoda Arthropoda 76.6 2.4e-13   NR AFD36889.1 50023 g320 i0 36.6 0.728205128205128 142 54 70.3 3 583 173 104 214 AFD36889.1 glutathione S-transferase zeta [Panonychus citri] diamond 426 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
31281968 31281968 PRJNA657860_P_NODE_1275_length_292_cov_1.494118_g1219_i0 PRJNA657860 1275 292 1.494118 4.36282456 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 127 9.1e-32   NR XP_066925207.1 252671 g1219 i0 60.4 5.9486301369863 96 38 98.6 0 1 288 549 644 XP_066925207.1 uncharacterized protein [Clytia hemisphaerica] diamond 1737 128 0.9921875 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
31503640 31503640 PRJNA657860_P_NODE_2176_length_205_cov_3.023810_g2120_i0 PRJNA657860 2176 205 3.02381 6.1988105 Mytilus edulis 6550 Mollusca Mollusca 48.9 1.43e-4   NR CAG2187267.1 6550 g2120 i0 45.3 2.29756097560976 53 28 76.1 1 41 196 192 244 CAG2187267.1 unnamed protein product [Mytilus edulis] diamond 471 48.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
31946125 31946125 PRJNA657860_P_NODE_3617_length_154_cov_2.316239_g3561_i0 PRJNA657860 3617 154 2.316239 3.56700806 Octopus vulgaris 6645 Mollusca Mollusca 50.1 5.38e-6   NR CAI9736015.1 6645 g3561 i0 87.5 0.467532467532468 24 3 46.8 0 152 81 91 114 CAI9736015.1 Hypothetical predicted protein [Octopus vulgaris] diamond 72 50.1 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
32136275 32136275 PRJNA657860_P_NODE_798_length_371_cov_1.305389_g742_i0 PRJNA657860 798 371 1.305389 4.84299319 Octopus vulgaris 6645 Mollusca Mollusca 181 8.64e-53   NR CAI9737250.1 6645 g742 i0 94 2.42587601078167 100 4 79.2 2 76 369 1 100 CAI9737250.1 Hypothetical predicted protein [Octopus vulgaris] diamond 900 181 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
32326405 32326405 PRJNA657860_P_NODE_1339_length_281_cov_31.106557_g1283_i0 PRJNA657860 1339 281 31.106557 87.40942517 Octopus vulgaris 6645 Mollusca Mollusca 45.8 0.00145   NR CAI9738083.1 6645 g1283 i0 60 0.427046263345196 40 13 42.7 1 76 195 8 44 CAI9738083.1 Hypothetical predicted protein [Octopus vulgaris] diamond 120 45.8 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
32516112 32516112 PRJNA657860_P_NODE_2999_length_170_cov_1.225564_g2943_i0 PRJNA657860 2999 170 1.225564 2.0834588 Octopus sinensis 2607531 Mollusca Mollusca 84.3 3.04e-17   NR XP_036357711.1 2607531 g2943 i0 78.6 10.8705882352941 56 11 98.8 1 1 168 806 860 XP_036357711.1 titin isoform X5 [Octopus sinensis] diamond 1848 84.3 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus sinensis

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