RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA771359" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA771359 · 22 ✖

analysis 1

  • blastn · 22 ✖
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
2023046 2023046 PRJNA771359_S_NODE_3162_length_189_cov_1.250000_g3079_i0 PRJNA771359 3162 189 1.25 2.3625 Timema tahoe 61484 Arthropoda Arthropoda 231 1.94e-56   NTclustered gi|1947912566|emb|OE096654.1| 61484 g3079 i0 91.379 0.920634920634921 174 8 90 5 8 178 67 236 4_Tte_b3v08 blastn 174 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
2023056 2023056 PRJNA771359_S_NODE_3722_length_174_cov_2.459854_g3639_i0 PRJNA771359 3722 174 2.459854 4.28014596 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 145 2.35e-30   NTclustered gi|2492504882|ref|XM_055466887.1| 263140 g3639 i0 82.353 4.07471264367816 170 26 97 4 5 172 450 617 PREDICTED: Sitodiplosis mosellana 40S ribosomal protein S2 (LOC129578395), transcript variant X1, mRNA blastn 709 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
3298209 3298209 PRJNA771359_S_NODE_1163_length_310_cov_2.432234_g1080_i0 PRJNA771359 1163 310 2.432234 7.5399254000000004 Timema tahoe 61484 Arthropoda Arthropoda 324 5.56e-84   NTclustered gi|1947899475|emb|OE095327.1| 61484 g1080 i0 99.438 0.574193548387097 178 1 57 0 133 310 374 197 4_Tte_b3v08 blastn 178 324 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
3298231 3298231 PRJNA771359_S_NODE_2283_length_222_cov_1.881081_g2200_i0 PRJNA771359 2283 222 1.881081 4.17599982 Lucilia cuprina 7375 Arthropoda Arthropoda 121 5.319999999999999e-23   NTclustered gi|2202997930|ref|XM_023452828.2| 7375 g2200 i0 83.333 7.88288288288288 138 15 59 5 88 219 292 157 PREDICTED: Lucilia cuprina 40S ribosomal protein S28 (LOC111690358), mRNA blastn 1750 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
3758513 3758513 PRJNA771359_S_NODE_4203_length_165_cov_1.210938_g4120_i0 PRJNA771359 4203 165 1.210938 1.9980477 root 1 Root_unresolved Root_unresolved 93.5 8.13e-15   NTclustered gi|68051678|gb|BT023703.1| 7227 g4120 i0 82.857 25.2909090909091 105 16 63 2 14 117 246 143 Drosophila melanogaster IP02950 full insert cDNA blastn 4173 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
4575302 4575302 PRJNA771359_S_NODE_1964_length_236_cov_4.407035_g1881_i0 PRJNA771359 1964 236 4.407035 10.4006026 Timema tahoe 61484 Arthropoda Arthropoda 226 1.18e-54   NTclustered gi|1946369122|emb|OE142856.1| 61484 g1881 i0 88.83 3.74576271186441 188 16 79 4 14 200 7 190 4_Tte_b3v08 blastn 884 226 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
5850590 5850590 PRJNA771359_S_NODE_3285_length_185_cov_1.797297_g3202_i0 PRJNA771359 3285 185 1.797297 3.32499945 Timema tahoe 61484 Arthropoda Arthropoda 335 1.4e-87   NTclustered gi|1947320427|emb|OE057578.1| 61484 g3202 i0 99.457 0.994594594594595 184 1 99 0 1 184 478 295 4_Tte_b3v08 blastn 184 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
7125762 7125762 PRJNA771359_S_NODE_2846_length_199_cov_1.339506_g2763_i0 PRJNA771359 2846 199 1.339506 2.66561694 Timema tahoe 61484 Arthropoda Arthropoda 106 1.31e-18   NTclustered gi|1947495154|emb|OE173849.1| 61484 g2763 i0 96.825 0.316582914572864 63 2 32 0 1 63 193 255 4_Tte_b3v08 blastn 63 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
8400276 8400276 PRJNA771359_S_NODE_4107_length_167_cov_0.892308_g4024_i0 PRJNA771359 4107 167 0.892308 1.49015436 Timema tahoe 61484 Arthropoda Arthropoda 268 1.28e-67   NTclustered gi|1946370863|emb|OE156485.1| 61484 g4024 i0 99.324 0.88622754491018 148 1 89 0 1 148 148 1 4_Tte_b3v08 blastn 148 268 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
9675466 9675466 PRJNA771359_S_NODE_2308_length_221_cov_2.086957_g2225_i0 PRJNA771359 2308 221 2.086957 4.61217497 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2463256861|ref|XM_054419099.1| 74068 g2225 i0 92.308 0.479638009049774 39 3 18 0 110 148 1793 1755 PREDICTED: Macrosteles quadrilineatus kelch domain-containing protein 4-like (LOC128994503), mRNA blastn 106 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
10951144 10951144 PRJNA771359_S_NODE_3029_length_193_cov_1.685897_g2946_i0 PRJNA771359 3029 193 1.685897 3.25378121 Timema tahoe 61484 Arthropoda Arthropoda 283 5.42e-72   NTclustered gi|1947207118|emb|OE158856.1| 61484 g2946 i0 93.229 5.27979274611399 192 13 99 0 2 193 57 248 4_Tte_b3v08 blastn 1019 283 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
12226764 12226764 PRJNA771359_S_NODE_4450_length_161_cov_1.225806_g4367_i0 PRJNA771359 4450 161 1.225806 1.97354766 Metopolophium dirhodum 44670 Arthropoda Arthropoda 60.2 7.99e-5   NTclustered gi|2621259418|ref|XM_061022378.1| 44670 g4367 i0 92.683 0.763975155279503 41 3 25 0 8 48 3691 3731 PREDICTED: Metopolophium dirhodum uncharacterized LOC132950804 (LOC132950804), mRNA blastn 123 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
17325372 17325372 PRJNA771359_S_NODE_3054_length_192_cov_2.109677_g2971_i0 PRJNA771359 3054 192 2.109677 4.05057984 Timema tahoe 61484 Arthropoda Arthropoda 267 5.4199999999999996e-67   NTclustered gi|1947052046|emb|OE042774.1| 61484 g2971 i0 91.71 4.546875 193 14 100 2 1 192 563 754 4_Tte_b3v08 blastn 873 267 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
17325405 17325405 PRJNA771359_S_NODE_5234_length_150_cov_1.707965_g5151_i0 PRJNA771359 5234 150 1.707965 2.5619475 Nymphon macrum 2773418 Arthropoda Arthropoda 113 5.53e-21   NTclustered gi|1912095528|gb|MT868358.1| 2773418 g5151 i0 81.429 7.53333333333333 140 24 93 2 12 150 160 22 Nymphon macrum isolate PYC053 ultraconserved element UCE4628 genomic sequence blastn 1130 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon macrum
18598812 18598812 PRJNA771359_S_NODE_4095_length_167_cov_1.430769_g4012_i0 PRJNA771359 4095 167 1.430769 2.38938423 Timema tahoe 61484 Arthropoda Arthropoda 257 2.77e-64   NTclustered gi|1946479661|emb|OE127265.1| 61484 g4012 i0 97.973 0.88622754491018 148 3 89 0 20 167 287 140 4_Tte_b3v08 blastn 148 257 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
18598821 18598821 PRJNA771359_S_NODE_4855_length_155_cov_1.635593_g4772_i0 PRJNA771359 4855 155 1.635593 2.53516915 Timema tahoe 61484 Arthropoda Arthropoda 191 2.59e-44   NTclustered gi|1946365997|emb|OE124759.1| 61484 g4772 i0 99.057 1.69032258064516 106 1 68 0 1 106 205 310 4_Tte_b3v08 blastn 262 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
18598822 18598822 PRJNA771359_S_NODE_4895_length_154_cov_2.880342_g4812_i0 PRJNA771359 4895 154 2.880342 4.43572668 Hydrometra stagnorum 446445 Arthropoda Arthropoda 226 7.039999999999999e-55   NTclustered gi|1131051030|gb|KX821841.1| 446445 g4812 i0 100 1.50649350649351 122 0 79 0 1 122 1361 1240 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 232 226 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
21149651 21149651 PRJNA771359_S_NODE_4757_length_156_cov_3.109244_g4674_i0 PRJNA771359 4757 156 3.109244 4.85042064 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 130 5.77e-26   NTclustered gi|2024326278|ref|XM_040718074.1| 72036 g4674 i0 83.217 9.49358974358974 143 23 91 1 8 149 353 495 PREDICTED: Lepeophtheirus salmonis 40S ribosomal protein S14a-like (LOC121122994), mRNA blastn 1481 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
22424369 22424369 PRJNA771359_S_NODE_4778_length_156_cov_1.655462_g4695_i0 PRJNA771359 4778 156 1.655462 2.58252072 Harmonia axyridis 115357 Arthropoda Arthropoda 117 4.49e-22   NTclustered gi|2170061644|ref|XM_045620644.1| 115357 g4695 i0 81.69 11.3910256410256 142 24 90 2 16 156 351 211 PREDICTED: Harmonia axyridis histone H3.3A (LOC123682185), mRNA blastn 1777 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
22884470 22884470 PRJNA771359_S_NODE_3178_length_188_cov_3.774834_g3095_i0 PRJNA771359 3178 188 3.774834 7.09668792 Speleorchestes 386823 Arthropoda Arthropoda 122 1.2099999999999999e-23   NTclustered gi|1282187772|gb|KY921977.1| 2051766 g3095 i0 89.691 52.031914893617 97 8 52 2 13 109 1297 1203 Speleorchestes sp. AD937 voucher UMMZ BMOC 07-0814-002 AD937 28S ribosomal RNA gene, partial sequence blastn 9782 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD937
24973675 24973675 PRJNA771359_S_NODE_4140_length_166_cov_1.914729_g4057_i0 PRJNA771359 4140 166 1.914729 3.17845014 Timema tahoe 61484 Arthropoda Arthropoda 263 5.9e-66   NTclustered gi|1946365251|emb|OE121161.1| 61484 g4057 i0 100 1.41566265060241 142 0 86 0 15 156 316 175 4_Tte_b3v08 blastn 235 263 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
25433403 25433403 PRJNA771359_S_NODE_2240_length_224_cov_1.379679_g2157_i0 PRJNA771359 2240 224 1.379679 3.09048096 Pieris 7115 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2172771204|ref|XM_045662291.1| 7116 g2157 i0 100 0.776785714285714 29 0 13 0 23 51 4518 4490 PREDICTED: Pieris brassicae protein capicua homolog (LOC123710423), transcript variant X3, mRNA blastn 174 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Pieris Pieris brassicae

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