RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA591127 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
3116005 3116005 PRJNA591127_P_NODE_23683_length_176_cov_8.525180_g23514_i0 PRJNA591127 23683 176 8.52518 15.0043168 Orchesella cincta 48709 Arthropoda Arthropoda 84 9.32e-19   NR ODM93050.1 48709 g23514 i0 95.2 2.86363636363636 42 2 71.6 0 3 128 110 151 ODM93050.1 40S ribosomal protein S13 [Orchesella cincta] diamond 504 84 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
14593926 14593926 PRJNA591127_P_NODE_25712_length_164_cov_7.125984_g25543_i0 PRJNA591127 25712 164 7.125984 11.68661376 Eukoenenia sp. 2 PBK-2 2051908 Arthropoda Arthropoda 90.5 1.23e-19   NR ATY50363.1 2051908 g25543 i0 78.8 2.8719512195122 52 11 95.1 0 6 161 93 144 ATY50363.1 cytochrome oxidase subunit I, partial [Eukoenenia sp. 2 PBK-2017] diamond 471 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Palpigradi Eukoeneniidae Eukoenenia Eukoenenia sp. 2 PBK-2017
17142730 17142730 PRJNA591127_P_NODE_23874_length_175_cov_3.253623_g23705_i0 PRJNA591127 23874 175 3.253623 5.69384025 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99.4 1.32e-22   NR KAK2705297.1 6661 g23705 i0 84.2 53.7428571428571 57 9 97.7 0 173 3 262 318 KAK2705297.1 hypothetical protein QYM36_017365 [Artemia franciscana] diamond 9405 100 0.994 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
26681565 26681565 PRJNA591127_P_NODE_20001_length_197_cov_1.856250_g19832_i0 PRJNA591127 20001 197 1.85625 3.6568125 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.4 4.68e-4   NR CAL8144035.1 48710 g19832 i0 72 3.68527918781726 25 7 38.1 0 123 197 211 235 CAL8144035.1 unnamed protein product [Orchesella dallaii] diamond 726 47.8 0.99163179916318 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
27205852 27205852 PRJNA591127_P_NODE_17082_length_197_cov_2.600000_g16913_i0 PRJNA591127 17082 197 2.6 5.122 Orchesella cincta 48709 Arthropoda Arthropoda 42.4 0.0284   NR ODM91558.1 48709 g16913 i0 91.7 0.365482233502538 24 2 36.5 0 196 125 244 267 ODM91558.1 Myosin-IA [Orchesella cincta] diamond 72 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
27616917 27616917 PRJNA591127_P_NODE_9744_length_236_cov_1.356784_g9576_i0 PRJNA591127 9744 236 1.356784 3.20201024 Phymastichus coffea 108790 Arthropoda Arthropoda 52.4 3.34e-6   NR XP_058810086.1 108790 g9576 i0 37.3 4.24576271186441 75 47 95.3 0 231 7 10 84 XP_058810086.1 large ribosomal subunit protein eL22-like [Phymastichus coffea] diamond 1002 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea
27837634 27837634 PRJNA591127_P_NODE_31664_length_150_cov_3.584071_g31495_i0 PRJNA591127 31664 150 3.584071 5.3761065 Halotydeus destructor 2874060 Arthropoda Arthropoda 52 5.79e-6   NR KAI1284959.1 2874060 g31495 i0 96.3 1.14 27 1 54 0 70 150 3 29 KAI1284959.1 CDK5 and ABL1 enzyme substrate 1 [Halotydeus destructor] diamond 171 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
28216435 28216435 PRJNA591127_P_NODE_21366_length_192_cov_11.832258_g21197_i0 PRJNA591127 21366 192 11.832258 22.71793536 Harmonia axyridis 115357 Arthropoda Arthropoda 58.2 5.23e-8   NR XP_045480210.1 115357 g21197 i0 65 4.59375 40 14 62.5 0 1 120 226 265 XP_045480210.1 40S ribosomal protein S2 [Harmonia axyridis] diamond 882 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
28261542 28261542 PRJNA591127_P_NODE_26426_length_161_cov_1.669355_g26257_i0 PRJNA591127 26426 161 1.669355 2.68766155 Metazoa 33208 Arthropoda Arthropoda 86.3 1.12e-18   NR XP_050029294.2 34620 g26257 i0 71.7 16.7888198757764 53 15 98.8 0 159 1 73 125 XP_050029294.2 40S ribosomal protein S2 [Dermacentor andersoni] diamond 2703 86.7 0.995386389850058 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
28847997 28847997 PRJNA591127_P_NODE_31088_length_150_cov_8.530973_g30919_i0 PRJNA591127 31088 150 8.530973 12.7964595 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 60.8 1.13e-9   NR KAK3859257.1 88211 g30919 i0 63 15.84 46 17 92 0 11 148 5 50 KAK3859257.1 hypothetical protein Pcinc_034611 [Petrolisthes cinctipes] diamond 2376 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
29164157 29164157 PRJNA591127_P_NODE_3029_length_410_cov_1.815013_g2861_i0 PRJNA591127 3029 410 1.815013 7.4415533 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 89.7 2.79e-19   NR ADD38186.1 72036 g2861 i0 34.3 0.980487804878049 134 83 98 1 9 410 26 154 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 402 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29826849 29826849 PRJNA591127_P_NODE_27811_length_155_cov_0.991525_g27642_i0 PRJNA591127 27811 155 0.991525 1.53686375 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 75.5 7e-16   NR KAH9422685.1 6956 g27642 i0 60.8 1.9741935483871 51 20 98.7 0 3 155 70 120 KAH9422685.1 Ubiquitin-fold modifier 1 [Dermatophagoides pteronyssinus] diamond 306 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
30522006 30522006 PRJNA591127_P_NODE_25293_length_167_cov_1.500000_g25124_i0 PRJNA591127 25293 167 1.5 2.505 Idotea baltica 82763 Arthropoda Arthropoda 70.1 5.98e-13   NR MCL4142858.1 82763 g25124 i0 73.5 0.880239520958084 49 13 88 0 157 11 156 204 MCL4142858.1 hypothetical protein [Idotea baltica] diamond 147 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31027735 31027735 PRJNA591127_P_NODE_15795_length_197_cov_3.093750_g15626_i0 PRJNA591127 15795 197 3.09375 6.0946875 Pediculus humanus corporis 121224 Arthropoda Arthropoda 60.5 1.14e-8   NR XP_002427015.1 121224 g15626 i0 100 0.761421319796954 25 0 38.1 0 123 197 1637 1661 XP_002427015.1 uncharacterized protein Phum_PHUM289860 [Pediculus humanus corporis] diamond 150 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
31388898 31388898 PRJNA591127_P_NODE_6436_length_290_cov_1.968379_g6268_i0 PRJNA591127 6436 290 1.968379 5.7082991 Diptera 7147 Arthropoda Arthropoda 73.2 5.29e-14   NR XP_055701935.1 29031 g6268 i0 48.6 3.7448275862069 72 35 74.5 2 275 60 66 135 XP_055701935.1 40S ribosomal protein S12 [Phlebotomus papatasi] diamond 1086 73.9 0.990527740189445 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
31407049 31407049 PRJNA591127_P_NODE_17996_length_197_cov_2.337500_g17827_i0 PRJNA591127 17996 197 2.3375 4.604875 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 45.1 0.00308   NR XP_050520966.1 58002 g17827 i0 91.3 0.700507614213198 23 2 35 0 193 125 62 84 XP_050520966.1 pickpocket protein 28-like isoform X2 [Daktulosphaira vitifoliae] diamond 138 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
31596952 31596952 PRJNA591127_P_NODE_22656_length_183_cov_2.972603_g22487_i0 PRJNA591127 22656 183 2.972603 5.43986349 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00662   NR CAK9813121.1 597819 g22487 i0 48.6 2.86885245901639 35 18 57.4 0 138 34 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
31736519 31736519 PRJNA591127_P_NODE_19337_length_197_cov_2.018750_g19168_i0 PRJNA591127 19337 197 2.01875 3.9769375 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.5 1.86e-4   NR XP_067618524.1 178769 g19168 i0 84 2.60406091370558 25 4 38.1 0 196 122 119 143 XP_067618524.1 cytoplasmic aconitate hydratase-like [Eurosta solidaginis] diamond 513 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Eurosta Eurosta solidaginis
31818024 31818024 PRJNA591127_P_NODE_11197_length_220_cov_1.994536_g11028_i0 PRJNA591127 11197 220 1.994536 4.3879792 Idotea baltica 82763 Arthropoda Arthropoda 94.7 3.700000000000001e-22   NR MCL4142858.1 82763 g11028 i0 75.8 1.69090909090909 62 15 84.5 0 2 187 143 204 MCL4142858.1 hypothetical protein [Idotea baltica] diamond 372 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32546033 32546033 PRJNA591127_P_NODE_25499_length_166_cov_1.155039_g25330_i0 PRJNA591127 25499 166 1.155039 1.91736474 Aphis craccivora 307492 Arthropoda Arthropoda 64.7 3.22e-12   NR KAF0747813.1 307492 g25330 i0 100 0.487951807228916 27 0 48.8 0 3 83 36 62 KAF0747813.1 Uncharacterized protein FWK35_00027316 [Aphis craccivora] diamond 81 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
32653499 32653499 PRJNA591127_P_NODE_26560_length_160_cov_3.105691_g26391_i0 PRJNA591127 26560 160 3.105691 4.9691056 Insecta 50557 Arthropoda Arthropoda 44.7 0.00246   NR CAG9120840.1 51655 g26391 i0 51.5 3.01875 33 16 61.9 0 158 60 600 632 CAG9120840.1 unnamed protein product, partial [Plutella xylostella] diamond 483 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
32716778 32716778 PRJNA591127_P_NODE_31740_length_150_cov_3.371681_g31571_i0 PRJNA591127 31740 150 3.371681 5.0575215 Arthropoda 6656 Arthropoda Arthropoda 44.3 0.00296   NR XP_030749697.1 7048 g31571 i0 69.2 2.18 26 8 52 0 72 149 176 201 XP_030749697.1 uncharacterized protein LOC115877590 [Sitophilus oryzae] diamond 327 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae

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