RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA309466" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA309466 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
1651663 1651663 PRJNA309466_P_NODE_7602_length_219_cov_14.758824_g7545_i0 PRJNA309466 7602 219 14.758824 32.32182456 Aphanogmus sp. D1499 1119198 Arthropoda Arthropoda 333 6.179999999999999e-87   NTclustered gi|359292816|gb|JN623103.1| 1119198 g7545 i0 95.238 94.6529680365297 210 10 96 0 9 218 458 249 Aphanogmus sp. D1499 voucher UCRC_ENT 49090 18S ribosomal RNA gene, partial sequence blastn 20729 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ceraphronidae Aphanogmus Aphanogmus sp. D1499
2927427 2927427 PRJNA309466_P_NODE_11183_length_191_cov_4.563380_g11126_i0 PRJNA309466 11183 191 4.56338 8.7160558 Vespa mandarinia 7446 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1891365235|ref|XM_035862558.1| 7446 g11126 i0 100 0.43979057591623 28 0 15 0 152 179 4391 4418 PREDICTED: Vespa mandarinia probable G-protein coupled receptor CG31760 (LOC118440056), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespa Vespa mandarinia
3613670 3613670 PRJNA309466_P_NODE_3263_length_336_cov_3.508711_g3207_i0 PRJNA309466 3263 336 3.508711 11.78926896 Trombidiformes 83136 Arthropoda Arthropoda 159 1.8199999999999999e-34   NTclustered gi|2240866599|gb|ON555714.1| 109366 g3207 i0 90.833 34.1666666666667 120 9 35 2 174 291 2707 2588 Aceria tulipae isolate AS197 large subunit ribosomal RNA gene, partial sequence blastn 11480 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria tulipae
3613688 3613688 PRJNA309466_P_NODE_4003_length_290_cov_70612.174274_g3947_i0 PRJNA309466 4003 290 70612.174274 204775.3053946 root 1 Root_unresolved Root_unresolved 58.4 5.77e-4   NTclustered gi|2644538216|ref|XM_017059696.3| 7461 g3947 i0 97.059 40.2965517241379 34 1 23 0 203 236 2818 2785 PREDICTED: Apis cerana protein giant-lens (LOC107999702), transcript variant X1, mRNA blastn 11686 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis cerana
4203985 4203985 PRJNA309466_P_NODE_17024_length_165_cov_0.896552_g16967_i0 PRJNA309466 17024 165 0.896552 1.4793108 Bombyx mori 7091 Arthropoda Arthropoda 300 4.46e-77   NTclustered gi|2919985622|emb|OZ208595.1| 7091 g16967 i0 100 8.56969696969697 162 0 98 0 4 165 13712296 13712457 Bombyx mori genome assembly, chromosome: 17 blastn 1414 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
6754465 6754465 PRJNA309466_P_NODE_16326_length_166_cov_1392595.068376_g16269_i0 PRJNA309466 16326 166 1392595.068376 2311707.81350416 Neotrops pombero 1498340 Arthropoda Arthropoda 89.8 1.06e-13   NTclustered gi|646262523|gb|KF929078.1| 1498340 g16269 i0 100 29.2048192771084 48 0 29 0 1 48 1238 1285 Neotrops pombero isolate 94 18S ribosomal RNA gene, partial sequence blastn 4848 89.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Oonopidae Neotrops Neotrops pombero
8030065 8030065 PRJNA309466_P_NODE_19727_length_152_cov_3.310680_g19670_i0 PRJNA309466 19727 152 3.31068 5.0322336 Habrobracon hebetor 69819 Arthropoda Arthropoda 272 8.76e-69   NTclustered gi|144228089|gb|EF491261.1| 69819 g19670 i0 100 96.7171052631579 147 0 97 0 2 148 659 513 Bracon hebetor 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 14701 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Habrobracon Habrobracon hebetor
9991413 9991413 PRJNA309466_P_NODE_8008_length_215_cov_775334.463855_g7951_i0 PRJNA309466 8008 215 775334.463855 1666969.09728825 Isopoda 29979 Arthropoda Arthropoda 97.1 8.63e-16   NTclustered gi|374723326|gb|JF699563.1| 1131509 g7951 i0 96.552 27.446511627907 58 2 27 0 44 101 1511 1568 Ischyromene cordiforaminalis isolate 1128 voucher collection lot RW04.335 18S ribosomal RNA gene, partial sequence blastn 5901 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Sphaeromatidae Ischyromene Ischyromene cordiforaminalis
11266212 11266212 PRJNA309466_P_NODE_15569_length_169_cov_0.866667_g15512_i0 PRJNA309466 15569 169 0.866667 1.46466723 Neodiprion 270857 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2194848111|ref|XM_015669624.2| 441921 g15512 i0 100 0.662721893491124 28 0 17 0 44 71 1247 1220 PREDICTED: Neodiprion lecontei mitochondrial inner membrane protein OXA1L (LOC107228239), mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Neodiprion Neodiprion lecontei
12541489 12541489 PRJNA309466_P_NODE_13870_length_176_cov_3.960630_g13813_i0 PRJNA309466 13870 176 3.96063 6.9707088 Timema 61471 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1947877764|emb|OD571333.1| 61472 g13813 i0 90.698 0.852272727272727 43 3 43 1 120 162 1516 1475 4_Tbi_b3v08 blastn 150 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
12541765 12541765 PRJNA309466_P_NODE_9870_length_200_cov_5.178808_g9813_i0 PRJNA309466 9870 200 5.178808 10.357616 Geocoris 236434 Arthropoda Arthropoda 62.1 2.89e-5   NTclustered gi|1988752598|gb|MW629691.1| 300797 g9813 i0 89.796 0.49 49 3 24 1 153 199 2867 2819 Geocoris pallidipennis voucher EPTB121 large subunit ribosomal RNA gene, partial sequence blastn 98 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Geocoridae Geocoris Geocoris pallidipennis
13130636 13130636 PRJNA309466_P_NODE_19251_length_155_cov_3.811321_g19194_i0 PRJNA309466 19251 155 3.811321 5.90754755 Wasmannia auropunctata 64793 Arthropoda Arthropoda 161 2.03e-35   NTclustered gi|780698797|ref|XM_011703178.1| 64793 g19194 i0 87.77 21.2709677419355 139 15 89 2 17 154 289 152 PREDICTED: Wasmannia auropunctata 60S ribosomal protein L21 (LOC105458114), transcript variant X1, mRNA blastn 3297 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Wasmannia Wasmannia auropunctata
14405818 14405818 PRJNA309466_P_NODE_4772_length_263_cov_10.186916_g4715_i0 PRJNA309466 4772 263 10.186916 26.79158908 Ceraphron bispinosus 860923 Arthropoda Arthropoda 396 9.629999999999996e-106   NTclustered gi|300391014|gb|GQ374733.1| 860923 g4715 i0 94.231 98.836501901140707 260 13 98 2 2 260 33 291 Ceraphron bispinosus 28S ribosomal RNA gene, partial sequence blastn 25994 396 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ceraphronidae Ceraphron Ceraphron bispinosus
15090621 15090621 PRJNA309466_P_NODE_11792_length_187_cov_11.340580_g11735_i0 PRJNA309466 11792 187 11.34058 21.2068846 Hymenoptera 7399 Arthropoda Arthropoda 326 8.54e-85   NTclustered gi|1787460855|ref|XR_004228245.1| 7425 g11735 i0 98.901 97.3262032085562 182 2 97 0 4 185 3055 3236 PREDICTED: Nasonia vitripennis large subunit ribosomal RNA (LOC116418148), rRNA blastn 18200 326 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
15679563 15679563 PRJNA309466_P_NODE_16233_length_167_cov_0.881356_g16176_i0 PRJNA309466 16233 167 0.881356 1.47186452 Bombyx mori 7091 Arthropoda Arthropoda 296 5.86e-76   NTclustered gi|2909956442|dbj|AP039573.1| 7091 g16176 i0 100 40844.8682634731 160 0 98 0 8 167 11333868 11333709 Bombyx mori p50ma DNA, chromosome: 25 blastn 6821093 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
16365707 16365707 PRJNA309466_P_NODE_8553_length_210_cov_544555.285714_g8496_i0 PRJNA309466 8553 210 544555.285714 1143566.0999994 Archaeidae 336678 Arthropoda Arthropoda 99 2.33e-16   NTclustered gi|734673530|gb|KP201369.1| 412079 g8496 i0 96.61 27.2714285714286 59 2 28 0 47 105 1390 1448 Eriauchenius workmani isolate hw0069 18S ribosomal RNA gene, partial sequence blastn 5727 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Archaeidae Eriauchenius Eriauchenius workmani
16954108 16954108 PRJNA309466_P_NODE_10534_length_196_cov_1.387755_g10477_i0 PRJNA309466 10534 196 1.387755 2.7199998 Drosophila teissieri 7243 Arthropoda Arthropoda 60.2 1.01e-4   NTclustered gi|2098557278|ref|XM_043805163.1| 7243 g10477 i0 94.872 0.974489795918367 39 0 20 2 65 103 3798 3762 PREDICTED: Drosophila teissieri receptor-mediated endocytosis protein 6 homolog (LOC122625188), mRNA blastn 191 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila teissieri
18228463 18228463 PRJNA309466_P_NODE_12675_length_182_cov_965637.428571_g12618_i0 PRJNA309466 12675 182 965637.428571 1757460.11999922 Tetraponera bicolor 320724 Arthropoda Arthropoda 62.1 2.57e-5   NTclustered gi|76362322|dbj|AB208445.1| 320724 g12618 i0 100 26.0934065934066 33 0 18 0 43 75 656 624 Tetraponera bicolor gene for 28S rRNA, partial sequence blastn 4749 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Tetraponera Tetraponera bicolor
18228492 18228492 PRJNA309466_P_NODE_15415_length_169_cov_2.091667_g15358_i0 PRJNA309466 15415 169 2.091667 3.53491723 Tergilatus sparsus 2051689 Arthropoda Arthropoda 189 1.0299999999999998e-43   NTclustered gi|1282187789|gb|KY921994.1| 2051689 g15358 i0 88.024 12.5029585798817 167 10 98 8 1 166 2715 2872 Tergilatus sparsus voucher UMMZ BMOC 15-0717-007 AD1919 28S ribosomal RNA gene, partial sequence blastn 2113 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Tergilatus Tergilatus sparsus
24015077 24015077 PRJNA309466_P_NODE_8299_length_213_cov_1.896341_g8242_i0 PRJNA309466 8299 213 1.896341 4.03920633 Artemia 6660 Arthropoda Arthropoda 390 3.499999999999999e-104   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g8242 i0 100 26.6525821596244 211 0 99 0 3 213 85 295 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 5677 390 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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