RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA596867" 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

  • PRJNA596867 · 20 ✖

analysis 1

  • diamond · 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
9496467 9496467 PRJNA596867_P_NODE_9948_length_267_cov_1.536082_g9873_i0 PRJNA596867 9948 267 1.536082 4.10133894 Spodoptera exigua 7107 Arthropoda Arthropoda 119 3.6e-30   NR KAF9411221.1 7107 g9873 i0 88.5 1.37078651685393 61 7 68.5 0 220 38 286 346 KAF9411221.1 hypothetical protein HW555_009935 [Spodoptera exigua] diamond 366 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
20970225 20970225 PRJNA596867_P_NODE_11677_length_250_cov_0.870056_g11602_i0 PRJNA596867 11677 250 0.870056 2.17514 Spodoptera littoralis 7109 Arthropoda Arthropoda 62.4 4.73e-9   NR CAB3508371.1 7109 g11602 i0 75 0.384 32 8 38.4 0 114 19 400 431 CAB3508371.1 unnamed protein product [Spodoptera littoralis] diamond 96 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
26953094 26953094 PRJNA596867_P_NODE_12942_length_247_cov_0.885057_g12867_i0 PRJNA596867 12942 247 0.885057 2.18609079 Sergentomyia squamirostris 2283857 Arthropoda Arthropoda 43.1 0.0289   NR GAB0094729.1 2283857 g12867 i0 39.6 0.582995951417004 48 27 55.9 1 241 104 12 59 GAB0094729.1 Probable beta-hexosaminidase fdl [Sergentomyia squamirostris] diamond 144 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Sergentomyia Sergentomyia squamirostris
26966581 26966581 PRJNA596867_P_NODE_4082_length_378_cov_2.547541_g4007_i0 PRJNA596867 4082 378 2.547541 9.62970498 Metazoa 33208 Arthropoda Arthropoda 49.7 5.52e-4   NR XP_023015979.1 7539 g4007 i0 59 2.15079365079365 39 15 30.2 1 215 102 292 330 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 813 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
27205975 27205975 PRJNA596867_P_NODE_14622_length_242_cov_1.076923_g14547_i0 PRJNA596867 14622 242 1.076923 2.60615366 Spodoptera frugiperda 7108 Arthropoda Arthropoda 44.3 0.0109   NR KAF9807223.1 7108 g14547 i0 68.6 0.433884297520661 35 6 37.2 1 91 2 25 59 KAF9807223.1 hypothetical protein SFRURICE_008616 [Spodoptera frugiperda] diamond 105 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
28374605 28374605 PRJNA596867_P_NODE_15066_length_241_cov_0.916667_g14991_i0 PRJNA596867 15066 241 0.916667 2.20916747 Venturia canescens 32260 Arthropoda Arthropoda 78.6 5.16e-15   NR XP_043275055.1 32260 g14991 i0 78.8 0.647302904564315 52 11 64.7 0 156 1 1 52 XP_043275055.1 m7GpppX diphosphatase [Venturia canescens] diamond 156 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
28879775 28879775 PRJNA596867_P_NODE_13208_length_246_cov_0.890173_g13133_i0 PRJNA596867 13208 246 0.890173 2.18982558 Anthonomus grandis grandis 2921223 Arthropoda Arthropoda 119 5.74e-29   NR XP_050297424.1 2921223 g13133 i0 70.4 0.98780487804878 81 23 98.8 1 2 244 397 476 XP_050297424.1 transferrin-like isoform X2 [Anthonomus grandis grandis] diamond 243 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis
28911120 28911120 PRJNA596867_P_NODE_11808_length_250_cov_0.870056_g11733_i0 PRJNA596867 11808 250 0.870056 2.17514 Spodoptera littoralis 7109 Arthropoda Arthropoda 109 7.29e-28   NR CAB3515749.1 7109 g11733 i0 73.9 0.828 69 18 82.8 0 247 41 123 191 CAB3515749.1 unnamed protein product [Spodoptera littoralis] diamond 207 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
29100943 29100943 PRJNA596867_P_NODE_5688_length_334_cov_1.176245_g5613_i0 PRJNA596867 5688 334 1.176245 3.9286583 Spodoptera frugiperda 7108 Arthropoda Arthropoda 116 1.87e-28   NR XP_050555633.1 7108 g5613 i0 65.6 0.835329341317365 93 27 83.5 2 55 333 1 88 XP_050555633.1 uncharacterized protein LOC118276695 [Spodoptera frugiperda] diamond 279 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
29511199 29511199 PRJNA596867_P_NODE_6370_length_320_cov_1.246964_g6295_i0 PRJNA596867 6370 320 1.246964 3.9902848 Spodoptera littoralis 7109 Arthropoda Arthropoda 211 2.1799999999999993e-68   NR CAH1647782.1 7109 g6295 i0 92.5 0.99375 106 8 99.4 0 318 1 4 109 CAH1647782.1 unnamed protein product [Spodoptera littoralis] diamond 318 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
29890437 29890437 PRJNA596867_P_NODE_6691_length_314_cov_1.257261_g6616_i0 PRJNA596867 6691 314 1.257261 3.94779954 Spodoptera littoralis 7109 Arthropoda Arthropoda 199 1.93e-63   NR CAB3514463.1 7109 g6616 i0 98.9 0.898089171974522 94 1 89.8 0 312 31 53 146 CAB3514463.1 unnamed protein product [Spodoptera littoralis] diamond 282 199 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
30016733 30016733 PRJNA596867_P_NODE_15131_length_241_cov_0.916667_g15056_i0 PRJNA596867 15131 241 0.916667 2.20916747 Colias croceus 72248 Arthropoda Arthropoda 48.5 3.15e-4   NR XP_045506216.1 72248 g15056 i0 48 0.622406639004149 50 26 62.2 0 215 66 210 259 XP_045506216.1 uncharacterized protein LOC123702483 [Colias croceus] diamond 150 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Colias Colias croceus
30333064 30333064 PRJNA596867_P_NODE_8912_length_279_cov_2.907767_g8837_i0 PRJNA596867 8912 279 2.907767 8.11266993 Spodoptera exigua 7107 Arthropoda Arthropoda 63.9 8e-11   NR CAH0698683.1 7107 g8837 i0 67.9 0.56989247311828 53 10 57 2 250 92 1 46 CAH0698683.1 unnamed protein product [Spodoptera exigua] diamond 159 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
31009429 31009429 PRJNA596867_P_NODE_13274_length_246_cov_0.890173_g13199_i0 PRJNA596867 13274 246 0.890173 2.18982558 Opisthokonta 33154 Arthropoda Arthropoda 43.1 0.0282   NR RVE42834.1 168631 g13199 i0 31.3 1.78048780487805 80 50 91.5 2 245 21 36 115 RVE42834.1 hypothetical protein evm_012509 [Chilo suppressalis] diamond 438 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Chilo Chilo suppressalis
31248832 31248832 PRJNA596867_P_NODE_13235_length_246_cov_0.890173_g13160_i0 PRJNA596867 13235 246 0.890173 2.18982558 Spodoptera frugiperda 7108 Arthropoda Arthropoda 96.7 4.19e-21   NR XP_050556618.1 7108 g13160 i0 64.6 0.963414634146341 79 23 96.3 1 3 239 1695 1768 XP_050556618.1 mucin-17-like [Spodoptera frugiperda] diamond 237 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
31881340 31881340 PRJNA596867_P_NODE_12577_length_248_cov_0.880000_g12502_i0 PRJNA596867 12577 248 0.88 2.1824 Helicoverpa armigera 29058 Arthropoda Arthropoda 82.4 4.22e-16   NR PZC85949.1 29058 g12502 i0 56.8 0.979838709677419 81 31 98 3 244 2 138 214 PZC85949.1 hypothetical protein B5X24_HaOG214314 [Helicoverpa armigera] diamond 243 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
31989701 31989701 PRJNA596867_P_NODE_12298_length_249_cov_0.863636_g12223_i0 PRJNA596867 12298 249 0.863636 2.15045364 Timema 61471 Arthropoda Arthropoda 43.9 0.015   NR CAD7441438.1 61472 g12223 i0 30.3 1.59036144578313 66 40 72.3 1 12 191 239 304 CAD7441438.1 unnamed protein product [Timema bartmani] diamond 396 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
32102919 32102919 PRJNA596867_P_NODE_13038_length_246_cov_3.531792_g12963_i0 PRJNA596867 13038 246 3.531792 8.68820832 Spodoptera exigua 7107 Arthropoda Arthropoda 60.1 1.8e-9   NR CAH0698683.1 7107 g12963 i0 62.3 0.646341463414634 53 13 64.6 2 213 55 1 46 CAH0698683.1 unnamed protein product [Spodoptera exigua] diamond 159 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
32229720 32229720 PRJNA596867_P_NODE_6438_length_318_cov_3.020408_g6363_i0 PRJNA596867 6438 318 3.020408 9.60489744 Spodoptera exigua 7107 Arthropoda Arthropoda 140 5.73e-41   NR KAH9631526.1 7107 g6363 i0 77.9 0.811320754716981 86 19 81.1 0 284 27 1 86 KAH9631526.1 hypothetical protein HF086_004687 [Spodoptera exigua] diamond 258 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
32860892 32860892 PRJNA596867_P_NODE_14640_length_242_cov_0.911243_g14565_i0 PRJNA596867 14640 242 0.911243 2.20520806 Venturia canescens 32260 Arthropoda Arthropoda 143 6.05e-38   NR XP_043271650.1 32260 g14565 i0 91 0.966942148760331 78 7 96.7 0 242 9 470 547 XP_043271650.1 rab5 GDP/GTP exchange factor [Venturia canescens] diamond 234 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens

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