RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "blastn", bioproject = "PRJNA564810" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA564810 · 29 ✖

analysis 1

  • blastn · 29 ✖
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
554072 554072 PRJNA564810_S_NODE_1921_length_341_cov_1.641304_g1899_i0 PRJNA564810 1921 341 1.641304 5.59684664 Notodromas monacha 399045 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1937984410|emb|OA882969.1| 399045 g1899 i0 100 0.0850439882697947 29 0 9 0 276 304 19088 19116 Notodromas monacha blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
554082 554082 PRJNA564810_S_NODE_5101_length_252_cov_1.818182_g5079_i0 PRJNA564810 5101 252 1.818182 4.58181864 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g5079 i0 100 0.337301587301587 29 0 12 0 224 252 56 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
2408984 2408984 PRJNA564810_S_NODE_2242_length_326_cov_1.302682_g2220_i0 PRJNA564810 2242 326 1.302682 4.24674332 Opisthokonta 33154 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2328685095|ref|XM_034259507.2| 7291 g2220 i0 100 0.616564417177914 29 0 9 0 171 199 596 624 PREDICTED: Drosophila albomicans uncharacterized LOC117575342 (LOC117575342), mRNA blastn 201 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila albomicans
3105047 3105047 PRJNA564810_S_NODE_5563_length_244_cov_1.139665_g5541_i0 PRJNA564810 5563 244 1.139665 2.7807826 Anopheles albimanus 7167 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1894980626|ref|XM_035932298.1| 7167 g5541 i0 100 1.21311475409836 30 0 12 0 211 240 2914 2943 PREDICTED: Anopheles albimanus hornerin-like (LOC118464722), transcript variant X1, mRNA blastn 296 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
3105050 3105050 PRJNA564810_S_NODE_663_length_456_cov_16.005115_g641_i0 PRJNA564810 663 456 16.005115 72.9833244 Drosophila willistoni 7260 Arthropoda Arthropoda 67.6 1.58e-6   NTclustered gi|2203533773|ref|XM_002067803.4| 7260 g641 i0 91.667 2.85745614035088 48 4 11 0 409 456 791 744 PREDICTED: Drosophila willistoni 60S ribosomal protein L8 (LOC6645040), mRNA blastn 1303 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila willistoni
3105051 3105051 PRJNA564810_S_NODE_7103_length_222_cov_1.299363_g7081_i0 PRJNA564810 7103 222 1.299363 2.88458586 Cydia pomonella 82600 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g7081 i0 100 0.252252252252252 28 0 13 0 36 63 126 99 PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
3105058 3105058 PRJNA564810_S_NODE_8763_length_197_cov_5.886364_g8741_i0 PRJNA564810 8763 197 5.886364 11.59613708 Ablabesmyia sp. 3XL 3344868 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|2802844361|gb|PQ323376.1| 3344868 g8741 i0 100 0.142131979695431 28 0 14 0 151 178 9204 9177 Ablabesmyia sp. 3XL mitochondrion, complete genome blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Ablabesmyia Ablabesmyia sp. 3XL
3105059 3105059 PRJNA564810_S_NODE_923_length_412_cov_5.498559_g901_i0 PRJNA564810 923 412 5.498559 22.65406308 Bemisia tabaci 7038 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|1101370597|ref|XM_019061133.1| 7038 g901 i0 100 0.0679611650485437 28 0 7 0 2 29 937 964 PREDICTED: Bemisia tabaci uncharacterized LOC109043815 (LOC109043815), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
3684976 3684976 PRJNA564810_S_NODE_7023_length_223_cov_0.860759_g7001_i0 PRJNA564810 7023 223 0.860759 1.91949257 root 1 Root_unresolved Root_unresolved 52.8 0.02   NTclustered gi|1184387702|emb|LT835105.1| 85552 g7001 i0 100 0.251121076233184 28 0 13 0 1 28 6 33 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
4381627 4381627 PRJNA564810_S_NODE_1204_length_384_cov_5.978056_g1182_i0 PRJNA564810 1204 384 5.978056 22.95573504 Drosophila montana 40370 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|2721919458|ref|XM_064683740.1| 40370 g1182 i0 100 0.0755208333333333 29 0 8 0 356 384 736 708 PREDICTED: Drosophila montana ribosomal protein L8 (RpL8), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila montana
4961686 4961686 PRJNA564810_S_NODE_3804_length_277_cov_3.372642_g3782_i0 PRJNA564810 3804 277 3.372642 9.34221834 Metazoa 33208 Arthropoda Arthropoda 60.2 1.52e-4   NTclustered gi|2087624429|ref|XM_043216049.1| 7222 g3782 i0 97.222 5.5884476534296 36 0 13 1 216 251 4970 5004 PREDICTED: Drosophila grimshawi uncharacterized LOC6566059 (LOC6566059), mRNA blastn 1548 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
7511456 7511456 PRJNA564810_S_NODE_1746_length_348_cov_2.611307_g1724_i0 PRJNA564810 1746 348 2.611307 9.08734836 Arthropoda 6656 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1026137028|emb|LT560377.1| 85552 g1724 i0 100 0.652298850574713 29 0 8 0 1 29 6 34 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 227 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
8207118 8207118 PRJNA564810_S_NODE_3267_length_291_cov_1.637168_g3245_i0 PRJNA564810 3267 291 1.637168 4.76415888 Aedes albopictus 7160 Arthropoda Arthropoda 62.1 4.48e-5   NTclustered gi|2669899882|ref|XM_062852324.1| 7160 g3245 i0 94.872 0.77319587628866 39 2 13 0 29 67 3608 3570 PREDICTED: Aedes albopictus AF4/FMR2 family member lilli (LOC109412528), transcript variant X1, mRNA blastn 225 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
8786416 8786416 PRJNA564810_S_NODE_2607_length_311_cov_3.898374_g2585_i0 PRJNA564810 2607 311 3.898374 12.12394314 root 1 Root_unresolved Root_unresolved 52.8 0.029   NTclustered gi|1184387702|emb|LT835105.1| 85552 g2585 i0 100 0.180064308681672 28 0 9 0 1 28 6 33 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
9482552 9482552 PRJNA564810_S_NODE_6608_length_228_cov_1.337423_g6586_i0 PRJNA564810 6608 228 1.337423 3.04932444 Bemisia tabaci 7038 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1101370597|ref|XM_019061133.1| 7038 g6586 i0 100 0.12719298245614 29 0 13 0 199 227 965 937 PREDICTED: Bemisia tabaci uncharacterized LOC109043815 (LOC109043815), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
9482553 9482553 PRJNA564810_S_NODE_6968_length_223_cov_3.443038_g6946_i0 PRJNA564810 6968 223 3.443038 7.67797474 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 58.4 4.26e-4   NTclustered gi|2919551746|emb|OZ238362.1| 1002887 g6946 i0 100 0.547085201793722 31 0 14 0 167 197 8759730 8759700 Glaucopsyche melanops genome assembly, chromosome: 21 blastn 122 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
9482555 9482555 PRJNA564810_S_NODE_788_length_433_cov_4.793478_g766_i0 PRJNA564810 788 433 4.793478 20.75575974 Drymonia dodonaea 988176 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|2918369734|emb|OZ237800.1| 988176 g766 i0 87.755 0.113163972286374 49 2 11 4 80 126 10958829 10958875 Drymonia dodonaea genome assembly, chromosome: 7 blastn 49 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
10062085 10062085 PRJNA564810_S_NODE_8668_length_200_cov_3.051852_g8646_i0 PRJNA564810 8668 200 3.051852 6.103704 Hymenoptera 7399 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1697933262|ref|XM_029807451.1| 72781 g8646 i0 94.444 1.075 36 0 17 2 42 75 282 317 PREDICTED: Formica exsecta PDZ and LIM domain protein 3-like (LOC115235565), transcript variant X8, mRNA blastn 215 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Formica Formica exsecta
10758534 10758534 PRJNA564810_S_NODE_1429_length_367_cov_1.748344_g1407_i0 PRJNA564810 1429 367 1.748344 6.41642248 Timema bartmani 61472 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1946277321|emb|OD564907.1| 61472 g1407 i0 96.97 1.19891008174387 33 0 9 1 173 205 84848 84817 4_Tbi_b3v08 blastn 440 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
13308245 13308245 PRJNA564810_S_NODE_9031_length_189_cov_4.120968_g9009_i0 PRJNA564810 9031 189 4.120968 7.78862952 Tetranychus urticae 32264 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1390660955|ref|XR_003083641.1| 32264 g9009 i0 100 0.153439153439153 29 0 15 0 6 34 356 384 PREDICTED: Tetranychus urticae uncharacterized LOC112539673 (LOC112539673), ncRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
13887486 13887486 PRJNA564810_S_NODE_9371_length_178_cov_4.176991_g9349_i0 PRJNA564810 9371 178 4.176991 7.43504398 Metazoa 33208 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1832334880|gb|MK599468.1| 6687 g9349 i0 90.476 0.713483146067416 42 3 24 1 137 178 127 87 Penaeus monodon C-type lectin mRNA, complete cds blastn 127 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
15856841 15856841 PRJNA564810_S_NODE_1753_length_348_cov_1.441696_g1731_i0 PRJNA564810 1753 348 1.441696 5.01710208 Bombus monticola 103936 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2919521762|emb|OZ238323.1| 103936 g1731 i0 100 0.0804597701149425 28 0 8 0 18 45 13019317 13019290 Bombus monticola genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus monticola
15856842 15856842 PRJNA564810_S_NODE_2013_length_336_cov_5.011070_g1991_i0 PRJNA564810 2013 336 5.01107 16.8371952 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1184387702|emb|LT835105.1| 85552 g1991 i0 100 0.169642857142857 29 0 9 0 1 29 6 34 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
17131879 17131879 PRJNA564810_S_NODE_4674_length_259_cov_2.855670_g4652_i0 PRJNA564810 4674 259 2.85567 7.3961853 Pseudomyrmex gracilis 219809 Arthropoda Arthropoda 87.9 6.47e-13   NTclustered gi|1153829112|ref|XM_020435398.1| 219809 g4652 i0 85.714 1.68725868725869 84 11 32 1 98 181 990 908 PREDICTED: Pseudomyrmex gracilis parkin coregulated gene protein homolog (LOC109858297), mRNA blastn 437 87.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Pseudomyrmex Pseudomyrmex gracilis
18406214 18406214 PRJNA564810_S_NODE_7875_length_214_cov_1.610738_g7853_i0 PRJNA564810 7875 214 1.610738 3.44697932 Drosophila melanogaster 7227 Arthropoda Arthropoda 392 9.78e-105   NTclustered gi|18463988|gb|AC023687.3| 7227 g7853 i0 100 39.8644859813084 212 0 99 0 3 214 80340 80551 Drosophila melanogaster X BAC RP98-36C7 (Roswell Park Cancer Institute Drosophila BAC Library) complete sequence blastn 8531 392 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
19680657 19680657 PRJNA564810_S_NODE_5076_length_252_cov_4.732620_g5054_i0 PRJNA564810 5076 252 4.73262 11.9262024 Eriocheir sinensis 95602 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2312009663|ref|XM_050841844.1| 95602 g5054 i0 100 0.222222222222222 28 0 11 0 225 252 46 73 PREDICTED: Eriocheir sinensis tyrosine-protein phosphatase non-receptor type 14-like (LOC126986119), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
22231267 22231267 PRJNA564810_S_NODE_1818_length_345_cov_5.314286_g1796_i0 PRJNA564810 1818 345 5.314286 18.3342867 Timema cristinae 61476 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1947022213|emb|OC319580.1| 61476 g1796 i0 90.698 0.28695652173913 43 3 12 1 13 54 81050 81008 3_Tce_b3v08 blastn 99 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
23506507 23506507 PRJNA564810_S_NODE_4299_length_267_cov_1.767327_g4277_i0 PRJNA564810 4299 267 1.767327 4.71876309 Homarus americanus 6706 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2068691368|ref|XM_042382200.1| 6706 g4277 i0 100 0.104868913857678 28 0 10 0 237 264 906 933 PREDICTED: Homarus americanus myb-like protein P (LOC121876795), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
24780397 24780397 PRJNA564810_S_NODE_2580_length_312_cov_3.348178_g2558_i0 PRJNA564810 2580 312 3.348178 10.44631536 Timema douglasi 61478 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|1936955029|emb|OA567843.1| 61478 g2558 i0 100 0.0897435897435897 28 0 9 0 260 287 62234 62261 1_Tdi_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi

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