RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1067443", tax_kingdom = "Metazoa" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

  • Metazoa · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA1067443 · 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
2732163 2732163 PRJNA1067443_P_NODE_4543_length_367_cov_9.850340_g4525_i0 PRJNA1067443 4543 367 9.85034 36.1507478 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g4525 i0 100 0.0762942779291553 28 0 8 0 39 66 23317845 23317818 Satyrium ilicis genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
5284272 5284272 PRJNA1067443_P_NODE_20005_length_245_cov_0.895349_g19987_i0 PRJNA1067443 20005 245 0.895349 2.19360505 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 62.1 3.67e-5   NTclustered gi|2237320238|ref|XM_048134236.1| 1035111 g19987 i0 92.857 0.17142857142857101 42 3 17 0 50 91 3182 3223 PREDICTED: Leguminivora glycinivorella RNA polymerase-associated protein CTR9 homolog (LOC125229406), mRNA blastn 42 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
8666700 8666700 PRJNA1067443_P_NODE_2347_length_448_cov_12.000000_g2329_i0 PRJNA1067443 2347 448 12 53.76 Hymenoptera sp. BOLD:ACB2397 1667987 Arthropoda Arthropoda 178 5.2199999999999996e-54   NR AKQ92961.1 1667987 g2329 i0 81.7 1.39285714285714 104 19 69.6 0 418 107 37 140 AKQ92961.1 cytochrome oxidase subunit 1, partial [Hymenoptera sp. BOLD:ACB2397] diamond 624 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera     Hymenoptera sp. BOLD:ACB2397
10384785 10384785 PRJNA1067443_P_NODE_19349_length_246_cov_0.890173_g19331_i0 PRJNA1067443 19349 246 0.890173 2.18982558 Drosophila montana 40370 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2721905550|ref|XM_064687820.1| 40370 g19331 i0 100 0.113821138211382 28 0 11 0 30 57 1034 1007 PREDICTED: Drosophila montana ras-like protein 2 (Ras64B), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila montana
12935303 12935303 PRJNA1067443_P_NODE_24391_length_200_cov_7.393701_g24373_i0 PRJNA1067443 24391 200 7.393701 14.787402 Bemisia tabaci 7038 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|1101370597|ref|XM_019061133.1| 7038 g24373 i0 96.875 0.16 32 0 16 1 2 33 937 967 PREDICTED: Bemisia tabaci uncharacterized LOC109043815 (LOC109043815), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
18033259 18033259 PRJNA1067443_P_NODE_21315_length_243_cov_0.905882_g21297_i0 PRJNA1067443 21315 243 0.905882 2.20129326 Anopheles nili 185578 Arthropoda Arthropoda 63.9 1.01e-5   NTclustered gi|2449506146|ref|XM_053822357.1| 185578 g21297 i0 97.368 1.09053497942387 38 0 15 1 200 236 4647 4610 PREDICTED: Anopheles nili uncharacterized LOC128728720 (LOC128728720), mRNA blastn 265 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
18033260 18033260 PRJNA1067443_P_NODE_21335_length_243_cov_0.905882_g21317_i0 PRJNA1067443 21335 243 0.905882 2.20129326 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 267 7.19e-67   NTclustered gi|1535902535|ref|XM_027350222.1| 6956 g21317 i0 100 1.27572016460905 144 0 59 0 61 204 1260 1117 PREDICTED: Dermatophagoides pteronyssinus ubiquitin carboxyl-terminal hydrolase MINDY-1-like (LOC113799567), mRNA blastn 310 267 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
19307089 19307089 PRJNA1067443_P_NODE_20476_length_244_cov_1.725146_g20458_i0 PRJNA1067443 20476 244 1.725146 4.20935624 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 429 8.699999999999998e-116   NTclustered gi|641654571|ref|XM_008181035.1| 7029 g20458 i0 98.361 8.55327868852459 244 4 100 0 1 244 2358 2115 PREDICTED: Acyrthosiphon pisum uncharacterized LOC103308142 (LOC103308142), mRNA blastn 2087 429 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
20582568 20582568 PRJNA1067443_P_NODE_1697_length_494_cov_10.836105_g1679_i0 PRJNA1067443 1697 494 10.836105 53.5303587 Schistocerca gregaria 7010 Arthropoda Arthropoda 150 4.41e-39   NR XP_049849072.1 7010 g1679 i0 53.5 1.77935222672065 144 63 85 2 1 420 486 629 XP_049849072.1 heat shock 70 kDa protein-like [Schistocerca gregaria] diamond 879 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
21858359 21858359 PRJNA1067443_P_NODE_23098_length_237_cov_5.932927_g23080_i0 PRJNA1067443 23098 237 5.932927 14.06103699 Artemia franciscana 6661 Arthropoda Arthropoda 95.3 3.48e-15   NTclustered gi|2743062923|ref|XM_065700419.1| 6661 g23080 i0 100 0.215189873417722 51 0 22 0 163 213 6225 6175 PREDICTED: Artemia franciscana zinc finger protein 184-like (LOC136024888), mRNA blastn 51 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21858523 21858523 PRJNA1067443_P_NODE_7438_length_312_cov_3.025105_g7420_i0 PRJNA1067443 7438 312 3.025105 9.4383276 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g7420 i0 100 0.272435897435897 29 0 9 0 284 312 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
21858567 21858567 PRJNA1067443_P_NODE_898_length_588_cov_18.330097_g880_i0 PRJNA1067443 898 588 18.330097 107.78097036 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.016   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g880 i0 100 0.049319727891156503 29 0 5 0 560 588 56 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
23133585 23133585 PRJNA1067443_P_NODE_1119_length_557_cov_11.371901_g1101_i0 PRJNA1067443 1119 557 11.371901 63.34148857 Aphis gossypii 80765 Arthropoda Arthropoda 121 1.48e-22   NTclustered gi|2288459457|ref|XR_007606345.1| 80765 g1101 i0 92.045 0.315978456014363 88 3 15 3 135 220 369 454 PREDICTED: Aphis gossypii uncharacterized LOC126552892 (LOC126552892), transcript variant X2, ncRNA blastn 176 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
29909474 29909474 PRJNA1067443_P_NODE_2411_length_444_cov_19.083558_g2393_i0 PRJNA1067443 2411 444 19.083558 84.73099752 Schistocerca gregaria 7010 Arthropoda Arthropoda 73.2 7.89e-12   NR XP_049849872.1 7010 g2393 i0 47.8 0.466216216216216 69 36 46.6 0 94 300 615 683 XP_049849872.1 apoptosis-inducing factor 1, mitochondrial-like [Schistocerca gregaria] diamond 207 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30035765 30035765 PRJNA1067443_P_NODE_4511_length_368_cov_13.061017_g4493_i0 PRJNA1067443 4511 368 13.061017 48.06454256 Schistocerca gregaria 7010 Arthropoda Arthropoda 50.4 2.83e-4   NR XP_049851163.1 7010 g4493 i0 38.8 0.692934782608696 85 46 67.7 3 2 250 383 463 XP_049851163.1 oxysterol-binding protein 8-like [Schistocerca gregaria] diamond 255 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30320596 30320596 PRJNA1067443_P_NODE_5832_length_338_cov_6.800000_g5814_i0 PRJNA1067443 5832 338 6.8 22.984 Schistocerca gregaria 7010 Arthropoda Arthropoda 65.9 8.59e-10   NR XP_049850183.1 7010 g5814 i0 57.9 0.505917159763314 57 24 50.6 0 172 2 166 222 XP_049850183.1 uncharacterized protein LOC126321793 [Schistocerca gregaria] diamond 171 65.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30352201 30352201 PRJNA1067443_P_NODE_32_length_1611_cov_25.263329_g28_i0 PRJNA1067443 32 1611 25.263329 406.99223019 Periplaneta americana 6978 Arthropoda Arthropoda 60.8 1.02e-5   NR XP_069698449.1 6978 g28 i0 50.9 0.199255121042831 53 26 9.9 0 7 165 160 212 XP_069698449.1 BTB/POZ domain-containing protein 6-B [Periplaneta americana] diamond 321 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30383651 30383651 PRJNA1067443_P_NODE_15573_length_254_cov_2.016575_g15555_i0 PRJNA1067443 15573 254 2.016575 5.1221005 Tribolium castaneum 7070 Arthropoda Arthropoda 71.2 2.14e-14   NR EFA13580.1 7070 g15555 i0 100 0.401574803149606 34 0 40.2 0 206 105 19 52 EFA13580.1 hypothetical protein TcasGA2_TC001599 [Tribolium castaneum] diamond 102 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
30667599 30667599 PRJNA1067443_P_NODE_4033_length_380_cov_6.739414_g4015_i0 PRJNA1067443 4033 380 6.739414 25.6097732 Schistocerca gregaria 7010 Arthropoda Arthropoda 93.2 3.89e-19   NR XP_049849622.1 7010 g4015 i0 41.2 0.805263157894737 102 59 79.7 1 1 303 922 1023 XP_049849622.1 phosphatidylinositol 4-kinase-like [Schistocerca gregaria] diamond 306 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31299569 31299569 PRJNA1067443_P_NODE_17355_length_249_cov_1.750000_g17337_i0 PRJNA1067443 17355 249 1.75 4.3575 Halotydeus destructor 2874060 Arthropoda Arthropoda 145 2.18e-38   NR KAI1278379.1 2874060 g17337 i0 77.1 1.98795180722892 83 19 100 0 1 249 188 270 KAI1278379.1 Histone deacetylase 6 [Halotydeus destructor] diamond 495 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
32248971 32248971 PRJNA1067443_P_NODE_418_length_724_cov_31.049155_g403_i0 PRJNA1067443 418 724 31.049155 224.7958822 Nesidiocoris tenuis 355587 Arthropoda Arthropoda 93.6 7.12e-18   NR BES96277.1 355587 g403 i0 40 0.662983425414365 160 26 66.3 1 109 588 118 207 BES96277.1 solute carrier family 2, facilitated glucose transporter member [Nesidiocoris tenuis] diamond 480 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Nesidiocoris Nesidiocoris tenuis
32627859 32627859 PRJNA1067443_P_NODE_24460_length_197_cov_4.266129_g24442_i0 PRJNA1067443 24460 197 4.266129 8.40427413 Tribolium castaneum 7070 Arthropoda Arthropoda 63.2 1.62e-11   NR EFA13580.1 7070 g24442 i0 75.6 0.685279187817259 45 11 68.5 0 20 154 8 52 EFA13580.1 hypothetical protein TcasGA2_TC001599 [Tribolium castaneum] diamond 135 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum

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