RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA983838" 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

  • PRJNA983838 · 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
11475162 11475162 PRJNA983838_P_NODE_74029_length_317_cov_2.938525_g71662_i0 PRJNA983838 74029 317 2.938525 9.31512425 Idotea baltica 82763 Arthropoda Arthropoda 164 5.89e-49   NR MCL4120794.1 82763 g71662 i0 74 0.984227129337539 104 27 98.4 0 314 3 40 143 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 312 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27316987 27316987 PRJNA983838_P_NODE_50643_length_426_cov_3.320113_g48276_i0 PRJNA983838 50643 426 3.320113 14.14368138 Arthropoda 6656 Arthropoda Arthropoda 94.4 1.97e-19   NR XP_013792674.1 6850 g48276 i0 40.9 1.93661971830986 132 68 89.4 4 382 2 16 142 XP_013792674.1 sequestosome-1-like [Limulus polyphemus] diamond 825 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
27658389 27658389 PRJNA983838_P_NODE_117204_length_243_cov_0.917647_g114837_i0 PRJNA983838 117204 243 0.917647 2.22988221 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 67.8 5.9e-11   NR KAG5672421.1 319348 g114837 i0 79.5 1.44444444444444 39 8 48.1 0 112 228 68 106 KAG5672421.1 hypothetical protein PVAND_002551 [Polypedilum vanderplanki] diamond 351 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
28226233 28226233 PRJNA983838_P_NODE_119106_length_242_cov_0.923077_g116739_i0 PRJNA983838 119106 242 0.923077 2.23384634 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 45.1 0.00539   NR KDR14900.1 136037 g116739 i0 32.2 1.07851239669421 87 48 94.2 2 241 14 53 139 KDR14900.1 Chymotrypsin BI [Zootermopsis nevadensis] diamond 261 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
28447701 28447701 PRJNA983838_P_NODE_102366_length_256_cov_1.306011_g99999_i0 PRJNA983838 102366 256 1.306011 3.34338816 Parnassius apollo 110799 Arthropoda Arthropoda 43.9 0.0164   NR CAG5031695.1 110799 g99999 i0 47.4 2.484375 38 20 44.5 0 55 168 306 343 CAG5031695.1 unnamed protein product [Parnassius apollo] diamond 636 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo
29148561 29148561 PRJNA983838_P_NODE_75309_length_313_cov_3.162500_g72942_i0 PRJNA983838 75309 313 3.1625 9.898625 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 139 7.98e-40   NR KAK4027128.1 35525 g72942 i0 63.9 4.64856230031949 97 34 93 1 19 309 6 101 KAK4027128.1 hypothetical protein OUZ56_016143 [Daphnia magna] diamond 1455 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
29205499 29205499 PRJNA983838_P_NODE_85429_length_287_cov_1.457944_g83062_i0 PRJNA983838 85429 287 1.457944 4.18429928 Condylostylus longicornis 2530218 Arthropoda Arthropoda 99.4 1.07e-22   NR XP_055388650.1 2530218 g83062 i0 61.5 0.815331010452962 78 30 81.5 0 285 52 230 307 XP_055388650.1 60S ribosomal protein L7a-like [Condylostylus longicornis] diamond 234 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
29552398 29552398 PRJNA983838_P_NODE_119150_length_242_cov_0.923077_g116783_i0 PRJNA983838 119150 242 0.923077 2.23384634 Apolygus lucorum 248454 Arthropoda Arthropoda 88.2 3.74e-18   NR KAF6206425.1 248454 g116783 i0 51.3 3.85537190082645 80 39 99.2 0 3 242 564 643 KAF6206425.1 hypothetical protein GE061_017658 [Apolygus lucorum] diamond 933 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
29678589 29678589 PRJNA983838_P_NODE_104430_length_253_cov_0.866667_g102063_i0 PRJNA983838 104430 253 0.866667 2.19266751 Orchesella dallaii 48710 Arthropoda Arthropoda 42.7 0.0387   NR CAL8102052.1 48710 g102063 i0 34.5 0.652173913043478 55 36 65.2 0 87 251 161 215 CAL8102052.1 unnamed protein product [Orchesella dallaii] diamond 165 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
30279477 30279477 PRJNA983838_P_NODE_35392_length_578_cov_1.647525_g33043_i0 PRJNA983838 35392 578 1.647525 9.5226945 Panonychus citri 50023 Arthropoda Arthropoda 53.1 2.24e-4   NR XP_053204042.1 50023 g33043 i0 36.5 2.4757785467128 85 46 44.1 2 102 356 11 87 XP_053204042.1 uncharacterized protein LOC128388639 [Panonychus citri] diamond 1431 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
30506325 30506325 PRJNA983838_P_NODE_86993_length_284_cov_1.284360_g84626_i0 PRJNA983838 86993 284 1.28436 3.6475824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99.8 3.38e-24   NR XP_031367862.1 7462 g84626 i0 54.8 2.61971830985915 84 38 88.7 0 279 28 77 160 XP_031367862.1 40S ribosomal protein S12 isoform X1 [Apis dorsata] diamond 744 100 0.998 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis dorsata
32807573 32807573 PRJNA983838_P_NODE_67220_length_341_cov_1.746269_g64853_i0 PRJNA983838 67220 341 1.746269 5.95477729 Condylostylus longicornis 2530218 Arthropoda Arthropoda 140 4.1699999999999996e-38   NR XP_055388649.1 2530218 g64853 i0 61.6 0.98533724340176 112 41 98.5 2 341 6 110 219 XP_055388649.1 60S ribosomal protein L5-like [Condylostylus longicornis] diamond 336 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis

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