RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "blastn", bioproject = "PRJNA664479" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA664479 · 31 ✖

analysis 1

  • blastn · 31 ✖
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
629184 629184 PRJNA664479_S_NODE_11721_length_178_cov_2.240310_g11645_i0 PRJNA664479 11721 178 2.24031 3.9877518 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g11645 i0 100 0.157303370786517 28 0 16 0 109 136 994 1021 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
629187 629187 PRJNA664479_S_NODE_16861_length_164_cov_0.860870_g16785_i0 PRJNA664479 16861 164 0.86087 1.4118268 Drosophila serrata 7274 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|1189091195|ref|XM_020956927.1| 7274 g16785 i0 100 0.170731707317073 28 0 17 0 101 128 472 445 PREDICTED: Drosophila serrata intraflagellar transport protein 46 homolog (LOC110187533), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila serrata
1905254 1905254 PRJNA664479_S_NODE_13162_length_171_cov_2.540984_g13086_i0 PRJNA664479 13162 171 2.540984 4.34508264 Timema douglasi 61478 Arthropoda Arthropoda 67.6 5.11e-7   NTclustered gi|1936906359|emb|OA565832.1| 61478 g13086 i0 91.837 13.327485380117 49 2 27 2 54 100 143553 143505 1_Tdi_b3v08 blastn 2279 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
1905261 1905261 PRJNA664479_S_NODE_18062_length_162_cov_0.902655_g17986_i0 PRJNA664479 18062 162 0.902655 1.4623011 Drosophila grimshawi 7222 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2087624994|ref|XM_043216176.1| 7222 g17986 i0 100 0.172839506172839 28 0 17 0 46 73 2175 2148 PREDICTED: Drosophila grimshawi uncharacterized LOC6566018 (LOC6566018), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
4457068 4457068 PRJNA664479_S_NODE_1024_length_466_cov_1.868106_g948_i0 PRJNA664479 1024 466 1.868106 8.70537396 Gotra octocincta 3029099 Arthropoda Arthropoda 52.8 0.045   NTclustered gi|2459376532|ref|NC_072299.1| 3029099 g948 i0 100 0.0600858369098712 28 0 6 0 159 186 12115 12088 Gotra octocincta mitochondrion, complete genome blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Gotra Gotra octocincta
4457079 4457079 PRJNA664479_S_NODE_8024_length_202_cov_0.764706_g7948_i0 PRJNA664479 8024 202 0.764706 1.54470612 Pterostichus ziegleri 795088 Arthropoda Arthropoda 82.4 2.24e-11   NTclustered gi|297719461|gb|GU347343.1| 795088 g7948 i0 85.714 0.702970297029703 77 11 38 0 35 111 171 95 Pterostichus ziegleri voucher ZFMK_COL_2009_484 cytochrome c oxidase subunit I (CO1) gene, partial cds; mitochondrial blastn 142 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Pterostichus Pterostichus ziegleri
7007787 7007787 PRJNA664479_S_NODE_2786_length_299_cov_1.164000_g2710_i0 PRJNA664479 2786 299 1.164 3.48036 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g2710 i0 100 0.0936454849498328 28 0 9 0 124 151 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
7007790 7007790 PRJNA664479_S_NODE_3806_length_264_cov_3.432558_g3730_i0 PRJNA664479 3806 264 3.432558 9.06195312 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|1946153605|emb|OD012397.1| 170557 g3730 i0 100 0.106060606060606 28 0 11 0 117 144 9148 9121 1_Tps_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
7007794 7007794 PRJNA664479_S_NODE_886_length_495_cov_1.746637_g812_i0 PRJNA664479 886 495 1.746637 8.64585315 Bactericera cockerelli 290155 Arthropoda Arthropoda 130 2.17e-25   NTclustered gi|973967085|gb|KT185020.1| 290155 g812 i0 72.613 92.0282828282828 398 107 80 2 99 495 564 168 Bactericera cockerelli elongation factor 1 alpha mRNA, complete cds blastn 45554 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Triozidae Bactericera Bactericera cockerelli
8282366 8282366 PRJNA664479_S_NODE_1067_length_458_cov_5.557457_g991_i0 PRJNA664479 1067 458 5.557457 25.453153060000002 Hetaerina americana 62018 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|2918258872|ref|XM_071594800.1| 62018 g991 i0 96.875 0.74235807860262 32 1 7 0 240 271 3667 3698 PREDICTED: Hetaerina americana activated Cdc42 kinase-like (Ack-like), mRNA blastn 340 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Calopterygidae Hetaerina Hetaerina americana
8282383 8282383 PRJNA664479_S_NODE_2887_length_295_cov_3.943089_g2811_i0 PRJNA664479 2887 295 3.943089 11.63211255 Drosophila albomicans 7291 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2328675367|ref|XM_034251438.2| 7291 g2811 i0 100 0.189830508474576 28 0 9 0 68 95 3573 3600 PREDICTED: Drosophila albomicans probable serine/threonine-protein kinase DDB_G0282963 (LOC117570021), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila albomicans
8282386 8282386 PRJNA664479_S_NODE_7107_length_210_cov_0.950311_g7031_i0 PRJNA664479 7107 210 0.950311 1.9956531 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1963345359|emb|OE839378.1| 629358 g7031 i0 100 0.795238095238095 29 0 14 0 53 81 6912 6940 5_Tge_b3v08 blastn 167 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
9557651 9557651 PRJNA664479_S_NODE_2608_length_307_cov_9.383721_g2532_i0 PRJNA664479 2608 307 9.383721 28.80802347 Periplaneta americana 6978 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2852175578|ref|XM_069813601.1| 6978 g2532 i0 100 0.0944625407166124 29 0 9 0 236 264 2058 2086 PREDICTED: Periplaneta americana zinc finger protein ZFP2-like (LOC138691549), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
9557652 9557652 PRJNA664479_S_NODE_4608_length_245_cov_0.826531_g4532_i0 PRJNA664479 4608 245 0.826531 2.02500095 Teleiodes vulgella 1594352 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918369950|emb|OZ237932.1| 1594352 g4532 i0 96.875 0.130612244897959 32 1 13 0 104 135 13161933 13161964 Teleiodes vulgella genome assembly, chromosome: 13 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
10833268 10833268 PRJNA664479_S_NODE_12709_length_173_cov_2.467742_g12633_i0 PRJNA664479 12709 173 2.467742 4.26919366 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|2918369791|emb|OZ237858.1| 1007376 g12633 i0 100 0.161849710982659 28 0 16 0 24 51 9071663 9071636 Pseudoterpna coronillaria genome assembly, chromosome: Z blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
10833280 10833280 PRJNA664479_S_NODE_2249_length_330_cov_2.665480_g2173_i0 PRJNA664479 2249 330 2.66548 8.796084 Samia ricini 63990 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2883230451|dbj|AP038909.1| 63990 g2173 i0 94.444 0.109090909090909 36 0 11 2 119 153 30174130 30174096 Samia ricini White GU1 DNA, chromosome 14, complete sequence blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
10833281 10833281 PRJNA664479_S_NODE_4909_length_239_cov_0.894737_g4833_i0 PRJNA664479 4909 239 0.894737 2.13842143 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 209 1.2e-49   NTclustered gi|2087235751|ref|XM_043382560.1| 1232801 g4833 i0 82.5 15.0292887029289 240 40 100 2 1 239 832 1070 PREDICTED: Amphibalanus amphitrite actin, muscle (LOC122390001), mRNA blastn 3592 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
12108481 12108481 PRJNA664479_S_NODE_10930_length_182_cov_4.804511_g10854_i0 PRJNA664479 10930 182 4.804511 8.74421002 Charissa obscurata 204503 Arthropoda Arthropoda 69.4 1.54e-7   NTclustered gi|2919606485|emb|OZ238398.1| 204503 g10854 i0 93.478 0.758241758241758 46 3 25 0 1 46 2830074 2830029 Charissa obscurata genome assembly, chromosome: Z blastn 138 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
12641481 12641481 PRJNA664479_S_NODE_630_length_587_cov_6.600372_g561_i0 PRJNA664479 630 587 6.600372 38.74418364 Euwallacea 124011 Arthropoda Arthropoda 54.7 0.016   NTclustered gi|2753860062|ref|XM_066295923.1| 995702 g561 i0 94.444 0.245315161839864 36 1 6 1 10 45 3264 3298 PREDICTED: Euwallacea fornicatus Mitochondrial assembly regulatory factor (Marf), transcript variant X1, mRNA blastn 144 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
13383212 13383212 PRJNA664479_S_NODE_2691_length_303_cov_2.244094_g2615_i0 PRJNA664479 2691 303 2.244094 6.79960482 Callophrys avis 700180 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2918383891|emb|OZ238071.1| 700180 g2615 i0 96.774 0.102310231023102 31 1 10 0 4 34 3293318 3293288 Callophrys avis genome assembly, chromosome: 4 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
14658111 14658111 PRJNA664479_S_NODE_13492_length_170_cov_1.256198_g13416_i0 PRJNA664479 13492 170 1.256198 2.1355366 Dalotia coriaria 877792 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2732242831|ref|XM_065299541.1| 877792 g13416 i0 100 0.164705882352941 28 0 16 0 41 68 2371 2344 PREDICTED: Atheta coriaria uncharacterized protein (LOC135789623), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
15932011 15932011 PRJNA664479_S_NODE_11973_length_177_cov_1.195312_g11897_i0 PRJNA664479 11973 177 1.195312 2.11570224 Euthrix potatoria 624169 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918369999|emb|OZ237886.1| 624169 g11897 i0 100 0.163841807909605 29 0 16 0 134 162 8884076 8884048 Euthrix potatoria genome assembly, chromosome: 14 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
15932015 15932015 PRJNA664479_S_NODE_15233_length_166_cov_0.871795_g15157_i0 PRJNA664479 15233 166 0.871795 1.4471797 Culex pipiens 7175 Arthropoda Arthropoda 279 5.86e-71   NTclustered gi|2415586974|ref|XM_039573158.2| 42434 g15157 i0 96.988 3.53012048192771 166 5 100 0 1 166 1065 900 PREDICTED: Culex pipiens pallens dihydrofolate reductase (LOC120412610), mRNA blastn 586 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
16465090 16465090 PRJNA664479_S_NODE_10013_length_188_cov_1.086331_g9937_i0 PRJNA664479 10013 188 1.086331 2.04230228 Metazoa 33208 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1964700418|emb|OE185876.1| 61474 g9937 i0 100 0.893617021276596 28 0 15 0 117 144 15161 15134 2_Tcm_b3v08 blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
17207204 17207204 PRJNA664479_S_NODE_15974_length_165_cov_0.879310_g15898_i0 PRJNA664479 15974 165 0.87931 1.4508615 Thrips palmi 161013 Arthropoda Arthropoda 95.3 2.26e-15   NTclustered gi|1841850755|ref|XM_034399754.1| 161013 g15898 i0 80.576 0.842424242424242 139 14 78 11 38 165 4508 4644 PREDICTED: Thrips palmi adiponectin receptor protein (LOC117653820), transcript variant X1, mRNA blastn 139 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
19756077 19756077 PRJNA664479_S_NODE_18696_length_161_cov_0.910714_g18620_i0 PRJNA664479 18696 161 0.910714 1.46624954 Ostrinia furnacalis 93504 Arthropoda Arthropoda 287 3.37e-73   NTclustered gi|1590299090|ref|XM_028318194.1| 93504 g18620 i0 98.758 14.0186335403727 161 2 100 0 1 161 5910 5750 PREDICTED: Ostrinia furnacalis basement membrane-specific heparan sulfate proteoglycan core protein (LOC114362700), transcript variant X9, mRNA blastn 2257 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia furnacalis
22306455 22306455 PRJNA664479_S_NODE_13938_length_168_cov_1.714286_g13862_i0 PRJNA664479 13938 168 1.714286 2.88000048 Agapeta hamana 1100904 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g13862 i0 94.286 0.208333333333333 35 2 21 0 51 85 16934838 16934804 Agapeta hamana genome assembly, chromosome: 4 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
23581795 23581795 PRJNA664479_S_NODE_13059_length_172_cov_1.024390_g12983_i0 PRJNA664479 13059 172 1.02439 1.7619508 Cotesia glomerata 32391 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2120578343|ref|XM_044729824.1| 32391 g12983 i0 100 1.7906976744186 28 0 16 0 4 31 1475 1448 PREDICTED: Cotesia glomerata cyclic AMP-responsive element-binding protein 1 (LOC123265870), transcript variant X2, mRNA blastn 308 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
23581804 23581804 PRJNA664479_S_NODE_18459_length_161_cov_1.669643_g18383_i0 PRJNA664479 18459 161 1.669643 2.68812523 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2919608728|emb|OZ238409.1| 2546182 g18383 i0 100 0.173913043478261 28 0 17 0 109 136 8223925 8223952 Chelidura thaleri genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
24114212 24114212 PRJNA664479_S_NODE_479_length_656_cov_6.321252_g415_i0 PRJNA664479 479 656 6.321252 41.46741312 Varroa 62624 Arthropoda Arthropoda 54.7 0.018   NTclustered gi|1268049155|ref|XM_022841252.1| 62625 g415 i0 96.875 0.0975609756097561 32 1 5 0 543 574 3863 3894 PREDICTED: Varroa jacobsoni histone acetyltransferase p300-like (LOC111264963), mRNA blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa jacobsoni
24855412 24855412 PRJNA664479_S_NODE_8080_length_201_cov_1.625000_g8004_i0 PRJNA664479 8080 201 1.625 3.26625 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|2919549858|emb|OZ238360.1| 1002887 g8004 i0 96.875 0.159203980099502 32 0 16 1 92 123 15518787 15518757 Glaucopsyche melanops genome assembly, chromosome: 19 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops

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