RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA930380 · 15 ✖

analysis 1

  • blastn · 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
2184744 2184744 PRJNA930380_P_NODE_2362_length_409_cov_0.907738_g2309_i0 PRJNA930380 2362 409 0.907738 3.71264842 Mythimna loreyi 667449 Arthropoda Arthropoda 750 0   NTclustered gi|2907536457|gb|OQ536314.1| 667449 g2309 i0 99.756 101.271393643032 409 1 100 0 1 409 13570 13162 Mythimna loreyi mitochondrion, complete genome blastn 41420 750 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna loreyi
4737835 4737835 PRJNA930380_P_NODE_5544_length_293_cov_2.800000_g5491_i0 PRJNA930380 5544 293 2.8 8.204 Aethina tumida 116153 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2284722076|ref|XM_049969690.1| 116153 g5491 i0 100 0.0955631399317406 28 0 10 0 148 175 1271 1298 PREDICTED: Aethina tumida polyadenylate-binding protein 2-like (LOC109597966), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
4737846 4737846 PRJNA930380_P_NODE_6864_length_287_cov_2.574766_g6811_i0 PRJNA930380 6864 287 2.574766 7.38957842 Polistes fuscatus 30207 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2093703405|ref|XR_006306076.1| 30207 g6811 i0 96.97 0.337979094076655 33 1 11 0 156 188 874 842 PREDICTED: Polistes fuscatus uncharacterized LOC122526487 (LOC122526487), ncRNA blastn 97 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes fuscatus
5083229 5083229 PRJNA930380_P_NODE_6484_length_289_cov_1.430556_g6431_i0 PRJNA930380 6484 289 1.430556 4.13430684 Lepidoptera 7088 Arthropoda Arthropoda 534 2.18e-147   NTclustered gi|2306717695|ref|XR_004783997.2| 7108 g6431 i0 100 355.294117647059 289 0 100 0 1 289 1934 2222 PREDICTED: Spodoptera frugiperda large subunit ribosomal RNA (LOC118279431), rRNA blastn 102680 534 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
6012609 6012609 PRJNA930380_P_NODE_1665_length_476_cov_1.146402_g1612_i0 PRJNA930380 1665 476 1.146402 5.45687352 Mythimna loreyi 667449 Arthropoda Arthropoda 880 0   NTclustered gi|2211246611|gb|MZ853169.1| 667449 g1612 i0 100 96.8844537815126 476 0 100 0 1 476 1706 2181 Mythimna loreyi mitochondrion, complete genome blastn 46117 880 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna loreyi
7287441 7287441 PRJNA930380_P_NODE_13906_length_242_cov_1.881657_g13853_i0 PRJNA930380 13906 242 1.881657 4.55360994 Apis mellifera 7460 Arthropoda Arthropoda 195 3.42e-45   NTclustered gi|1477716459|ref|XM_016915409.2| 7460 g13853 i0 82.949 24.4628099173554 217 35 89 2 13 228 1090 875 PREDICTED: Apis mellifera polyubiquitin-A (LOC412353), transcript variant X2, mRNA blastn 5920 195 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis mellifera
8562346 8562346 PRJNA930380_P_NODE_3827_length_332_cov_0.880309_g3774_i0 PRJNA930380 3827 332 0.880309 2.92262588 Eriocheir sinensis 95602 Arthropoda Arthropoda 193 1.77e-44   NTclustered gi|2311905309|ref|XM_050861973.1| 95602 g3774 i0 86.364 4.61144578313253 176 24 53 0 1 176 450 275 PREDICTED: Eriocheir sinensis 40S ribosomal protein S23 (LOC126999399), mRNA blastn 1531 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
9837442 9837442 PRJNA930380_P_NODE_7208_length_286_cov_1.375587_g7155_i0 PRJNA930380 7208 286 1.375587 3.93417882 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g7155 i0 100 0.0979020979020979 28 0 10 0 42 69 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
12388630 12388630 PRJNA930380_P_NODE_6990_length_287_cov_1.369159_g6937_i0 PRJNA930380 6990 287 1.369159 3.92948633 Mythimna loreyi 667449 Arthropoda Arthropoda 525 1.2999999999999995e-144   NTclustered gi|2091527325|ref|NC_057500.1| 667449 g6937 i0 99.652 100.04181184669 287 1 100 0 1 287 5270 4984 Mythimna loreyi strain 2019 NICS mitochondrion, complete genome blastn 28712 525 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna loreyi
16212208 16212208 PRJNA930380_P_NODE_10473_length_266_cov_1.481865_g10420_i0 PRJNA930380 10473 266 1.481865 3.9417609 Chelidurella thaleri 2546182 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919610373|emb|OZ238417.1| 2546182 g10420 i0 97.059 0.12781954887218 34 0 13 1 59 92 14169552 14169520 Chelidura thaleri genome assembly, chromosome: 18 blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
16212270 16212270 PRJNA930380_P_NODE_12813_length_246_cov_1.537572_g12760_i0 PRJNA930380 12813 246 1.537572 3.78242712 Episema korsakovi 1870626 Arthropoda Arthropoda 324 4.26e-84   NTclustered gi|2920003674|emb|OZ238888.1| 1870626 g12760 i0 92.14 2.78861788617886 229 18 93 0 18 246 6933457 6933229 Episema korsakovi genome assembly, chromosome: 12 blastn 686 324 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Episema Episema korsakovi
21311538 21311538 PRJNA930380_P_NODE_6197_length_290_cov_2.129032_g6144_i0 PRJNA930380 6197 290 2.129032 6.1741928 Euthrix potatoria 624169 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2918369988|emb|OZ237875.1| 624169 g6144 i0 100 0.1 29 0 10 0 134 162 17605492 17605464 Euthrix potatoria genome assembly, chromosome: 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
22586275 22586275 PRJNA930380_P_NODE_12198_length_249_cov_0.875000_g12145_i0 PRJNA930380 12198 249 0.875 2.17875 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g12145 i0 100 5.55421686746988 30 0 12 0 77 106 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
22586384 22586384 PRJNA930380_P_NODE_3778_length_333_cov_1.480769_g3725_i0 PRJNA930380 3778 333 1.480769 4.93096077 Galleria mellonella 7137 Arthropoda Arthropoda 309 1.6900000000000002e-79   NTclustered gi|2418168224|ref|XM_052895734.1| 7137 g3725 i0 84.566 11.7387387387387 311 48 93 0 23 333 675 365 PREDICTED: Galleria mellonella apolipophorin-3-like (LOC113516387), mRNA blastn 3909 309 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Galleria Galleria mellonella
23861803 23861803 PRJNA930380_P_NODE_9259_length_275_cov_3.891089_g9206_i0 PRJNA930380 9259 275 3.891089 10.70049475 Timema tahoe 61484 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1948414635|emb|OE000165.1| 61484 g9206 i0 100 0.101818181818182 28 0 10 0 64 91 127085 127112 4_Tte_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe

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