RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA772154 · 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
2482215 2482215 PRJNA772154_P_NODE_18022_length_252_cov_0.871508_g17837_i0 PRJNA772154 18022 252 0.871508 2.19620016 Aphididae 27482 Arthropoda Arthropoda 453 5.36e-123   NTclustered gi|1685547360|ref|XM_016801960.2| 7029 g17837 i0 99.203 9.96031746031746 251 2 99 0 2 252 2480 2230 PREDICTED: Acyrthosiphon pisum symplekin (LOC100168598), transcript variant X2, mRNA blastn 2510 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
3298370 3298370 PRJNA772154_P_NODE_12403_length_315_cov_1.603306_g12218_i0 PRJNA772154 12403 315 1.603306 5.0504139 Bombyx mori 7091 Arthropoda Arthropoda 582 8.459999999999998e-162   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g12218 i0 100 501.409523809524 315 0 100 0 1 315 4405800 4405486 Bombyx mori genome assembly, chromosome: 11 blastn 157944 582 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
7125840 7125840 PRJNA772154_P_NODE_10466_length_351_cov_1.323741_g10281_i0 PRJNA772154 10466 351 1.323741 4.64633091 Penaeus vannamei 6689 Arthropoda Arthropoda 549 9.649999999999996e-152   NTclustered gi|19850477|gb|AF360058.1| 6689 g10281 i0 95.157 103.920227920228 351 12 100 1 1 351 429 84 Penaeus (Litopenaeus) vannamei microsatellite TUMXLv8.11 sequence blastn 36476 549 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
7126075 7126075 PRJNA772154_P_NODE_18826_length_250_cov_1.322034_g18641_i0 PRJNA772154 18826 250 1.322034 3.305085 Anarta stigmosa 1869462 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918376415|emb|OZ237984.1| 1869462 g18641 i0 100 0.564 29 0 12 0 22 50 8622709 8622737 Anarta stigmosa genome assembly, chromosome: 8 blastn 141 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
7126129 7126129 PRJNA772154_P_NODE_20766_length_246_cov_0.901734_g20581_i0 PRJNA772154 20766 246 0.901734 2.21826564 Nasonia vitripennis 7425 Arthropoda Arthropoda 438 1.4599999999999996e-118   NTclustered gi|1815695678|ref|XM_001606623.6| 7425 g20581 i0 98.78 43.4634146341463 246 3 100 0 1 246 476 231 PREDICTED: Nasonia vitripennis ADP,ATP carrier protein 2 (LOC100117058), mRNA blastn 10692 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
7584845 7584845 PRJNA772154_P_NODE_15146_length_279_cov_1.135922_g14961_i0 PRJNA772154 15146 279 1.135922 3.16922238 Centruroides 6875 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2786501866|ref|XM_067269107.1| 120091 g14961 i0 100 0.301075268817204 28 0 10 0 84 111 369 396 PREDICTED: Centruroides vittatus RWD domain-containing protein 2A (LOC136974270), mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
8400491 8400491 PRJNA772154_P_NODE_14927_length_281_cov_2.173077_g14742_i0 PRJNA772154 14927 281 2.173077 6.10634637 Apocrypta bakeri 490712 Arthropoda Arthropoda 361 3.789999999999999e-95   NTclustered gi|1999894537|gb|MT906648.2| 490712 g14742 i0 91.144 97.0142348754448 271 17 94 4 17 281 1649 1918 Apocrypta bakeri mitochondrion, partial genome blastn 27261 361 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Apocrypta Apocrypta bakeri
8859999 8859999 PRJNA772154_P_NODE_2087_length_999_cov_3.690065_g1947_i0 PRJNA772154 2087 999 3.690065 36.86374935 Arachnida 6854 Arthropoda Arthropoda 172 7.45e-38   NTclustered gi|56968012|gb|AY859558.1| 307027 g1947 i0 93.913 12.1561561561562 115 6 12 1 202 316 2962 2849 Calocheiridius cf. termitophilus JM-2004 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12144 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Olpiidae Calocheiridius Calocheiridius cf. termitophilus JM-2004
10951443 10951443 PRJNA772154_P_NODE_18389_length_251_cov_0.876404_g18204_i0 PRJNA772154 18389 251 0.876404 2.19977404 Nasonia vitripennis 7425 Arthropoda Arthropoda 254 5.81e-63   NTclustered gi|1815723786|ref|XM_008218381.4| 7425 g18204 i0 85.603 7.99601593625498 257 19 98 12 3 247 1185 1435 PREDICTED: Nasonia vitripennis alpha-crystallin A chain (LOC100118750), transcript variant X1, mRNA blastn 2007 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
10951520 10951520 PRJNA772154_P_NODE_21369_length_245_cov_0.906977_g21184_i0 PRJNA772154 21369 245 0.906977 2.22209365 Drosophila melanogaster 7227 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|113206010|gb|AC018491.10| 7227 g21184 i0 100 0.114285714285714 28 0 11 0 43 70 73700 73727 Drosophila melanogaster clone BACR11H15, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
16050066 16050066 PRJNA772154_P_NODE_22573_length_242_cov_1.337278_g22388_i0 PRJNA772154 22573 242 1.337278 3.23621276 Eurosta solidaginis 178769 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2792525481|ref|XM_067792421.1| 178769 g22388 i0 100 0.694214876033058 28 0 12 0 62 89 1221 1194 PREDICTED: Eurosta solidaginis putative phosphatidate phosphatase (LOC137254618), transcript variant X1, mRNA blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Eurosta Eurosta solidaginis
17325735 17325735 PRJNA772154_P_NODE_20494_length_247_cov_0.896552_g20309_i0 PRJNA772154 20494 247 0.896552 2.21448344 Phymastichus coffea 108790 Arthropoda Arthropoda 78.7 3.68e-10   NTclustered gi|2563674860|ref|XM_058939743.1| 108790 g20309 i0 95.833 0.194331983805668 48 2 19 0 82 129 117 164 PREDICTED: Phymastichus coffea coiled-coil-helix-coiled-coil-helix domain-containing protein 10, mitochondrial (LOC131666806), mRNA blastn 48 78.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eulophidae Phymastichus Phymastichus coffea
21608992 21608992 PRJNA772154_P_NODE_23077_length_232_cov_2.421384_g22892_i0 PRJNA772154 23077 232 2.421384 5.61761088 Bombyx 7090 Arthropoda Arthropoda 429 8.2e-116   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g22892 i0 100 256.73275862069 232 0 100 0 1 232 4405002 4404771 Bombyx mori genome assembly, chromosome: 11 blastn 59562 429 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
23700541 23700541 PRJNA772154_P_NODE_6379_length_487_cov_1.074879_g6194_i0 PRJNA772154 6379 487 1.074879 5.23466073 Samia ricini 63990 Arthropoda Arthropoda 52.8 0.047   NTclustered gi|2883230424|dbj|AP038907.1| 63990 g6194 i0 100 0.0574948665297741 28 0 6 0 451 478 4969471 4969498 Samia ricini White GU1 DNA, chromosome 12, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
24973971 24973971 PRJNA772154_P_NODE_18980_length_250_cov_0.881356_g18795_i0 PRJNA772154 18980 250 0.881356 2.20339 Sycoscapter sp. 1070933 Arthropoda Arthropoda 440 4.1399999999999976e-119   NTclustered gi|2307875748|gb|OP498195.1| 1070933 g18795 i0 100 94.632 238 0 95 0 1 238 238 1 Sycoscapter sp. voucher Sy_xiao_2 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial blastn 23658 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Sycoscapter Sycoscapter sp.

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