RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA529924" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA529924 · 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
10707225 10707225 PRJNA529924_P_NODE_5009_length_151_cov_1.811475_g4835_i0 PRJNA529924 5009 151 1.811475 2.73532725 Insecta 50557 Arthropoda Arthropoda 87.8 1.17e-20   NR XP_047003603.1 7009 g4835 i0 81.6 36.9933774834437 49 9 97.4 0 149 3 29 77 XP_047003603.1 40S ribosomal protein S17 [Schistocerca americana] diamond 5586 88.6 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
26776365 26776365 PRJNA529924_P_NODE_4361_length_180_cov_1.430464_g4187_i0 PRJNA529924 4361 180 1.430464 2.5748352 Metazoa 33208 Arthropoda Arthropoda 47.8 2.66e-4   NR XP_065165187.1 877792 g4187 i0 52.1 2.36666666666667 48 23 80 0 29 172 150 197 XP_065165187.1 SERPINE1 mRNA-binding protein 1-like isoform X2 [Dalotia coriaria] diamond 426 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
27425458 27425458 PRJNA529924_P_NODE_1863_length_379_cov_2.494286_g1689_i0 PRJNA529924 1863 379 2.494286 9.45334394 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 62 5.19e-9   NR KAG4075002.1 1564500 g1689 i0 40.4 1.46437994722955 89 45 70.4 3 106 372 82 162 KAG4075002.1 hypothetical protein HA402_014581 [Bradysia odoriphaga] diamond 555 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
28008836 28008836 PRJNA529924_P_NODE_965_length_605_cov_2.520833_g815_i0 PRJNA529924 965 605 2.520833 15.25103965 Metazoa 33208 Arthropoda Arthropoda 134 2.8099999999999997e-32   NR TRY77400.1 6832 g815 i0 36.6 21.4066115702479 191 114 92.2 3 16 573 325 513 TRY77400.1 hypothetical protein TCAL_04028 [Tigriopus californicus] diamond 12951 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
28766353 28766353 PRJNA529924_P_NODE_3447_length_219_cov_1.831579_g3273_i0 PRJNA529924 3447 219 1.831579 4.01115801 Insecta 50557 Arthropoda Arthropoda 94.4 2.99e-23   NR XP_014250040.1 79782 g3273 i0 70.8 9.89041095890411 65 16 84.9 1 8 193 31 95 XP_014250040.1 protein transport protein Sec61 subunit beta-like [Cimex lectularius] diamond 2166 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
29208638 29208638 PRJNA529924_P_NODE_309_length_1130_cov_2.590372_g239_i0 PRJNA529924 309 1130 2.590372 29.2712036 Arthropoda 6656 Arthropoda Arthropoda 252 1.11e-77   NR XP_064117239.1 159736 g239 i0 39.3 3.66371681415929 341 177 87.1 8 34 1017 4 327 XP_064117239.1 procathepsin L-like [Macrobrachium nipponense] diamond 4140 252 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
29524256 29524256 PRJNA529924_P_NODE_1810_length_389_cov_3.052778_g1636_i0 PRJNA529924 1810 389 3.052778 11.87530642 Metazoa 33208 Arthropoda Arthropoda 97.8 6.419999999999999e-24   NR XP_040566498.1 72036 g1636 i0 72.1 5.47557840616967 68 18 51.7 1 351 151 6 73 XP_040566498.1 stress-associated endoplasmic reticulum protein 2-like [Lepeophtheirus salmonis] diamond 2130 97.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
30488347 30488347 PRJNA529924_P_NODE_4673_length_166_cov_1.204380_g4499_i0 PRJNA529924 4673 166 1.20438 1.9992708 Holotrichia oblita 644536 Arthropoda Arthropoda 89.7 1.94e-19   NR KAI4460041.1 644536 g4499 i0 68.5 3.8855421686747 54 17 97.6 0 164 3 140 193 KAI4460041.1 dnaj-like-2 isoform a-related [Holotrichia oblita] diamond 645 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
31293313 31293313 PRJNA529924_P_NODE_2935_length_256_cov_3.977974_g2761_i0 PRJNA529924 2935 256 3.977974 10.18361344 Metazoa 33208 Arthropoda Arthropoda 45.1 0.00181   NR KAH8023298.1 6941 g2761 i0 100 41.82421875 21 0 24.6 0 130 68 78 98 KAH8023298.1 hypothetical protein HPB51_011741 [Rhipicephalus microplus] diamond 10707 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
31419834 31419834 PRJNA529924_P_NODE_5036_length_150_cov_2.206612_g4862_i0 PRJNA529924 5036 150 2.206612 3.309918 Metazoa 33208 Arthropoda Arthropoda 89 5.53e-19   NR CAH1373905.1 7067 g4862 i0 78 9 50 11 100 0 150 1 381 430 CAH1373905.1 unnamed protein product [Tenebrio molitor] diamond 1350 89.7 0.992196209587514 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
31594787 31594787 PRJNA529924_P_NODE_4636_length_167_cov_2.333333_g4462_i0 PRJNA529924 4636 167 2.333333 3.89666611 Molorchus minor 1323400 Arthropoda Arthropoda 50.1 3.46e-5   NR KAJ8981333.1 1323400 g4462 i0 52.1 0.862275449101796 48 22 86.2 1 167 24 48 94 KAJ8981333.1 hypothetical protein NQ317_015974 [Molorchus minor] diamond 144 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Molorchus Molorchus minor
32227468 32227468 PRJNA529924_P_NODE_3278_length_230_cov_2.258706_g3104_i0 PRJNA529924 3278 230 2.258706 5.1950238 Procambarus clarkii 6728 Arthropoda Arthropoda 81.6 6.56e-17   NR QDE54943.1 6728 g3104 i0 92.9 1.6304347826087 42 3 54.8 0 128 3 150 191 QDE54943.1 60S ribosomal protein L22-like protein, partial [Procambarus clarkii] diamond 375 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
32432385 32432385 PRJNA529924_P_NODE_4779_length_161_cov_1.287879_g4605_i0 PRJNA529924 4779 161 1.287879 2.07348519 Arthropoda 6656 Arthropoda Arthropoda 77 4.1e-16   NR XP_022653543.1 109461 g4605 i0 75 17.888198757764 48 12 89.4 0 2 145 106 153 XP_022653543.1 muscle-specific protein 20-like isoform X3 [Varroa destructor] diamond 2880 77.4 0.994832041343669 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor

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