RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA492363" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA492363 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
25896960 25896960 PRJNA492363_S_NODE_11891_length_282_cov_2.606335_g11070_i0 PRJNA492363 11891 282 2.606335 7.3498647 Caerostris darwini 1538125 Arthropoda Arthropoda 68.6 5.96e-12   NR GIY80821.1 1538125 g11070 i0 43.4 0.882978723404255 83 39 88.3 2 29 277 14 88 GIY80821.1 astacin, partial [Caerostris darwini] diamond 249 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
32935135 32935135 PRJNA492363_S_NODE_101121_length_201_cov_0.914286_g100300_i0 PRJNA492363 101121 201 0.914286 1.83771486 Symsagittifera roscoffensis 84072 Xenacoelomorpha other_Eukaryota 44.7 0.00438   NR XP_063727405.1 84072 g100300 i0 54.1 0.552238805970149 37 17 55.2 0 38 148 51 87 XP_063727405.1 diaminopimelate decarboxylase-like [Symsagittifera roscoffensis] diamond 111 44.7 1 Eukaryota Opisthokonta Metazoa Xenacoelomorpha   Acoela Sagittiferidae Symsagittifera Symsagittifera roscoffensis
32935388 32935388 PRJNA492363_S_NODE_93489_length_205_cov_0.888889_g92668_i0 PRJNA492363 93489 205 0.888889 1.82222245 Rotaria sp. Silwood1 2762511 Rotifera other_Eukaryota 58.9 8.49e-10   NR CAF5187208.1 2762511 g92668 i0 63.6 0.64390243902439 44 16 64.4 0 189 58 1 44 CAF5187208.1 unnamed protein product, partial [Rotaria sp. Silwood1] diamond 132 58.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1
32952468 32952468 PRJNA492363_S_NODE_15178_length_258_cov_3.538071_g14357_i0 PRJNA492363 15178 258 3.538071 9.12822318 Staurois parvus 386267 Chordata Chordata 51.2 2.85e-5   NR CAI9550647.1 386267 g14357 i0 51.1 1.75581395348837 47 18 48.8 2 219 94 159 205 CAI9550647.1 unnamed protein product [Staurois parvus] diamond 453 51.2 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
32969725 32969725 PRJNA492363_S_NODE_75938_length_219_cov_1.215190_g75117_i0 PRJNA492363 75938 219 1.21519 2.6612661 Rotaria socialis 392032 Rotifera other_Eukaryota 89.4 1.72e-20   NR CAF3303912.1 392032 g75117 i0 81.1 0.726027397260274 53 10 72.6 0 218 60 111 163 CAF3303912.1 unnamed protein product [Rotaria socialis] diamond 159 89.4 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria socialis
32986561 32986561 PRJNA492363_S_NODE_12395_length_278_cov_1.405530_g11574_i0 PRJNA492363 12395 278 1.40553 3.9073734 Rotaria socialis 392032 Rotifera other_Eukaryota 62.8 2.68e-10   NR CAF4737870.1 392032 g11574 i0 54.8 1.65107913669065 62 27 65.8 1 277 95 9 70 CAF4737870.1 unnamed protein product [Rotaria socialis] diamond 459 62.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria socialis
32986634 32986634 PRJNA492363_S_NODE_41699_length_236_cov_1.828571_g40878_i0 PRJNA492363 41699 236 1.828571 4.31542756 Dysidea avara 196820 Porifera other_Eukaryota 46.2 0.00203   NR XP_065892229.1 196820 g40878 i0 42 0.635593220338983 50 24 63.6 3 188 39 560 604 XP_065892229.1 uncharacterized protein [Dysidea avara] diamond 150 46.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
33020656 33020656 PRJNA492363_S_NODE_5172_length_394_cov_24945.807808_g4351_i0 PRJNA492363 5172 394 24945.807808 98286.48276352 Erpetoichthys calabaricus 27687 Chordata Chordata 134 3.6599999999999995e-35   NR XP_051791274.1 27687 g4351 i0 77.8 5.56598984771574 90 19 67.8 1 357 91 115 204 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 2193 134 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
33026804 33026804 PRJNA492363_S_NODE_101132_length_201_cov_0.914286_g100311_i0 PRJNA492363 101132 201 0.914286 1.83771486 Rotaria 231623 Rotifera other_Eukaryota 62.8 1.86e-9   NR CAF1934941.1 392030 g100311 i0 42.5 6.95522388059702 80 33 100 2 1 201 291 370 CAF1934941.1 unnamed protein product [Rotaria magnacalcarata] diamond 1398 62.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata
33037884 33037884 PRJNA492363_S_NODE_95268_length_204_cov_0.895105_g94447_i0 PRJNA492363 95268 204 0.895105 1.8260142 Schistocerca gregaria 7010 Arthropoda Arthropoda 89.7 6.21e-19   NR XP_049848600.1 7010 g94447 i0 75.9 3.91176470588235 54 13 79.4 0 163 2 183 236 XP_049848600.1 116 kDa U5 small nuclear ribonucleoprotein component-like [Schistocerca gregaria] diamond 798 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
33054935 33054935 PRJNA492363_S_NODE_98821_length_202_cov_1.361702_g98000_i0 PRJNA492363 98821 202 1.361702 2.75063804 Nothoprocta perdicaria 30464 Chordata Chordata 43.9 0.00859   NR XP_025900849.1 30464 g98000 i0 48.1 0.772277227722772 52 22 69.8 2 44 184 26 77 XP_025900849.1 aladin [Nothoprocta perdicaria] diamond 156 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Aves Tinamiformes Tinamidae Nothoprocta Nothoprocta perdicaria
33122956 33122956 PRJNA492363_S_NODE_12775_length_275_cov_1.700935_g11954_i0 PRJNA492363 12775 275 1.700935 4.67757125 Vidua macroura 187451 Chordata Chordata 43.1 0.0409   NR XP_053841688.1 187451 g11954 i0 43.8 0.523636363636364 48 24 52.4 1 76 219 761 805 XP_053841688.1 protein transport protein Sec16B isoform X2 [Vidua macroura] diamond 144 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Aves Passeriformes Estrildidae Vidua Vidua macroura
33129186 33129186 PRJNA492363_S_NODE_95015_length_204_cov_1.342657_g94194_i0 PRJNA492363 95015 204 1.342657 2.73902028 Scleractinia 6125 Cnidaria other_Eukaryota 45.1 0.00344   NR XP_029182189.2 45264 g94194 i0 36.7 2.69117647058824 60 38 88.2 0 194 15 324 383 XP_029182189.2 LOW QUALITY PROTEIN: uncharacterized protein LOC114950098 [Acropora millepora] diamond 549 45.4 0.993392070484582 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora

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