RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1103784" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1103784 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
1486792 1486792 PRJNA1103784_P_NODE_2802_length_323_cov_2.668000_g2747_i0 PRJNA1103784 2802 323 2.668 8.61764 Timema genevievae 629358 Arthropoda Arthropoda 60.2 1.81e-4   NTclustered gi|1964508656|emb|OE841622.1| 629358 g2747 i0 94.872 0.312693498452012 39 1 12 1 193 231 78656 78693 5_Tge_b3v08 blastn 101 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
1486839 1486839 PRJNA1103784_P_NODE_5422_length_254_cov_2.187845_g5367_i0 PRJNA1103784 5422 254 2.187845 5.5571263 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2919610158|emb|OZ238415.1| 2546182 g5367 i0 100 0.110236220472441 28 0 11 0 38 65 2961675 2961648 Chelidura thaleri genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
3570704 3570704 PRJNA1103784_P_NODE_5603_length_251_cov_1.421348_g5548_i0 PRJNA1103784 5603 251 1.421348 3.56758348 Opisthokonta 33154 Arthropoda Arthropoda 459 1.1499999999999996e-124   NTclustered gi|1494774795|ref|XR_003394589.1| 121845 g5548 i0 99.602 99.6414342629482 251 1 100 0 1 251 116 366 PREDICTED: Diaphorina citri small subunit ribosomal RNA (LOC113472153), rRNA blastn 25010 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
6590171 6590171 PRJNA1103784_P_NODE_1486_length_418_cov_1.698551_g1431_i0 PRJNA1103784 1486 418 1.698551 7.09994318 Polyergus mexicanus 615972 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|2868494225|ref|XM_070306183.1| 615972 g1431 i0 96.774 0.0741626794258373 31 1 7 0 377 407 499 529 PREDICTED: Polyergus mexicanus IWS1-like protein (LOC138938852), mRNA blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Polyergus Polyergus mexicanus
7864889 7864889 PRJNA1103784_P_NODE_7107_length_244_cov_0.900585_g7052_i0 PRJNA1103784 7107 244 0.900585 2.1974274 Diaprepes abbreviatus 13040 Arthropoda Arthropoda 65.8 2.83e-6   NTclustered gi|110349472|gb|DQ667143.1| 13040 g7052 i0 95.122 0.168032786885246 41 2 17 0 172 212 491 451 Diaprepes abbreviatus cathepsin L 1 precursor, mRNA, complete cds blastn 41 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Diaprepes Diaprepes abbreviatus
12499030 12499030 PRJNA1103784_P_NODE_7890_length_240_cov_3.461078_g7835_i0 PRJNA1103784 7890 240 3.461078 8.3065872 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1947839066|emb|OD567704.1| 61472 g7835 i0 100 0.233333333333333 28 0 12 0 184 211 51644 51617 4_Tbi_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
13773524 13773524 PRJNA1103784_P_NODE_791_length_552_cov_3.022965_g737_i0 PRJNA1103784 791 552 3.022965 16.6867668 Metazoa 33208 Arthropoda Arthropoda 91.6 1.15e-13   NTclustered gi|2240866600|gb|ON555715.1| 1343479 g737 i0 89.041 12.8768115942029 73 8 13 0 185 257 1989 2061 Trisetacus pini isolate MLW755 large subunit ribosomal RNA gene, partial sequence blastn 7108 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Trisetacus Trisetacus pini
15514742 15514742 PRJNA1103784_P_NODE_2353_length_348_cov_1.716364_g2298_i0 PRJNA1103784 2353 348 1.716364 5.97294672 Chironomus tepperi 113505 Arthropoda Arthropoda 62.1 5.48e-5   NTclustered gi|2874227709|ref|XM_070648502.1| 113505 g2298 i0 83.824 0.640804597701149 68 7 19 2 251 315 143 209 PREDICTED: Chironomus tepperi ribosomal protein S2 (RpS2), mRNA blastn 223 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
18063891 18063891 PRJNA1103784_P_NODE_815_length_545_cov_6.404661_g761_i0 PRJNA1103784 815 545 6.404661 34.90540245 Timema monikensis 170555 Arthropoda Arthropoda 58.4 0.001   NTclustered gi|1946411097|emb|OB793204.1| 170555 g761 i0 97.059 0.170642201834862 34 1 6 0 309 342 168543 168510 3_Tms_b3v08 blastn 93 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
19337919 19337919 PRJNA1103784_P_NODE_3556_length_293_cov_1.400000_g3501_i0 PRJNA1103784 3556 293 1.4 4.102 Leptinotarsa decemlineata 7539 Arthropoda Arthropoda 165 3.34e-36   NTclustered gi|1285028930|ref|XM_023170988.1| 7539 g3501 i0 78.195 14.9556313993174 266 52 90 6 2 264 1142 1404 PREDICTED: Leptinotarsa decemlineata tubulin beta-1 chain (LOC111514740), mRNA blastn 4382 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
20613273 20613273 PRJNA1103784_P_NODE_1497_length_417_cov_1.465116_g1442_i0 PRJNA1103784 1497 417 1.465116 6.10953372 Timema bartmani 61472 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|1947898769|emb|OD783355.1| 61472 g1442 i0 100 0.201438848920863 28 0 7 0 293 320 34 61 4_Tbi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
20613326 20613326 PRJNA1103784_P_NODE_5457_length_254_cov_1.270718_g5402_i0 PRJNA1103784 5457 254 1.270718 3.22762372 Aphis gossypii 80765 Arthropoda Arthropoda 176 1.31e-39   NTclustered gi|2288491657|ref|XM_027996826.2| 80765 g5402 i0 80.085 8.17716535433071 236 47 93 0 17 252 224 459 PREDICTED: Aphis gossypii dynein light chain 1, cytoplasmic (LOC114131570), mRNA blastn 2077 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
21888906 21888906 PRJNA1103784_P_NODE_2378_length_347_cov_1.124088_g2323_i0 PRJNA1103784 2378 347 1.124088 3.90058536 Bombyx mori 7091 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2919985627|emb|OZ208599.1| 7091 g2323 i0 100 0.403458213256484 28 0 8 0 314 341 10309353 10309380 Bombyx mori genome assembly, chromosome: 21 blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
23972471 23972471 PRJNA1103784_P_NODE_5039_length_262_cov_1.550265_g4984_i0 PRJNA1103784 5039 262 1.550265 4.0616943 Opisthokonta 33154 Arthropoda Arthropoda 204 6.239999999999999e-48   NTclustered gi|2701319970|ref|XM_063849994.1| 469753 g4984 i0 83.556 82.0038167938931 225 29 84 7 40 260 796 1016 PREDICTED: Culicoides brevitarsis ATP synthase subunit beta, mitochondrial (LOC134835126), mRNA blastn 21485 204 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
24438017 24438017 PRJNA1103784_P_NODE_3340_length_302_cov_1.170306_g3285_i0 PRJNA1103784 3340 302 1.170306 3.53432412 Drosophila rhopaloa 1041015 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2118798388|ref|XM_017135781.2| 1041015 g3285 i0 100 0.0927152317880795 28 0 9 0 102 129 182 155 PREDICTED: Drosophila rhopaloa transcription initiation factor TFIID subunit 10b (LOC108053183), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila rhopaloa
24438073 24438073 PRJNA1103784_P_NODE_6540_length_247_cov_0.885057_g6485_i0 PRJNA1103784 6540 247 0.885057 2.18609079 Timema tahoe 61484 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1948020429|emb|OE001550.1| 61484 g6485 i0 96.875 0.129554655870445 32 1 13 0 189 220 119431 119400 4_Tte_b3v08 blastn 32 54.7 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);;