RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJEB56027" 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

  • PRJEB56027 · 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
1396480 1396480 PRJEB56027_P_NODE_105082_length_262_cov_1.291005_g102273_i0 PRJEB56027 105082 262 1.291005 3.3824331 Nilaparvata lugens 108931 Arthropoda Arthropoda 78.7 3.94e-10   NTclustered gi|1983899490|ref|XM_039424725.1| 108931 g102273 i0 82.474 3.27862595419847 97 9 35 6 38 130 1896 1988 PREDICTED: Nilaparvata lugens uncharacterized LOC111060639 (LOC111060639), mRNA blastn 859 78.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
1397213 1397213 PRJEB56027_P_NODE_132222_length_241_cov_1.833333_g129413_i0 PRJEB56027 132222 241 1.833333 4.41833253 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 178 3.43e-40   NTclustered gi|2899203825|ref|XM_071181794.1| 114398 g129413 i0 81.481 0.896265560165975 216 40 90 0 23 238 444 229 PREDICTED: Parasteatoda tepidariorum uncharacterized protein (LOC139425823), mRNA blastn 216 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
1398846 1398846 PRJEB56027_P_NODE_93322_length_278_cov_1.307317_g90513_i0 PRJEB56027 93322 278 1.307317 3.63434126 Toxomerus marginatus 115329 Arthropoda Arthropoda 494 3.54e-135   NTclustered gi|400234339|gb|JN664720.1| 115329 g90513 i0 98.571 100.561151079137 280 2 100 2 1 278 1433 1712 Toxomerus marginatus isolate 2752 28S ribosomal RNA gene, partial sequence blastn 27956 494 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Toxomerus Toxomerus marginatus
2673016 2673016 PRJEB56027_P_NODE_137563_length_227_cov_2.662338_g134754_i0 PRJEB56027 137563 227 2.662338 6.04350726 Samia ricini 63990 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2883230270|dbj|AP038904.1| 63990 g134754 i0 100 0.127753303964758 29 0 13 0 38 66 22303103 22303131 Samia ricini White GU1 DNA, chromosome 09, complete sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
5225439 5225439 PRJEB56027_P_NODE_138965_length_196_cov_4.471545_g136156_i0 PRJEB56027 138965 196 4.471545 8.7642282 Euthrix potatoria 624169 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2918370016|emb|OZ237903.1| 624169 g136156 i0 96.97 0.168367346938776 33 0 17 1 103 135 14251706 14251737 Euthrix potatoria genome assembly, chromosome: Z blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
6095107 6095107 PRJEB56027_P_NODE_136365_length_231_cov_3.221519_g133556_i0 PRJEB56027 136365 231 3.221519 7.44170889 Phytoseiidae 34636 Arthropoda Arthropoda 422 1.37e-113   NTclustered gi|2209908498|gb|ON025568.1| 756257 g133556 i0 99.567 60.7056277056277 231 1 100 0 1 231 829 1059 Typhlodromips montdorensis isolate 1_1 large subunit ribosomal RNA gene, partial sequence blastn 14023 422 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Typhlodromips Typhlodromips montdorensis
7369460 7369460 PRJEB56027_P_NODE_132466_length_241_cov_1.494048_g129657_i0 PRJEB56027 132466 241 1.494048 3.60065568 Arthropoda 6656 Arthropoda Arthropoda 263 9.21e-66   NTclustered gi|1048055505|ref|XM_017626387.1| 28612 g129657 i0 86.307 91.804979253112 241 33 100 0 1 241 389 149 PREDICTED: Rhagoletis zephyria tubulin alpha chain (LOC108370935), mRNA blastn 22125 263 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
11601539 11601539 PRJEB56027_P_NODE_33110_length_653_cov_7.548276_g30343_i0 PRJEB56027 33110 653 7.548276 49.29024228 Oppiella nova 334625 Arthropoda Arthropoda 54.7 0.018   NTclustered gi|1962580772|emb|OC914909.1| 334625 g30343 i0 100 0.0444104134762634 29 0 4 0 24 52 7584 7612 Oppiella nova blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
11602999 11602999 PRJEB56027_P_NODE_99710_length_269_cov_1.464286_g96901_i0 PRJEB56027 99710 269 1.464286 3.93892934 Vespa crabro 7445 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|2201594555|ref|XM_046975150.1| 7445 g96901 i0 100 0.312267657992565 28 0 10 0 131 158 3501 3528 PREDICTED: Vespa crabro D-glucuronyl C5-epimerase B (LOC124429623), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespa Vespa crabro
12470973 12470973 PRJEB56027_P_NODE_76670_length_310_cov_2.337553_g73861_i0 PRJEB56027 76670 310 2.337553 7.2464143 Timema 61471 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1947819235|emb|OD566261.1| 61472 g73861 i0 100 0.187096774193548 29 0 9 0 279 307 111505 111477 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
12877190 12877190 PRJEB56027_P_NODE_58131_length_377_cov_3.394737_g55322_i0 PRJEB56027 58131 377 3.394737 12.79815849 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g55322 i0 100 0.0769230769230769 29 0 8 0 229 257 1610 1638 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
14150397 14150397 PRJEB56027_P_NODE_103312_length_264_cov_1.612565_g100503_i0 PRJEB56027 103312 264 1.612565 4.2571716 Halyomorpha halys 286706 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2782052689|ref|XM_014418426.3| 286706 g100503 i0 100 0.212121212121212 28 0 11 0 143 170 2599 2572 PREDICTED: Halyomorpha halys zinc finger protein 391 (LOC106679327), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
15019776 15019776 PRJEB56027_P_NODE_100192_length_268_cov_2.000000_g97383_i0 PRJEB56027 100192 268 2 5.36 Metazoa 33208 Arthropoda Arthropoda 58.4 5.27e-4   NTclustered gi|2313487249|ref|XR_007784451.1| 7454 g97383 i0 97.059 0.958955223880597 34 1 13 0 4 37 2588 2621 PREDICTED: Vespula vulgaris uncharacterized LOC127070284 (LOC127070284), transcript variant X1, ncRNA blastn 257 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula vulgaris
15424650 15424650 PRJEB56027_P_NODE_111913_length_253_cov_1.711111_g109104_i0 PRJEB56027 111913 253 1.711111 4.32911083 Curculionidae sp. 3 AH-2016 1903829 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1178768440|gb|KX087272.1| 1903829 g109104 i0 100 0.110671936758893 28 0 11 0 162 189 5939 5912 Curculionidae sp. 3 AH-2016 mitochondrion, partial genome blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae   Curculionidae sp. 3 AH-2016
15426986 15426986 PRJEB56027_P_NODE_99973_length_269_cov_1.117347_g97164_i0 PRJEB56027 99973 269 1.117347 3.00566343 Cimex lectularius 79782 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1351637470|ref|XM_014403873.2| 79782 g97164 i0 94.286 0.650557620817844 35 2 13 0 15 49 2075 2041 PREDICTED: Cimex lectularius kinesin-like protein KIF21A (LOC106672436), transcript variant X1, mRNA blastn 175 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
16700014 16700014 PRJEB56027_P_NODE_43794_length_486_cov_1.447942_g40987_i0 PRJEB56027 43794 486 1.447942 7.03699812 Brachistosternus pentheri 1711960 Arthropoda Arthropoda 52.8 0.047   NTclustered gi|925719864|gb|KT446663.1| 1711960 g40987 i0 100 0.172839506172839 28 0 6 0 364 391 217 244 Brachistosternus pentheri isolate LP_2459 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Bothriuridae Brachistosternus Brachistosternus pentheri
17973943 17973943 PRJEB56027_P_NODE_114795_length_251_cov_0.865169_g111986_i0 PRJEB56027 114795 251 0.865169 2.17157419 Episema korsakovi 1870626 Arthropoda Arthropoda 237 5.85e-58   NTclustered gi|2920003678|emb|OZ238892.1| 1870626 g111986 i0 90.323 2.78486055776892 186 10 74 4 55 239 7068089 7067911 Episema korsakovi genome assembly, chromosome: 16 blastn 699 237 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Episema Episema korsakovi
20523061 20523061 PRJEB56027_P_NODE_107717_length_258_cov_2.248649_g104908_i0 PRJEB56027 107717 258 2.248649 5.80151442 Uloborus diversus 327109 Arthropoda Arthropoda 63.9 1.08e-5   NTclustered gi|2473938808|ref|XM_054867173.1| 327109 g104908 i0 97.297 0.705426356589147 37 1 14 0 70 106 2930 2966 PREDICTED: Uloborus diversus protein FAM76A-like (LOC129233114), transcript variant X1, mRNA blastn 182 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
20523857 20523857 PRJEB56027_P_NODE_137837_length_226_cov_2.738562_g135028_i0 PRJEB56027 137837 226 2.738562 6.18915012 Oppiella nova 334625 Arthropoda Arthropoda 396 8.069999999999997e-106   NTclustered gi|1962580193|emb|OC914871.1| 334625 g135028 i0 98.23 6.98672566371681 226 4 100 0 1 226 9232 9007 Oppiella nova blastn 1579 396 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
21394062 21394062 PRJEB56027_P_NODE_58577_length_375_cov_2.486755_g55768_i0 PRJEB56027 58577 375 2.486755 9.32533125 Phytoseiidae 34636 Arthropoda Arthropoda 693 0   NTclustered gi|628598562|dbj|AB862883.1| 1414592 g55768 i0 100 86.9466666666667 375 0 100 0 1 375 2143 1769 Neoseiulus makuwa genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, isolate: 76mak22 blastn 32605 693 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Neoseiulus Neoseiulus makuwa
23074580 23074580 PRJEB56027_P_NODE_123059_length_246_cov_1.526012_g120250_i0 PRJEB56027 123059 246 1.526012 3.75398952 Artemia franciscana 6661 Arthropoda Arthropoda 449 6.74e-122   NTclustered gi|2743034824|ref|XM_065713659.1| 6661 g120250 i0 99.593 11.4837398373984 246 1 100 0 1 246 3068 2823 PREDICTED: Artemia franciscana shematrin-like protein 3 (LOC136033064), transcript variant X1, mRNA blastn 2825 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
23944255 23944255 PRJEB56027_P_NODE_115679_length_250_cov_1.401130_g112870_i0 PRJEB56027 115679 250 1.40113 3.502825 root 1 Root_unresolved Root_unresolved 451 1.91e-122   NTclustered gi|1964812993|emb|OC915364.1| 334625 g112870 i0 99.2 16.912 250 2 100 0 1 250 1712 1961 Oppiella nova blastn 4228 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova

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