RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA322517" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA322517 · 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
389208 389208 PRJNA322517_P_NODE_2201_length_323_cov_1.167883_g2179_i0 PRJNA322517 2201 323 1.167883 3.77226209 Eurosta solidaginis 178769 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2792493673|ref|XM_067775972.1| 178769 g2179 i0 100 1.52631578947368 29 0 9 0 218 246 8239 8267 PREDICTED: Eurosta solidaginis Enhancer of Polycomb (E(Pc)), transcript variant X11, mRNA blastn 493 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Eurosta Eurosta solidaginis
1069157 1069157 PRJNA322517_P_NODE_1901_length_354_cov_20.157377_g1879_i0 PRJNA322517 1901 354 20.157377 71.35711458 Lepidoptera 7088 Arthropoda Arthropoda 309 1.8e-79   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g1879 i0 100 164.245762711864 167 0 47 0 188 354 8662419 8662585 Bombyx mori DNA, chromosome 22, sequence blastn 58143 311 0.993569131832797 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
3619808 3619808 PRJNA322517_P_NODE_1983_length_345_cov_21.250000_g1961_i0 PRJNA322517 1983 345 21.25 73.3125 Lepidoptera 7088 Arthropoda Arthropoda 309 1.75e-79   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g1961 i0 100 148.878260869565 167 0 48 0 179 345 8662419 8662585 Bombyx mori DNA, chromosome 22, sequence blastn 51363 311 0.993569131832797 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
3619810 3619810 PRJNA322517_P_NODE_3803_length_205_cov_2.448718_g3781_i0 PRJNA322517 3803 205 2.448718 5.0198719 Opisthokonta 33154 Arthropoda Arthropoda 113 8.1e-21   NTclustered gi|225006190|dbj|AB490338.1| 319348 g3781 i0 98.438 30.9170731707317 64 1 31 0 8 71 1341 1404 Polypedilum vanderplanki PvEf1-alpha mRNA for elongation factor 1-alpha, complete cds blastn 6338 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
5492886 5492886 PRJNA322517_P_NODE_6445_length_154_cov_2.914286_g6423_i0 PRJNA322517 6445 154 2.914286 4.48800044 Bombyx mori 7091 Arthropoda Arthropoda 285 1.14e-72   NTclustered gi|2919985587|emb|OZ208560.1| 7091 g6423 i0 100 33.8051948051948 154 0 100 0 1 154 7232817 7232664 Bombyx mori genome assembly, chromosome: 11 blastn 5206 285 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
7447023 7447023 PRJNA322517_P_NODE_1686_length_377_cov_19.079268_g1664_i0 PRJNA322517 1686 377 19.079268 71.92884036 Lepidoptera 7088 Arthropoda Arthropoda 309 1.93e-79   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g1664 i0 100 136.241379310345 167 0 44 0 1 167 8662585 8662419 Bombyx mori DNA, chromosome 22, sequence blastn 51363 311 0.993569131832797 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
9997282 9997282 PRJNA322517_P_NODE_2048_length_338_cov_21.885813_g2026_i0 PRJNA322517 2048 338 21.885813 73.97404794 Lepidoptera 7088 Arthropoda Arthropoda 309 1.71e-79   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g2026 i0 100 151.961538461538 167 0 49 0 172 338 8662419 8662585 Bombyx mori DNA, chromosome 22, sequence blastn 51363 311 0.993569131832797 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
13142749 13142749 PRJNA322517_P_NODE_2311_length_314_cov_4.260377_g2289_i0 PRJNA322517 2311 314 4.260377 13.37758378 Bombyx mori 7091 Arthropoda Arthropoda 580 3.0299999999999992e-161   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g2289 i0 100 431.796178343949 314 0 100 0 1 314 4405112 4405425 Bombyx mori genome assembly, chromosome: 11 blastn 135584 580 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
13822580 13822580 PRJNA322517_P_NODE_3451_length_221_cov_3.744186_g3429_i0 PRJNA322517 3451 221 3.744186 8.27465106 Bombyx 7090 Arthropoda Arthropoda 403 4.69e-108   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g3429 i0 99.548 236.0407239819 221 1 100 0 1 221 8653232 8653012 Bombyx mori DNA, chromosome 22, sequence blastn 52165 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
15096968 15096968 PRJNA322517_P_NODE_3372_length_227_cov_0.926966_g3350_i0 PRJNA322517 3372 227 0.926966 2.10421282 Opisthokonta 33154 Arthropoda Arthropoda 176 1.15e-39   NTclustered gi|2874207254|ref|XM_070637547.1| 113505 g3350 i0 84.971 95.0881057268722 173 26 76 0 1 173 265 93 PREDICTED: Chironomus tepperi ribosomal protein L40 (RpL40), mRNA blastn 21585 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
15096969 15096969 PRJNA322517_P_NODE_3452_length_221_cov_3.459302_g3430_i0 PRJNA322517 3452 221 3.459302 7.64505742 Bombyx 7090 Arthropoda Arthropoda 409 1.0100000000000001e-109   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g3430 i0 100 256.298642533937 221 0 100 0 1 221 4404956 4404736 Bombyx mori genome assembly, chromosome: 11 blastn 56642 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
15691894 15691894 PRJNA322517_P_NODE_2693_length_280_cov_3.025974_g2671_i0 PRJNA322517 2693 280 3.025974 8.4727272 Bombyx mori 7091 Arthropoda Arthropoda 518 2.12e-142   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g2671 i0 100 828.121428571429 280 0 100 0 1 280 4364233 4364512 Bombyx mori genome assembly, chromosome: 11 blastn 231874 518 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
15691959 15691959 PRJNA322517_P_NODE_4633_length_181_cov_2.553030_g4611_i0 PRJNA322517 4633 181 2.55303 4.6209843 Bombyx mori 7091 Arthropoda Arthropoda 335 1.36e-87   NTclustered gi|2909956435|dbj|AP039566.1| 7091 g4611 i0 100 80.4696132596685 181 0 100 0 1 181 11452722 11452902 Bombyx mori p50ma DNA, chromosome: 19 blastn 14565 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
16371708 16371708 PRJNA322517_P_NODE_3433_length_222_cov_3.705202_g3411_i0 PRJNA322517 3433 222 3.705202 8.22554844 Bombyx 7090 Arthropoda Arthropoda 411 2.8199999999999996e-110   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g3411 i0 100 198.306306306306 222 0 100 0 1 222 8652920 8652699 Bombyx mori DNA, chromosome 22, sequence blastn 44024 411 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
21470871 21470871 PRJNA322517_P_NODE_3797_length_205_cov_5.371795_g3775_i0 PRJNA322517 3797 205 5.371795 11.01217975 Bombyx 7090 Arthropoda Arthropoda 379 7.229999999999999e-101   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g3775 i0 100 238.921951219512 205 0 100 0 1 205 8652364 8652160 Bombyx mori DNA, chromosome 22, sequence blastn 48979 379 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
22065624 22065624 PRJNA322517_P_NODE_2018_length_341_cov_2.763699_g1996_i0 PRJNA322517 2018 341 2.763699 9.42421359 Bombyx mori 7091 Arthropoda Arthropoda 630 3.2499999999999986e-176   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g1996 i0 100 250.815249266862 341 0 100 0 1 341 4400079 4400419 Bombyx mori genome assembly, chromosome: 11 blastn 85528 630 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
22746037 22746037 PRJNA322517_P_NODE_2338_length_312_cov_7.984791_g2316_i0 PRJNA322517 2338 312 7.984791 24.91254792 Lepidoptera 7088 Arthropoda Arthropoda 577 3.89e-160   NTclustered gi|560190490|gb|KF611783.1| 7091 g2316 i0 100 371.419871794872 312 0 100 0 1 312 318 7 Bombyx mori isolate AVVMTKB1 18S ribosomal RNA gene, partial sequence blastn 115883 577 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
24615259 24615259 PRJNA322517_P_NODE_1260_length_445_cov_4.770202_g1238_i0 PRJNA322517 1260 445 4.770202 21.2273989 Bombyx mori 7091 Arthropoda Arthropoda 822 0   NTclustered gi|2919985616|emb|OZ208589.1| 7091 g1238 i0 100 500.795505617978 445 0 100 0 1 445 4409166 4408722 Bombyx mori genome assembly, chromosome: 11 blastn 222854 822 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
24615347 24615347 PRJNA322517_P_NODE_3240_length_235_cov_1.177419_g3218_i0 PRJNA322517 3240 235 1.177419 2.76693465 Shevtchenkella serrata 2883626 Arthropoda Arthropoda 91.6 4.46e-14   NTclustered gi|2112782721|gb|OK491613.1| 2883626 g3218 i0 84.211 30.0127659574468 95 13 40 2 1 94 1968 1875 Shevtchenkella serrata isolate d241proto large subunit ribosomal RNA gene, partial sequence blastn 7053 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Shevtchenkella Shevtchenkella serrata
32540965 32540965 PRJNA322517_P_NODE_4979_length_174_cov_2.360000_g4957_i0 PRJNA322517 4979 174 2.36 4.1064 Nymphon striatum 424472 Arthropoda Arthropoda 45.1 0.00234   NR KAG1708490.1 424472 g4957 i0 38.8 4.22413793103448 49 30 84.5 0 171 25 793 841 KAG1708490.1 RNA-directed DNA polymerase from mobile element jockey [Nymphon striatum] diamond 735 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum

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