RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA722925" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA722925 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
3745443 3745443 PRJNA722925_S_NODE_5403_length_196_cov_1.962264_g5340_i0 PRJNA722925 5403 196 1.962264 3.84603744 Insecta 50557 Arthropoda Arthropoda 91.6 3.59e-14   NTclustered gi|2883230352|dbj|AP038906.1| 63990 g5340 i0 90 8.60204081632653 70 7 36 0 127 196 10256229 10256298 Samia ricini White GU1 DNA, chromosome 11, nearly complete sequence blastn 1686 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
4538677 4538677 PRJNA722925_S_NODE_8024_length_169_cov_1.939394_g7961_i0 PRJNA722925 8024 169 1.939394 3.27757586 Cydia pomonella 82600 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g7961 i0 100 0.331360946745562 28 0 17 0 39 66 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
4538680 4538680 PRJNA722925_S_NODE_8404_length_166_cov_2.984496_g8341_i0 PRJNA722925 8404 166 2.984496 4.95426336 Glossina morsitans 7394 Arthropoda Arthropoda 307 2.69e-79   NTclustered gi|408716496|gb|JQ246760.1| 7394 g8341 i0 100 93.0542168674699 166 0 100 0 1 166 446 281 Glossina morsitans isolate D55 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 15447 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
5021951 5021951 PRJNA722925_S_NODE_1724_length_326_cov_52.442907_g1661_i0 PRJNA722925 1724 326 52.442907 170.96387682 root 1 Root_unresolved Root_unresolved 553 6.889999999999998e-153   NTclustered gi|83281396|gb|AC167967.6| 7176 g1661 i0 97.239 164 326 9 100 0 1 326 446 121 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence blastn 53464 558 0.991039426523297 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
5813873 5813873 PRJNA722925_S_NODE_9765_length_158_cov_1.710744_g9702_i0 PRJNA722925 9765 158 1.710744 2.70297552 Glossina morsitans 7394 Arthropoda Arthropoda 287 3.29e-73   NTclustered gi|9651983|gb|AF252868.1| 37546 g9702 i0 100 5.9620253164557 155 0 98 0 3 157 668 514 Glossina morsitans morsitans chymotrypsin-like serine protease precursor, mRNA, complete cds blastn 942 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
7089050 7089050 PRJNA722925_S_NODE_2886_length_258_cov_2.533937_g2823_i0 PRJNA722925 2886 258 2.533937 6.53755746 Glossina morsitans 7394 Arthropoda Arthropoda 477 3.2699999999999985e-130   NTclustered gi|3265161|gb|AF072373.1|AF072373 37546 g2823 i0 100 98.9186046511628 258 0 100 0 1 258 777 520 Glossina morsitans morsitans 16S ribosomal RNA gene, mitochondrial gene for mitochondrial RNA, partial sequence blastn 25521 477 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
7089081 7089081 PRJNA722925_S_NODE_8326_length_167_cov_1.500000_g8263_i0 PRJNA722925 8326 167 1.5 2.505 Satyrium ilicis 876074 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918386102|emb|OZ238122.1| 876074 g8263 i0 100 0.173652694610778 29 0 17 0 19 47 39733143 39733171 Satyrium ilicis genome assembly, chromosome: 13 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
8363565 8363565 PRJNA722925_S_NODE_427_length_624_cov_3.863714_g374_i0 PRJNA722925 427 624 3.863714 24.10957536 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.005   NTclustered gi|1965181363|emb|OE475415.1| 61474 g374 i0 90.909 0.0705128205128205 44 1 7 2 323 363 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
10122243 10122243 PRJNA722925_S_NODE_6328_length_184_cov_1.367347_g6265_i0 PRJNA722925 6328 184 1.367347 2.51591848 Insecta 50557 Arthropoda Arthropoda 158 3.23e-34   NTclustered gi|1896444337|gb|MT921238.1| 2766959 g6265 i0 82.323 67.804347826087 198 19 100 9 1 184 2476 2281 Chironomidae sp. Cy2020 sp1 voucher Chironomidae_Cy2020_sp1 large subunit ribosomal RNA gene, partial sequence blastn 12476 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae   Chironomidae sp. Cy2020 sp1
12189595 12189595 PRJNA722925_S_NODE_7450_length_173_cov_3.154412_g7387_i0 PRJNA722925 7450 173 3.154412 5.45713276 Agapeta hamana 1100904 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918369793|emb|OZ237860.1| 1100904 g7387 i0 100 0.346820809248555 30 0 17 0 18 47 9630668 9630697 Agapeta hamana genome assembly, chromosome: 1 blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
12673299 12673299 PRJNA722925_S_NODE_3550_length_235_cov_2.181818_g3487_i0 PRJNA722925 3550 235 2.181818 5.1272723 Artemia 6660 Arthropoda Arthropoda 435 1.79e-117   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g3487 i0 100 26.5531914893617 235 0 100 0 1 235 2401 2167 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 6240 435 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
13947533 13947533 PRJNA722925_S_NODE_5291_length_198_cov_1.285714_g5228_i0 PRJNA722925 5291 198 1.285714 2.54571372 Drosophila 7215 Arthropoda Arthropoda 58.4 3.69e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g5228 i0 100 2.72222222222222 31 0 16 0 133 163 107 77 PREDICTED: Drosophila nasuta potassium voltage-gated channel protein Shaker (LOC132796862), transcript variant X2, mRNA blastn 539 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
16012785 16012785 PRJNA722925_S_NODE_3353_length_241_cov_1.607843_g3290_i0 PRJNA722925 3353 241 1.607843 3.87490163 Glossina morsitans 7394 Arthropoda Arthropoda 433 6.63e-117   NTclustered gi|9651983|gb|AF252868.1| 37546 g3290 i0 99.167 6.76348547717842 240 2 99 0 1 240 918 679 Glossina morsitans morsitans chymotrypsin-like serine protease precursor, mRNA, complete cds blastn 1630 433 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
21112846 21112846 PRJNA722925_S_NODE_10257_length_156_cov_0.983193_g10194_i0 PRJNA722925 10257 156 0.983193 1.53378108 Euproctis chrysorrhoea 987934 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918370018|emb|OZ237905.1| 987934 g10194 i0 96.97 0.211538461538462 33 0 21 1 12 44 37255577 37255546 Euproctis chrysorrhoea genome assembly, chromosome: 1 blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Euproctis Euproctis chrysorrhoea
21112885 21112885 PRJNA722925_S_NODE_8657_length_165_cov_0.914062_g8594_i0 PRJNA722925 8657 165 0.914062 1.5082023 Cyclops abyssorum 595358 Arthropoda Arthropoda 104 3.76e-18   NTclustered gi|984294732|gb|KP772895.1| 595358 g8594 i0 95.455 14.8969696969697 66 2 40 1 97 162 323 259 Cyclops abyssorum isolate Y43 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 2458 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Cyclopoida Cyclopidae Cyclops Cyclops abyssorum
21595855 21595855 PRJNA722925_S_NODE_1317_length_369_cov_2.584337_g1254_i0 PRJNA722925 1317 369 2.584337 9.53620353 Artemia 6660 Arthropoda Arthropoda 682 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1254 i0 100 97.8211382113821 369 0 100 0 1 369 2174 1806 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 36096 682 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22387721 22387721 PRJNA722925_S_NODE_6878_length_179_cov_1.098592_g6815_i0 PRJNA722925 6878 179 1.098592 1.96647968 Glossina morsitans 7394 Arthropoda Arthropoda 331 1.74e-86   NTclustered gi|182676657|gb|EU589384.1| 37546 g6815 i0 100 2 179 0 100 0 1 179 530 708 Glossina morsitans morsitans trypsin-like protein (try1) mRNA, complete cds blastn 358 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans
24936788 24936788 PRJNA722925_S_NODE_3440_length_238_cov_2.353234_g3377_i0 PRJNA722925 3440 238 2.353234 5.60069692 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2919569340|emb|OZ238378.1| 204503 g3377 i0 100 0.117647058823529 28 0 12 0 21 48 22290739 22290712 Charissa obscurata genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
24936800 24936800 PRJNA722925_S_NODE_5680_length_192_cov_2.754839_g5617_i0 PRJNA722925 5680 192 2.754839 5.28929088 Glossina morsitans 7394 Arthropoda Arthropoda 355 1.13e-93   NTclustered gi|3265161|gb|AF072373.1|AF072373 37546 g5617 i0 100 93.1875 192 0 100 0 1 192 1083 1274 Glossina morsitans morsitans 16S ribosomal RNA gene, mitochondrial gene for mitochondrial RNA, partial sequence blastn 17892 355 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina morsitans

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