RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1098727" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1098727 · 17 ✖
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
211126 211126 PRJNA1098727_P_NODE_8821_length_206_cov_2.146497_g8580_i0 PRJNA1098727 8821 206 2.146497 4.42178382 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|1963343435|emb|OE839246.1| 629358 g8580 i0 100 0.135922330097087 28 0 14 0 132 159 460377 460350 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
4037842 4037842 PRJNA1098727_P_NODE_5664_length_266_cov_2.589862_g5423_i0 PRJNA1098727 5664 266 2.589862 6.88903292 Medioppia subpectinata 1979941 Arthropoda Arthropoda 60.2 1.45e-4   NTclustered gi|1962536607|emb|OC867504.1| 1979941 g5423 i0 100 0.120300751879699 32 0 12 0 41 72 713 744 Medioppia subpectinata blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
7397637 7397637 PRJNA1098727_P_NODE_8346_length_213_cov_1.792683_g8105_i0 PRJNA1098727 8346 213 1.792683 3.81841479 Entomobryidae 48704 Arthropoda Arthropoda 385 1.63e-102   NTclustered gi|472455922|gb|KC236276.1| 247613 g8105 i0 99.526 99.0610328638498 211 1 99 0 2 212 63 273 Entomobrya multifasciata 28S ribosomal RNA gene, partial sequence blastn 21100 385 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Entomobryidae Entomobrya Entomobrya multifasciata
10414468 10414468 PRJNA1098727_P_NODE_10729_length_185_cov_1.323529_g10488_i0 PRJNA1098727 10729 185 1.323529 2.44852865 Calliphora vicina 7373 Arthropoda Arthropoda 333 5.039999999999999e-87   NTclustered gi|2736847456|ref|XR_010576760.1| 7373 g10488 i0 99.454 98.9243243243243 183 1 99 0 2 184 1498 1680 PREDICTED: Calliphora vicina large subunit ribosomal RNA (LOC135962921), rRNA blastn 18301 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
12498651 12498651 PRJNA1098727_P_NODE_9930_length_192_cov_2.300699_g9689_i0 PRJNA1098727 9930 192 2.300699 4.41734208 Chironomus 7150 Arthropoda Arthropoda 337 4.079999999999999e-88   NTclustered gi|2485418712|gb|OQ813480.1| 7152 g9689 i0 98.429 23.6458333333333 191 3 99 0 1 191 1799 1609 Chironomus sp. isolate OVO4158 small subunit ribosomal RNA gene, partial sequence blastn 4540 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
12964960 12964960 PRJNA1098727_P_NODE_3551_length_354_cov_2.777049_g3310_i0 PRJNA1098727 3551 354 2.777049 9.83075346 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g3310 i0 100 0.0819209039548023 29 0 8 0 198 226 14100628 14100600 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
15513733 15513733 PRJNA1098727_P_NODE_14513_length_165_cov_0.896552_g14272_i0 PRJNA1098727 14513 165 0.896552 1.4793108 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 276 7.52e-70   NTclustered gi|2492451122|ref|XM_055442423.1| 263140 g14272 i0 97.546 3.95151515151515 163 1 99 3 1 163 1374 1533 PREDICTED: Sitodiplosis mosellana protein nubbin-like (LOC129566467), transcript variant X1, mRNA blastn 652 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
16788241 16788241 PRJNA1098727_P_NODE_2274_length_456_cov_9.901720_g2037_i0 PRJNA1098727 2274 456 9.90172 45.1518432 Bombyx mori 7091 Arthropoda Arthropoda 60.2 2.64e-4   NTclustered gi|2919985619|emb|OZ208592.1| 7091 g2037 i0 97.143 0.0767543859649123 35 1 8 0 89 123 8289332 8289298 Bombyx mori genome assembly, chromosome: 14 blastn 35 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
17597535 17597535 PRJNA1098727_P_NODE_10774_length_184_cov_2.577778_g10533_i0 PRJNA1098727 10774 184 2.577778 4.74311152 Pacifastacus 6719 Arthropoda Arthropoda 91.6 3.33e-14   NTclustered gi|2791117549|gb|PQ217112.1| 6720 g10533 i0 85.882 16.6467391304348 85 12 46 0 3 87 85 1 Pacifastacus leniusculus isolate F126749 histone 3 (H3) gene, partial cds blastn 3063 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Astacidae Pacifastacus Pacifastacus leniusculus
18871405 18871405 PRJNA1098727_P_NODE_16135_length_159_cov_2.081818_g15894_i0 PRJNA1098727 16135 159 2.081818 3.31009062 Aphididae 27482 Arthropoda Arthropoda 279 5.55e-71   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g15894 i0 98.726 95.5283018867924 157 2 99 0 2 158 3937 3781 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 15189 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
21887893 21887893 PRJNA1098727_P_NODE_10738_length_185_cov_1.183824_g10497_i0 PRJNA1098727 10738 185 1.183824 2.1900744 Atrichopogon sp. MAB-2008 560259 Arthropoda Arthropoda 333 5.039999999999999e-87   NTclustered gi|202070936|gb|FJ040575.1| 560259 g10497 i0 99.454 98.9351351351351 183 1 99 0 2 184 2740 2922 Atrichopogon sp. MAB-2008 28S ribosomal RNA gene, partial sequence blastn 18303 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Atrichopogon Atrichopogon sp. MAB-2008
21887917 21887917 PRJNA1098727_P_NODE_14918_length_164_cov_0.904348_g14677_i0 PRJNA1098727 14918 164 0.904348 1.48313072 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 113 6.1900000000000006e-21   NTclustered gi|2492499657|ref|XM_055464371.1| 263140 g14677 i0 81.366 0.981707317073171 161 11 98 12 2 162 420 561 PREDICTED: Sitodiplosis mosellana probable basic-leucine zipper transcription factor E (LOC129577404), mRNA blastn 161 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
23972103 23972103 PRJNA1098727_P_NODE_13619_length_167_cov_0.881356_g13378_i0 PRJNA1098727 13619 167 0.881356 1.47186452 Baetidae 172515 Arthropoda Arthropoda 296 5.86e-76   NTclustered gi|22854858|gb|AF461248.1| 197117 g13378 i0 98.795 99.5508982035928 166 2 99 0 2 167 315 150 Baetis buceratus 18S ribosomal RNA gene, partial sequence blastn 16625 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Baetis Baetis buceratus
24437004 24437004 PRJNA1098727_P_NODE_2840_length_403_cov_3.593220_g2599_i0 PRJNA1098727 2840 403 3.59322 14.4806766 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.039   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g2599 i0 100 0.0694789081885856 28 0 7 0 72 99 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
26995446 26995446 PRJNA1098727_P_NODE_10522_length_187_cov_1.318841_g10281_i0 PRJNA1098727 10522 187 1.318841 2.46623267 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.1 5.46e-21   NR XP_054270932.1 74068 g10281 i0 74.5 24.1122994652406 47 12 75.4 0 3 143 117 163 XP_054270932.1 adenosine 5'-monophosphoramidase HINT1-like isoform X1 [Macrosteles quadrilineatus] diamond 4509 90.9 0.991199119911991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
28520483 28520483 PRJNA1098727_P_NODE_6467_length_246_cov_1.563452_g6226_i0 PRJNA1098727 6467 246 1.563452 3.84609192 Daphnia magna 35525 Arthropoda Arthropoda 40.4 0.0401   NR KZR97555.1 35525 g6226 i0 73.9 0.280487804878049 23 6 28 0 210 142 2 24 KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] diamond 69 40.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
32312579 32312579 PRJNA1098727_P_NODE_13119_length_168_cov_0.873950_g12878_i0 PRJNA1098727 13119 168 0.87395 1.468236 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 114 8.280000000000001e-29   NR XP_055305540.1 263140 g12878 i0 90.9 0.982142857142857 55 5 98.2 0 2 166 229 283 XP_055305540.1 venom protease-like isoform X2 [Sitodiplosis mosellana] diamond 165 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana

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