RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1031674 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
2717241 2717241 PRJNA1031674_P_NODE_26503_length_243_cov_1.811765_g26292_i0 PRJNA1031674 26503 243 1.811765 4.40258895 Chironomus riparius 315576 Arthropoda Arthropoda 157 1.86e-42   NR CAG9799755.1 315576 g26292 i0 90 0.987654320987654 80 8 98.8 0 241 2 258 337 CAG9799755.1 unnamed protein product [Chironomus riparius] diamond 240 157 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
26774043 26774043 PRJNA1031674_P_NODE_19301_length_261_cov_2.984043_g19090_i0 PRJNA1031674 19301 261 2.984043 7.78835223 Delphacidae 33362 Arthropoda Arthropoda 65.5 4.93e-10   NR XP_039276123.1 108931 g19090 i0 88.2 6.8735632183908 34 4 39.1 0 198 97 2757 2790 XP_039276123.1 LOW QUALITY PROTEIN: obscurin [Nilaparvata lugens] diamond 1794 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
28424880 28424880 PRJNA1031674_P_NODE_12426_length_285_cov_1.886792_g12215_i0 PRJNA1031674 12426 285 1.886792 5.3773572 Tetranychus urticae 32264 Arthropoda Arthropoda 68.9 3.67e-11   NR XP_015782160.1 32264 g12215 i0 80.8 1.09473684210526 52 10 54.7 0 128 283 1 52 XP_015782160.1 NEDD8-activating enzyme E1 regulatory subunit [Tetranychus urticae] diamond 312 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
28803389 28803389 PRJNA1031674_P_NODE_25028_length_246_cov_0.890173_g24817_i0 PRJNA1031674 25028 246 0.890173 2.18982558 Ceuthophilus sp. XZ-2 3073481 Arthropoda Arthropoda 124 1.2699999999999998e-31   NR AUO15581.1 2057961 g24817 i0 64.6 1 82 29 100 0 246 1 275 356 AUO15581.1 hexamerin-like protein 3, partial [Ceuthophilus sp. XZ-2017] diamond 246 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Rhaphidophoridae Ceuthophilus Ceuthophilus sp. XZ-2017
29592589 29592589 PRJNA1031674_P_NODE_19930_length_259_cov_1.655914_g19719_i0 PRJNA1031674 19930 259 1.655914 4.28881726 Tetranychus evansi 178897 Arthropoda Arthropoda 84.7 7.99e-17   NR AYV89258.1 178897 g19719 i0 43.5 0.984555984555985 85 48 98.5 0 256 2 1635 1719 AYV89258.1 apolipophorins-like [Tetranychus evansi] diamond 255 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus evansi
29710960 29710960 PRJNA1031674_P_NODE_19490_length_261_cov_1.319149_g19279_i0 PRJNA1031674 19490 261 1.319149 3.44297889 Metazoa 33208 Arthropoda Arthropoda 42.7 0.0449   NR KAL1439429.1 34631 g19279 i0 55.9 0.919540229885057 34 12 35.6 1 256 164 367 400 KAL1439429.1 hypothetical protein MTO96_010245 [Rhipicephalus appendiculatus] diamond 240 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
30224632 30224632 PRJNA1031674_P_NODE_24152_length_247_cov_2.304598_g23941_i0 PRJNA1031674 24152 247 2.304598 5.69235706 Monomorium pharaonis 307658 Arthropoda Arthropoda 57.4 2.76e-7   NR XP_036142150.1 307658 g23941 i0 80.6 0.437246963562753 36 7 43.7 0 125 232 917 952 XP_036142150.1 uncharacterized protein LOC118645380 [Monomorium pharaonis] diamond 108 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Monomorium Monomorium pharaonis
30320045 30320045 PRJNA1031674_P_NODE_25332_length_245_cov_2.284884_g25121_i0 PRJNA1031674 25332 245 2.284884 5.5979658 Periplaneta americana 6978 Arthropoda Arthropoda 65.5 1.22e-10   NR KAJ4428229.1 6978 g25121 i0 53.4 5.68163265306122 58 24 67.3 1 2 166 127 184 KAJ4428229.1 hypothetical protein ANN_24245 [Periplaneta americana] diamond 1392 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
31235646 31235646 PRJNA1031674_P_NODE_8375_length_310_cov_3.227848_g8164_i0 PRJNA1031674 8375 310 3.227848 10.0063288 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 46.2 0.00432   NR KAG5670686.1 319348 g8164 i0 45.8 1.80967741935484 48 25 45.5 1 142 2 159 206 KAG5670686.1 hypothetical protein PVAND_000933 [Polypedilum vanderplanki] diamond 561 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
31267430 31267430 PRJNA1031674_P_NODE_22715_length_250_cov_0.870056_g22504_i0 PRJNA1031674 22715 250 0.870056 2.17514 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 61.2 1.26e-8   NR KAG9508647.1 1670756 g22504 i0 65 1.968 40 14 48 0 130 249 192 231 KAG9508647.1 E3 ubiquitin-protein ligase NEDD4, partial [Fragariocoptes setiger] diamond 492 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
31552309 31552309 PRJNA1031674_P_NODE_10976_length_290_cov_1.331797_g10765_i0 PRJNA1031674 10976 290 1.331797 3.8622113 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 110 1.43e-25   NR UYV63435.1 51811 g10765 i0 58.3 16.2206896551724 96 36 99.3 2 3 290 1135 1226 UYV63435.1 hypothetical protein LAZ67_2004061 [Cordylochernes scorpioides] diamond 4704 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
32089875 32089875 PRJNA1031674_P_NODE_17298_length_269_cov_1.571429_g17087_i0 PRJNA1031674 17298 269 1.571429 4.22714401 Uroleucon formosanum 796250 Arthropoda Arthropoda 158 1.29e-44   NR KAL4121220.1 796250 g17087 i0 89.9 0.992565055762082 89 9 99.3 0 3 269 73 161 KAL4121220.1 hypothetical protein QTP88_013777 [Uroleucon formosanum] diamond 267 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
32216517 32216517 PRJNA1031674_P_NODE_16638_length_271_cov_2.474747_g16427_i0 PRJNA1031674 16638 271 2.474747 6.70656437 Diaphorina citri 121845 Arthropoda Arthropoda 52.8 1.53e-5   NR KAI5731814.1 121845 g16427 i0 53.8 3.86346863468635 39 18 43.2 0 154 270 181 219 KAI5731814.1 hypothetical protein M8J77_016486 [Diaphorina citri] diamond 1047 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
32366839 32366839 PRJNA1031674_P_NODE_19919_length_259_cov_1.655914_g19708_i0 PRJNA1031674 19919 259 1.655914 4.28881726 Ixodidae 6939 Arthropoda Arthropoda 46.2 0.00269   NR CAL6190457.1 34612 g19708 i0 76 1.11196911196911 25 6 29 0 9 83 186 210 CAL6190457.1 unnamed protein product, partial [Ixodes hexagonus] diamond 288 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes hexagonus
32469788 32469788 PRJNA1031674_P_NODE_27239_length_242_cov_0.911243_g27028_i0 PRJNA1031674 27239 242 0.911243 2.20520806 Eufriesea mexicana 516756 Arthropoda Arthropoda 42.7 0.0351   NR XP_017759095.1 516756 g27028 i0 36.7 0.743801652892562 60 28 65.7 2 186 28 79 135 XP_017759095.1 PREDICTED: insulin-like growth factor-binding protein-related protein 1 [Eufriesea mexicana] diamond 180 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Eufriesea Eufriesea mexicana

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