RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1074408 · 32 ✖

analysis 1

  • blastn · 32 ✖
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
190999 190999 PRJNA1074408_S_NODE_2661_length_281_cov_9.071429_g2531_i0 PRJNA1074408 2661 281 9.071429 25.49071549 Tribolium castaneum 7070 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2733082152|emb|OX466070.1| 7070 g2531 i0 96.875 0.113879003558719 32 1 11 0 103 134 1808877 1808908 Tribolium castaneum genome assembly, chromosome: LG10 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
191001 191001 PRJNA1074408_S_NODE_3301_length_254_cov_2.047393_g3171_i0 PRJNA1074408 3301 254 2.047393 5.20037822 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g3171 i0 100 0.334645669291339 29 0 11 0 226 254 56 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
1465587 1465587 PRJNA1074408_S_NODE_5242_length_202_cov_1.509434_g5112_i0 PRJNA1074408 5242 202 1.509434 3.04905668 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 185 1.66e-42   NTclustered gi|1685539896|ref|XM_029487748.1| 7029 g5112 i0 83.415 8.11881188118812 205 28 99 6 4 202 1417 1213 PREDICTED: Acyrthosiphon pisum uncharacterized LOC100568963 (LOC100568963), mRNA blastn 1640 185 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
2291842 2291842 PRJNA1074408_S_NODE_8502_length_161_cov_2.474576_g8372_i0 PRJNA1074408 8502 161 2.474576 3.98406736 Timema 61471 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|1946859053|emb|OC316503.1| 61476 g8372 i0 100 0.347826086956522 28 0 17 0 19 46 69452 69479 3_Tce_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
2741674 2741674 PRJNA1074408_S_NODE_483_length_587_cov_60.897059_g366_i0 PRJNA1074408 483 587 60.897059 357.46573633 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1965181363|emb|OE475415.1| 61474 g366 i0 90.909 0.0749574105621806 44 1 7 2 324 364 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
2741686 2741686 PRJNA1074408_S_NODE_8923_length_157_cov_4.473684_g8793_i0 PRJNA1074408 8923 157 4.473684 7.02368388 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|2919606875|emb|OZ238401.1| 2546182 g8793 i0 100 0.356687898089172 28 0 18 0 4 31 31629503 31629530 Chelidura thaleri genome assembly, chromosome: 2 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
3567149 3567149 PRJNA1074408_S_NODE_4983_length_207_cov_1.737805_g4853_i0 PRJNA1074408 4983 207 1.737805 3.59725635 Coccinella 41138 Arthropoda Arthropoda 366 5.699999999999998e-97   NTclustered gi|2040310937|emb|OU015583.1| 41139 g4853 i0 100 92.4734299516908 198 0 96 0 10 207 17541 17344 Coccinella septempunctata genome assembly, organelle: mitochondrion blastn 19142 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
4017525 4017525 PRJNA1074408_S_NODE_4324_length_223_cov_1.600000_g4194_i0 PRJNA1074408 4324 223 1.6 3.568 Sipha flava 143950 Arthropoda Arthropoda 233 6.59e-57   NTclustered gi|1418873080|ref|XM_025555933.1| 143950 g4194 i0 85.463 2.03587443946188 227 29 100 2 1 223 5930 5704 PREDICTED: Sipha flava protein split ends (LOC112684407), transcript variant X1, mRNA blastn 454 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
4017528 4017528 PRJNA1074408_S_NODE_4984_length_207_cov_1.463415_g4854_i0 PRJNA1074408 4984 207 1.463415 3.02926905 Bombyx mori 7091 Arthropoda Arthropoda 383 5.65e-102   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g4854 i0 100 342.628019323671 207 0 100 0 1 207 5340964 5341170 Bombyx mori DNA, chromosome 22, sequence blastn 70924 383 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
4017539 4017539 PRJNA1074408_S_NODE_724_length_503_cov_6.095652_g597_i0 PRJNA1074408 724 503 6.095652 30.66112956 Bombyx mori 7091 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g597 i0 94.595 0.073558648111332 37 1 7 1 468 503 65 29 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 37 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
4017543 4017543 PRJNA1074408_S_NODE_84_length_1189_cov_8.288831_g40_i0 PRJNA1074408 84 1189 8.288831 98.55420059 Lucilia sericata 13632 Arthropoda Arthropoda 54.7 0.034   NTclustered gi|1937268232|ref|XM_037954536.1| 13632 g40 i0 100 0.317073170731707 29 0 2 0 1145 1173 289 261 PREDICTED: Lucilia sericata collagen alpha-1(XVII) chain (LOC119602811), transcript variant X3, mRNA blastn 377 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
5293851 5293851 PRJNA1074408_S_NODE_925_length_458_cov_28.093976_g795_i0 PRJNA1074408 925 458 28.093976 128.67041008 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.044   NTclustered gi|1965352161|emb|OE839429.1| 629358 g795 i0 100 0.0611353711790393 28 0 6 0 83 110 207387 207360 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
6119690 6119690 PRJNA1074408_S_NODE_2445_length_293_cov_1.420000_g2315_i0 PRJNA1074408 2445 293 1.42 4.1606 Coccinella 41138 Arthropoda Arthropoda 525 1.3299999999999994e-144   NTclustered gi|2040310937|emb|OU015583.1| 41139 g2315 i0 100 95.8225255972696 284 0 97 0 10 293 17209 16926 Coccinella septempunctata genome assembly, organelle: mitochondrion blastn 28076 525 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
7843684 7843684 PRJNA1074408_S_NODE_8427_length_162_cov_1.613445_g8297_i0 PRJNA1074408 8427 162 1.613445 2.6137809 Atomacera debilis 860938 Arthropoda Arthropoda 60.2 8.06e-5   NTclustered gi|300390968|gb|GQ374687.1| 860938 g8297 i0 92.683 0.253086419753086 41 3 25 0 62 102 1916 1956 Atomacera debilis 28S ribosomal RNA gene, partial sequence blastn 41 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Argidae Atomacera Atomacera debilis
9118629 9118629 PRJNA1074408_S_NODE_6308_length_185_cov_1.422535_g6178_i0 PRJNA1074408 6308 185 1.422535 2.63168975 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1963352837|emb|OE839734.1| 629358 g6178 i0 100 0.151351351351351 28 0 15 0 69 96 121538 121565 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
9118635 9118635 PRJNA1074408_S_NODE_88_length_1170_cov_6.561668_g44_i0 PRJNA1074408 88 1170 6.561668 76.7715156 Timema monikensis 170555 Arthropoda Arthropoda 54.7 0.033   NTclustered gi|1946400449|emb|OB792881.1| 170555 g44 i0 90.476 0.0358974358974359 42 2 3 2 738 777 536995 537036 3_Tms_b3v08 blastn 42 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
11219995 11219995 PRJNA1074408_S_NODE_8349_length_163_cov_1.200000_g8219_i0 PRJNA1074408 8349 163 1.2 1.956 Drosophila 7215 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|1037086167|ref|XM_017204284.1| 30025 g8219 i0 100 0.343558282208589 28 0 17 0 12 39 201 228 PREDICTED: Drosophila ficusphila 60S ribosomal protein L23a (LOC108100400), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ficusphila
11220000 11220000 PRJNA1074408_S_NODE_909_length_461_cov_2.746411_g779_i0 PRJNA1074408 909 461 2.746411 12.66095471 Aphididae 27482 Arthropoda Arthropoda 813 0   NTclustered gi|11034|emb|X62623.1| 7029 g779 i0 98.485 68.6724511930586 462 5 100 2 1 461 1062 1522 A.pisum gene for 18S ribosomal RNA blastn 31658 819 0.992673992673993 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
11669668 11669668 PRJNA1074408_S_NODE_5970_length_190_cov_1.306122_g5840_i0 PRJNA1074408 5970 190 1.306122 2.4816318 Anthonomus grandis 7044 Arthropoda Arthropoda 163 7.23e-36   NTclustered gi|2293537102|ref|XM_050439218.1| 2921223 g5840 i0 83.708 0.936842105263158 178 23 92 5 16 190 355 181 PREDICTED: Anthonomus grandis grandis 40S ribosomal protein S25 (LOC126735268), mRNA blastn 178 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis
12495325 12495325 PRJNA1074408_S_NODE_1210_length_408_cov_12.186301_g1080_i0 PRJNA1074408 1210 408 12.186301 49.72010808 Arthropoda 6656 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|1026137028|emb|LT560377.1| 85552 g1080 i0 100 0.487745098039216 29 0 7 0 380 408 34 6 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 199 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
12944707 12944707 PRJNA1074408_S_NODE_1291_length_397_cov_10.971751_g1161_i0 PRJNA1074408 1291 397 10.971751 43.55785147 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g1161 i0 100 3.48362720403023 30 0 8 0 243 272 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
13769835 13769835 PRJNA1074408_S_NODE_1871_length_332_cov_3.235294_g1741_i0 PRJNA1074408 1871 332 3.235294 10.74117608 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|1026137028|emb|LT560377.1| 85552 g1741 i0 100 0.253012048192771 28 0 8 0 303 330 35 8 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
15044173 15044173 PRJNA1074408_S_NODE_4072_length_229_cov_4.817204_g3942_i0 PRJNA1074408 4072 229 4.817204 11.03139716 Timema 61471 Arthropoda Arthropoda 62.1 3.39e-5   NTclustered gi|1947838656|emb|OD567419.1| 61472 g3942 i0 94.872 1.7117903930131 39 2 17 0 183 221 82825 82863 4_Tbi_b3v08 blastn 392 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
15493632 15493632 PRJNA1074408_S_NODE_1033_length_437_cov_2.621827_g903_i0 PRJNA1074408 1033 437 2.621827 11.45738399 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g903 i0 100 0.0663615560640732 29 0 7 0 270 298 1610 1638 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
16767956 16767956 PRJNA1074408_S_NODE_8254_length_164_cov_1.049587_g8124_i0 PRJNA1074408 8254 164 1.049587 1.72132268 Coccinella septempunctata 41139 Arthropoda Arthropoda 270 3.4699999999999992e-68   NTclustered gi|2125242254|ref|XM_044911123.1| 41139 g8124 i0 98.065 2.3780487804878 155 3 95 0 10 164 55 209 PREDICTED: Coccinella septempunctata adult-specific cuticular protein ACP-22-like (LOC123322985), transcript variant X3, mRNA blastn 390 270 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
19316658 19316658 PRJNA1074408_S_NODE_2816_length_273_cov_3.226087_g2686_i0 PRJNA1074408 2816 273 3.226087 8.80721751 Takecallis arundicolens 527946 Arthropoda Arthropoda 486 5.8e-133   NTclustered gi|2739944042|emb|OZ060886.1| 527946 g2686 i0 98.897 99.014652014652 272 3 99 0 2 273 14934 14663 Takecallis arundicolens genome assembly, organelle: mitochondrion blastn 27031 486 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Takecallis Takecallis arundicolens
20142922 20142922 PRJNA1074408_S_NODE_7976_length_166_cov_2.341463_g7846_i0 PRJNA1074408 7976 166 2.341463 3.88682858 Hemiptera 7524 Arthropoda Arthropoda 307 2.69e-79   NTclustered gi|2304422067|ref|XR_007705028.1| 58002 g7846 i0 100 100 166 0 100 0 1 166 3420 3585 PREDICTED: Daktulosphaira vitifoliae large subunit ribosomal RNA (LOC126909386), rRNA blastn 16600 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
21418595 21418595 PRJNA1074408_S_NODE_9877_length_151_cov_1.351852_g9747_i0 PRJNA1074408 9877 151 1.351852 2.04129652 Aphididae 27482 Arthropoda Arthropoda 246 5.27e-61   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g9747 i0 96.026 92.4569536423841 151 6 100 0 1 151 2436 2586 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 13961 246 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
22693445 22693445 PRJNA1074408_S_NODE_3758_length_238_cov_1.230769_g3628_i0 PRJNA1074408 3758 238 1.230769 2.92923022 Vespula 7451 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2313522988|ref|XM_051000313.1| 7454 g3628 i0 100 0.73109243697479 30 0 13 0 202 231 393 422 PREDICTED: Vespula vulgaris nuclear RNA export factor 1-like (LOC127066492), mRNA blastn 174 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula vulgaris
23143239 23143239 PRJNA1074408_S_NODE_4319_length_223_cov_1.855556_g4189_i0 PRJNA1074408 4319 223 1.855556 4.13788988 Aphis gossypii 80765 Arthropoda Arthropoda 272 1.3999999999999996e-68   NTclustered gi|2288467571|ref|XM_027987224.2| 80765 g4189 i0 89.908 15.1928251121076 218 12 98 4 1 218 1403 1196 PREDICTED: Aphis gossypii heterogeneous nuclear ribonucleoprotein 87F-like (LOC114124061), transcript variant X1, mRNA blastn 3388 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
23143240 23143240 PRJNA1074408_S_NODE_4339_length_222_cov_4.910615_g4209_i0 PRJNA1074408 4339 222 4.910615 10.9015653 Takecallis sp. IY-2010 904941 Arthropoda Arthropoda 411 2.8199999999999996e-110   NTclustered gi|2119031546|dbj|LC654263.1| 904941 g4209 i0 100 97.1576576576577 222 0 100 0 1 222 295 74 Takecallis sp. IY-2010 gene for 18S ribosomal RNA, partial sequence blastn 21569 411 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Takecallis Takecallis sp. IY-2010
25242811 25242811 PRJNA1074408_S_NODE_8760_length_159_cov_1.836207_g8630_i0 PRJNA1074408 8760 159 1.836207 2.91956913 Aphididae 27482 Arthropoda Arthropoda 279 5.55e-71   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g8630 i0 98.148 95.9119496855346 162 0 100 1 1 159 1901 2062 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 15250 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi

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