RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674050 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
13397891 13397891 PRJNA674050_P_NODE_27111_length_249_cov_0.886364_g26908_i0 PRJNA674050 27111 249 0.886364 2.20704636 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 80.1 2.8e-15   NR KAH9419670.1 6956 g26908 i0 92.3 0.939759036144578 39 3 47 0 175 59 224 262 KAH9419670.1 hypothetical protein DERP_015366, partial [Dermatophagoides pteronyssinus] diamond 234 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
26669946 26669946 PRJNA674050_P_NODE_35821_length_244_cov_0.906433_g35618_i0 PRJNA674050 35821 244 0.906433 2.21169652 Eupeodes corollae 290404 Arthropoda Arthropoda 56.2 6.89e-7   NR XP_055911515.1 290404 g35618 i0 61.4 0.540983606557377 44 17 54.1 0 132 1 779 822 XP_055911515.1 cadherin-23 [Eupeodes corollae] diamond 132 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
27156537 27156537 PRJNA674050_P_NODE_35062_length_244_cov_1.415205_g34859_i0 PRJNA674050 35062 244 1.415205 3.4531002 Metazoa 33208 Arthropoda Arthropoda 100 8.439999999999999e-23   NR EFX87434.1 6669 g34859 i0 54.9 63.0983606557377 82 35 99.6 2 1 243 231 311 EFX87434.1 hypothetical protein DAPPUDRAFT_221708 [Daphnia pulex] diamond 15396 101 0.99009900990099 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27239714 27239714 PRJNA674050_P_NODE_403_length_1153_cov_4.491667_g272_i0 PRJNA674050 403 1153 4.491667 51.78892051 Anthophora plagiata 597819 Arthropoda Arthropoda 116 3.75e-24   NR CAK9795901.1 597819 g272 i0 30.3 0.790980052038161 304 177 74.9 13 34 897 403 687 CAK9795901.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Anthophora plagiata] diamond 912 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
29166194 29166194 PRJNA674050_P_NODE_11949_length_289_cov_0.962963_g11746_i0 PRJNA674050 11949 289 0.962963 2.78296307 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 67.4 1.3e-10   NR KAH9417095.1 6956 g11746 i0 100 0.332179930795848 32 0 33.2 0 287 192 442 473 KAH9417095.1 hypothetical protein DERP_013211 [Dermatophagoides pteronyssinus] diamond 96 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29588036 29588036 PRJNA674050_P_NODE_25370_length_250_cov_1.276836_g25167_i0 PRJNA674050 25370 250 1.276836 3.19209 Metazoa 33208 Arthropoda Arthropoda 49.3 1.87e-4   NR GBM07567.1 182803 g25167 i0 36.8 3.708 76 45 87.6 1 7 225 228 303 GBM07567.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Araneus ventricosus] diamond 927 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30283679 30283679 PRJNA674050_P_NODE_512_length_998_cov_3.495135_g363_i0 PRJNA674050 512 998 3.495135 34.8814473 Opisthokonta 33154 Arthropoda Arthropoda 138 3.7899999999999997e-32   NR KAI5725972.1 121845 g363 i0 29.9 5.89178356713427 328 200 96.5 11 17 979 738 1042 KAI5725972.1 hypothetical protein M8J77_022339 [Diaphorina citri] diamond 5880 139 0.992805755395683 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
30334972 30334972 PRJNA674050_P_NODE_2552_length_432_cov_2.752089_g2349_i0 PRJNA674050 2552 432 2.752089 11.88902448 Blattella germanica 6973 Arthropoda Arthropoda 68.6 2.99e-10   NR AKU04652.1 6973 g2349 i0 34.3 0.951388888888889 137 85 93.1 4 423 22 368 502 AKU04652.1 polyprotein [Blattella germanica] diamond 411 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
32085151 32085151 PRJNA674050_P_NODE_41478_length_227_cov_2.642857_g41275_i0 PRJNA674050 41478 227 2.642857 5.99928539 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.9 4.03e-8   NR XP_014238573.1 7493 g41275 i0 60.5 6.19823788546256 43 17 56.8 0 224 96 217 259 XP_014238573.1 40S ribosomal protein S4 [Trichogramma pretiosum] diamond 1407 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
32168431 32168431 PRJNA674050_P_NODE_34198_length_245_cov_0.901163_g33995_i0 PRJNA674050 34198 245 0.901163 2.20784935 Sarcoptes scabiei 52283 Arthropoda Arthropoda 58.5 1.05e-7   NR KAF7496125.1 52283 g33995 i0 52.6 0.697959183673469 57 24 67.3 2 234 70 1249 1304 KAF7496125.1 Transposon Tf2-6 polyprotein [Sarcoptes scabiei] diamond 171 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
32548153 32548153 PRJNA674050_P_NODE_23539_length_252_cov_0.865922_g23336_i0 PRJNA674050 23539 252 0.865922 2.18212344 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 42.7 0.00781   NR KAH9421062.1 6956 g23336 i0 100 0.25 21 0 25 0 181 243 1 21 KAH9421062.1 hypothetical protein DERP_001504 [Dermatophagoides pteronyssinus] diamond 63 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
32560123 32560123 PRJNA674050_P_NODE_24799_length_251_cov_0.870787_g24596_i0 PRJNA674050 24799 251 0.870787 2.18567537 Insecta 50557 Arthropoda Arthropoda 55.5 1.28e-6   NR XP_064553796.1 40370 g24596 i0 38.5 4.62549800796813 78 45 93.2 1 251 18 223 297 XP_064553796.1 protein roadkill-like [Drosophila montana] diamond 1161 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila montana

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