RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631796 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
13357553 13357553 PRJNA631796_P_NODE_12431_length_203_cov_3.408451_g12153_i0 PRJNA631796 12431 203 3.408451 6.91915553 Daphnia magna 35525 Arthropoda Arthropoda 68.2 5.6e-12   NR KAK4045862.1 35525 g12153 i0 68.1 0.694581280788177 47 15 69.5 0 1 141 10 56 KAK4045862.1 hypothetical protein OUZ56_033925 [Daphnia magna] diamond 141 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
15906209 15906209 PRJNA631796_P_NODE_13213_length_201_cov_0.914286_g12935_i0 PRJNA631796 13213 201 0.914286 1.83771486 Schistocerca gregaria 7010 Arthropoda Arthropoda 124 2.4499999999999997e-31   NR XP_049850436.1 7010 g12935 i0 80.6 1 67 13 100 0 1 201 120 186 XP_049850436.1 uncharacterized protein LOC126322605 [Schistocerca gregaria] diamond 201 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
26998374 26998374 PRJNA631796_P_NODE_13002_length_201_cov_2.978571_g12724_i0 PRJNA631796 13002 201 2.978571 5.98692771 Psychodidae 7197 Arthropoda Arthropoda 73.2 4.15e-13   NR XP_055679138.1 7200 g12724 i0 62.7 1.76119402985075 59 20 88.1 1 201 25 1451 1507 XP_055679138.1 microtubule-associated serine/threonine-protein kinase 3 isoform X2 [Lutzomyia longipalpis] diamond 354 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
27030162 27030162 PRJNA631796_P_NODE_6582_length_267_cov_0.752427_g6304_i0 PRJNA631796 6582 267 0.752427 2.00898009 root 1 Root_unresolved Root_unresolved 42.7 0.0479   NR XP_039277498.1 108931 g6304 i0 33.9 1.49438202247191 56 36 61.8 1 241 77 313 368 XP_039277498.1 uncharacterized protein LOC120349956 [Nilaparvata lugens] diamond 399 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
27807670 27807670 PRJNA631796_P_NODE_7764_length_243_cov_2.637363_g7486_i0 PRJNA631796 7764 243 2.637363 6.40879209 Lasius niger 67767 Arthropoda Arthropoda 43.9 0.013   NR KMQ86303.1 67767 g7486 i0 44.7 1.38271604938272 38 21 46.9 0 3 116 208 245 KMQ86303.1 copia protein [Lasius niger] diamond 336 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
28849189 28849189 PRJNA631796_P_NODE_12268_length_204_cov_1.342657_g11990_i0 PRJNA631796 12268 204 1.342657 2.73902028 Schistocerca gregaria 7010 Arthropoda Arthropoda 82 3.07e-16   NR XP_049850682.1 7010 g11990 i0 65.7 0.985294117647059 67 22 98.5 1 203 3 385 450 XP_049850682.1 fimbrin-like [Schistocerca gregaria] diamond 201 82 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28944424 28944424 PRJNA631796_P_NODE_13888_length_190_cov_2.294574_g13610_i0 PRJNA631796 13888 190 2.294574 4.3596906 Lamprigera yunnana 370605 Arthropoda Arthropoda 41.6 0.0478   NR KAF5270296.1 370605 g13610 i0 36.7 0.947368421052632 60 38 94.7 0 180 1 348 407 KAF5270296.1 hypothetical protein FQA39_LY08407 [Lamprigera yunnana] diamond 180 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Lamprigera Lamprigera yunnana
29354690 29354690 PRJNA631796_P_NODE_5849_length_285_cov_1.723214_g5571_i0 PRJNA631796 5849 285 1.723214 4.9111599 Schistocerca gregaria 7010 Arthropoda Arthropoda 162 2.46e-48   NR XP_049850590.1 7010 g5571 i0 76.3 3 97 21 100 1 285 1 67 163 XP_049850590.1 superoxide dismutase [Fe]-like [Schistocerca gregaria] diamond 855 162 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29891522 29891522 PRJNA631796_P_NODE_12671_length_203_cov_0.901408_g12393_i0 PRJNA631796 12671 203 0.901408 1.82985824 Phthorimaea operculella 192464 Arthropoda Arthropoda 55.8 3.3e-7   NR KAI5634807.1 192464 g12393 i0 45.8 0.87192118226601 59 31 87.2 1 177 1 38 95 KAI5634807.1 protein tyrosine phosphatase-like protein, PTPLA domain-containing protein [Phthorimaea operculella] diamond 177 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Phthorimaea Phthorimaea operculella
29998818 29998818 PRJNA631796_P_NODE_11251_length_208_cov_1.285714_g10973_i0 PRJNA631796 11251 208 1.285714 2.67428512 Culicidae 7157 Arthropoda Arthropoda 132 2.2099999999999993e-34   NR XP_029734490.1 7160 g10973 i0 81.2 14.9278846153846 69 13 99.5 0 2 208 96 164 XP_029734490.1 peroxisomal N(1)-acetyl-spermine/spermidine oxidase [Aedes albopictus] diamond 3105 133 0.992481203007519 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
30397339 30397339 PRJNA631796_P_NODE_7693_length_244_cov_8.409836_g7415_i0 PRJNA631796 7693 244 8.409836 20.51999984 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 42.7 0.0111   NR CAL4131877.1 48144 g7415 i0 51.4 1.26639344262295 37 11 36.9 1 152 241 74 110 CAL4131877.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 309 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
32009183 32009183 PRJNA631796_P_NODE_13238_length_201_cov_0.914286_g12960_i0 PRJNA631796 13238 201 0.914286 1.83771486 Condylostylus longicornis 2530218 Arthropoda Arthropoda 87.8 2.61e-18   NR XP_055389035.1 2530218 g12960 i0 61.5 4.80597014925373 65 25 97 0 200 6 382 446 XP_055389035.1 NADP-dependent malic enzyme-like [Condylostylus longicornis] diamond 966 87.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
32325931 32325931 PRJNA631796_S_NODE_48739_length_232_cov_1.497076_g48572_i0 PRJNA631796 48739 232 1.497076 3.47321632 Lamprigera yunnana 370605 Arthropoda Arthropoda 42.7 0.0308   NR KAF5270296.1 370605 g48572 i0 36.7 0.775862068965517 60 38 77.6 0 218 39 348 407 KAF5270296.1 hypothetical protein FQA39_LY08407 [Lamprigera yunnana] diamond 180 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Lamprigera Lamprigera yunnana
32704434 32704434 PRJNA631796_S_NODE_75660_length_213_cov_7.796053_g75493_i0 PRJNA631796 75660 213 7.796053 16.60559289 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00981   NR CAK9813121.1 597819 g75493 i0 48.6 2.46478873239437 35 18 49.3 0 58 162 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata

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