RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA1111082" 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

  • PRJNA1111082 · 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
4042207 4042207 PRJNA1111082_P_NODE_5704_length_332_cov_1.189189_g5659_i0 PRJNA1111082 5704 332 1.189189 3.94810748 Nilaparvata lugens 108931 Arthropoda Arthropoda 608 1.479999999999999e-169   NTclustered gi|1150080525|gb|KC223380.1| 108931 g5659 i0 99.699 90.8012048192771 332 1 100 0 1 332 1327 996 Nilaparvata lugens putative glutamine synthetase mRNA, complete cds blastn 30146 608 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
4042210 4042210 PRJNA1111082_P_NODE_5884_length_327_cov_2.330709_g5839_i0 PRJNA1111082 5884 327 2.330709 7.62141843 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2918376580|emb|OZ238010.1| 307131 g5839 i0 100 0.0856269113149847 28 0 9 0 87 114 48352387 48352360 Ceutorhynchus obstrictus genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
5318220 5318220 PRJNA1111082_P_NODE_3085_length_436_cov_1.327824_g3040_i0 PRJNA1111082 3085 436 1.327824 5.78931264 Nilaparvata lugens 108931 Arthropoda Arthropoda 800 0   NTclustered gi|1150080581|gb|KC223412.1| 108931 g3040 i0 99.771 199.894495412844 436 1 100 0 1 436 559 124 Nilaparvata lugens putative D-3-phosphoglycerate dehydrogenase mRNA, complete cds blastn 87154 800 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
6593593 6593593 PRJNA1111082_P_NODE_9266_length_267_cov_1.525773_g9221_i0 PRJNA1111082 9266 267 1.525773 4.07381391 Nilaparvata lugens 108931 Arthropoda Arthropoda 494 3.38e-135   NTclustered gi|1150080525|gb|KC223380.1| 108931 g9221 i0 100 3.59925093632959 267 0 100 0 1 267 5377 5111 Nilaparvata lugens putative glutamine synthetase mRNA, complete cds blastn 961 494 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
7867993 7867993 PRJNA1111082_P_NODE_11647_length_247_cov_0.867816_g11602_i0 PRJNA1111082 11647 247 0.867816 2.14350552 Nilaparvata lugens 108931 Arthropoda Arthropoda 451 1.88e-122   NTclustered gi|1150080525|gb|KC223380.1| 108931 g11602 i0 99.595 61.1781376518219 247 1 100 0 1 247 1310 1556 Nilaparvata lugens putative glutamine synthetase mRNA, complete cds blastn 15111 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
11693983 11693983 PRJNA1111082_P_NODE_3670_length_403_cov_2.587879_g3625_i0 PRJNA1111082 3670 403 2.587879 10.42915237 Speleorchestes sp. AD1084 2051767 Arthropoda Arthropoda 104 1.05e-17   NTclustered gi|1282187773|gb|KY921978.1| 2051767 g3625 i0 83.478 4.00496277915633 115 16 28 3 72 183 2568 2454 Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence blastn 1614 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1084
11694111 11694111 PRJNA1111082_P_NODE_8330_length_281_cov_1.500000_g8285_i0 PRJNA1111082 8330 281 1.5 4.215 Nilaparvata lugens 108931 Arthropoda Arthropoda 520 5.909999999999999e-143   NTclustered gi|1150080567|gb|KC223403.1| 108931 g8285 i0 100 85.55871886121 281 0 100 0 1 281 1684 1964 Nilaparvata lugens putative dihydroxy-acid dehydratase mRNA, complete cds blastn 24042 520 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
12969368 12969368 PRJNA1111082_P_NODE_9391_length_265_cov_1.958333_g9346_i0 PRJNA1111082 9391 265 1.958333 5.18958245 Nilaparvata lugens 108931 Arthropoda Arthropoda 466 7.2999999999999995e-127   NTclustered gi|1150080525|gb|KC223380.1| 108931 g9346 i0 98.851 31.6867924528302 261 3 98 0 5 265 4826 5086 Nilaparvata lugens putative glutamine synthetase mRNA, complete cds blastn 8397 466 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
12969379 12969379 PRJNA1111082_P_NODE_9911_length_258_cov_1.681081_g9866_i0 PRJNA1111082 9911 258 1.681081 4.33718898 Timema douglasi 61478 Arthropoda Arthropoda 211 3.66e-50   NTclustered gi|1937117693|emb|OA852941.1| 61478 g9866 i0 89.412 2.63953488372093 170 14 65 4 83 249 4 172 1_Tdi_b3v08 blastn 681 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
14244116 14244116 PRJNA1111082_P_NODE_13112_length_215_cov_5.394366_g13067_i0 PRJNA1111082 13112 215 5.394366 11.5978869 Orthocladius sp. 3002598 Arthropoda Arthropoda 381 2.1299999999999996e-101   NTclustered gi|2486656231|gb|OQ819019.1| 3002598 g13067 i0 98.605 97.6883720930233 215 3 100 0 1 215 3705 3491 Orthocladius sp. isolate EAM591 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 21003 381 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Orthocladius Orthocladius sp.
14244305 14244305 PRJNA1111082_P_NODE_8052_length_285_cov_2.165094_g8007_i0 PRJNA1111082 8052 285 2.165094 6.1705179 Helicoverpa armigera 29058 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2020647502|gb|MT901197.1| 29058 g8007 i0 100 0.0982456140350877 28 0 10 0 1 28 1 28 Helicoverpa armigera sugar transporter 4 mRNA, complete cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
16792553 16792553 PRJNA1111082_P_NODE_6234_length_320_cov_1.145749_g6189_i0 PRJNA1111082 6234 320 1.145749 3.6663968 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1965181363|emb|OE475415.1| 61474 g6189 i0 90.909 0.1375 44 1 13 2 87 127 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
18067063 18067063 PRJNA1111082_P_NODE_6595_length_312_cov_5.288703_g6550_i0 PRJNA1111082 6595 312 5.288703 16.50075336 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 60.2 1.74e-4   NTclustered gi|2919538070|emb|OZ238348.1| 1002887 g6550 i0 97.222 0.307692307692308 36 0 12 1 24 59 23637999 23637965 Glaucopsyche melanops genome assembly, chromosome: 7 blastn 96 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
20616603 20616603 PRJNA1111082_P_NODE_7277_length_299_cov_2.703540_g7232_i0 PRJNA1111082 7277 299 2.70354 8.0835846 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1044897043|gb|KT223635.1| 354439 g7232 i0 100 0.0936454849498328 28 0 9 0 272 299 59 32 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
20616638 20616638 PRJNA1111082_P_NODE_8677_length_276_cov_1.152709_g8632_i0 PRJNA1111082 8677 276 1.152709 3.18147684 Nilaparvata lugens 108931 Arthropoda Arthropoda 510 3.48e-140   NTclustered gi|1150080581|gb|KC223412.1| 108931 g8632 i0 100 99.5905797101449 276 0 100 0 1 276 842 567 Nilaparvata lugens putative D-3-phosphoglycerate dehydrogenase mRNA, complete cds blastn 27487 510 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
21892240 21892240 PRJNA1111082_P_NODE_6938_length_306_cov_1.167382_g6893_i0 PRJNA1111082 6938 306 1.167382 3.57218892 Nilaparvata lugens 108931 Arthropoda Arthropoda 566 8.239999999999998e-157   NTclustered gi|1150080328|gb|KC223254.1| 108931 g6893 i0 100 76.1437908496732 306 0 100 0 1 306 298 603 Nilaparvata lugens putative aspartate aminotransferase mRNA, partial cds blastn 23300 566 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
23167580 23167580 PRJNA1111082_P_NODE_11279_length_248_cov_1.560000_g11234_i0 PRJNA1111082 11279 248 1.56 3.8688 Zerynthia rumina 132710 Arthropoda Arthropoda 67.6 8.01e-7   NTclustered gi|2918377984|emb|OZ238037.1| 132710 g11234 i0 91.667 2.84274193548387 48 4 19 0 119 166 10905568 10905615 Zerynthia rumina genome assembly, chromosome: 2 blastn 705 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
24441372 24441372 PRJNA1111082_P_NODE_8120_length_284_cov_1.734597_g8075_i0 PRJNA1111082 8120 284 1.734597 4.92625548 Nilaparvata lugens 108931 Arthropoda Arthropoda 525 1.2899999999999994e-144   NTclustered gi|1150080581|gb|KC223412.1| 108931 g8075 i0 100 97.887323943662 284 0 100 0 1 284 1442 1725 Nilaparvata lugens putative D-3-phosphoglycerate dehydrogenase mRNA, complete cds blastn 27800 525 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
25247672 25247672 PRJNA1111082_P_NODE_2560_length_471_cov_3.959799_g2515_i0 PRJNA1111082 2560 471 3.959799 18.65065329 Artemia 6660 Arthropoda Arthropoda 833 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g2515 i0 99.78 70.0106157112527 454 1 96 0 1 454 2019 2472 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 32975 833 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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