RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA811714" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA811714 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
3360617 3360617 PRJNA811714_P_NODE_6523_length_360_cov_12.020906_g6332_i0 PRJNA811714 6523 360 12.020906 43.2752616 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g6332 i0 100 3.84166666666667 30 0 8 0 54 83 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
5051734 5051734 PRJNA811714_P_NODE_6084_length_370_cov_13.272727_g5893_i0 PRJNA811714 6084 370 13.272727 49.1090899 Timema 61471 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|1936955213|emb|OA567898.1| 61478 g5893 i0 100 0.227027027027027 28 0 8 0 315 342 49375 49402 1_Tdi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
7187789 7187789 PRJNA811714_P_NODE_30646_length_209_cov_4.058824_g30453_i0 PRJNA811714 30646 209 4.058824 8.48294216 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918386103|emb|OZ238124.1| 876074 g30453 i0 96.97 1.49760765550239 33 1 16 0 164 196 27495834 27495866 Satyrium ilicis genome assembly, chromosome: 15 blastn 313 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
13562999 13562999 PRJNA811714_P_NODE_26011_length_230_cov_2.923567_g25818_i0 PRJNA811714 26011 230 2.923567 6.7242041 Euwallacea similis 1736056 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2770102028|ref|XM_066401780.1| 1736056 g25818 i0 100 0.121739130434783 28 0 12 0 35 62 14 41 PREDICTED: Euwallacea similis maleless (mle), transcript variant X2, mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea similis
13977510 13977510 PRJNA811714_P_NODE_16391_length_261_cov_4.819149_g16198_i0 PRJNA811714 16391 261 4.819149 12.57797889 Aphididae 27482 Arthropoda Arthropoda 472 1.54e-128   NTclustered gi|886117|gb|U27819.1|APU27819 7029 g16198 i0 99.234 81.3563218390805 261 2 100 0 1 261 298 38 Acyrthosiphon pisum 18S ribosomal RNA gene blastn 21234 472 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
14837203 14837203 PRJNA811714_P_NODE_11992_length_287_cov_2.158879_g11799_i0 PRJNA811714 11992 287 2.158879 6.19598273 Oppiella nova 334625 Arthropoda Arthropoda 486 6.139999999999999e-133   NTclustered gi|1964807365|emb|OC914831.1| 334625 g11799 i0 100 8.76306620209059 263 0 92 0 1 263 12303 12565 Oppiella nova blastn 2515 486 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
15251758 15251758 PRJNA811714_P_NODE_29172_length_217_cov_6.354167_g28979_i0 PRJNA811714 29172 217 6.354167 13.78854239 Speleorchestes 386823 Arthropoda Arthropoda 100 6.75e-17   NTclustered gi|1282187772|gb|KY921977.1| 2051766 g28979 i0 87.5 41.3594470046083 88 9 41 2 2 89 1288 1203 Speleorchestes sp. AD937 voucher UMMZ BMOC 07-0814-002 AD937 28S ribosomal RNA gene, partial sequence blastn 8975 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD937
19935582 19935582 PRJNA811714_P_NODE_10076_length_306_cov_3.965665_g9883_i0 PRJNA811714 10076 306 3.965665 12.1349349 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g9883 i0 100 0.0915032679738562 28 0 9 0 57 84 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
19936384 19936384 PRJNA811714_P_NODE_6456_length_362_cov_7.318339_g6265_i0 PRJNA811714 6456 362 7.318339 26.49238718 Bombyx mori 7091 Arthropoda Arthropoda 60.2 2.05e-4   NTclustered gi|2919985619|emb|OZ208592.1| 7091 g6265 i0 97.143 0.0966850828729282 35 1 10 0 73 107 8289332 8289298 Bombyx mori genome assembly, chromosome: 14 blastn 35 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
21211600 21211600 PRJNA811714_P_NODE_26317_length_229_cov_2.961538_g26124_i0 PRJNA811714 26317 229 2.961538 6.78192202 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g26124 i0 100 0.122270742358079 28 0 12 0 87 114 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
23761998 23761998 PRJNA811714_P_NODE_26659_length_228_cov_2.980645_g26466_i0 PRJNA811714 26659 228 2.980645 6.7958706 Teleiodes vulgella 1594352 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2918369900|emb|OZ237924.1| 1594352 g26466 i0 100 0.12280701754386 28 0 12 0 154 181 6857835 6857808 Teleiodes vulgella genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella

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