RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1057075" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1057075 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
1451258 1451258 PRJNA1057075_S_NODE_9022_length_163_cov_13.359649_g8923_i0 PRJNA1057075 9022 163 13.359649 21.77622787 Timema tahoe 61484 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1946537262|emb|OE128069.1| 61484 g8923 i0 100 0.177914110429448 29 0 18 0 57 85 88 60 4_Tte_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
2286558 2286558 PRJNA1057075_S_NODE_1902_length_288_cov_18.635983_g1803_i0 PRJNA1057075 1902 288 18.635983 53.67163104 Timema 61471 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|1936895876|emb|OA565436.1| 61478 g1803 i0 100 0.194444444444444 28 0 10 0 146 173 58706 58733 1_Tdi_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
2727105 2727105 PRJNA1057075_S_NODE_6543_length_182_cov_1.609023_g6444_i0 PRJNA1057075 6543 182 1.609023 2.92842186 Megalopta genalis 115081 Arthropoda Arthropoda 104 4.21e-18   NTclustered gi|1832189604|ref|XM_033472881.1| 115081 g6444 i0 89.157 0.708791208791209 83 9 46 0 2 84 315 397 PREDICTED: Megalopta genalis histone H2B (LOC117221711), mRNA blastn 129 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Megalopta Megalopta genalis
5279334 5279334 PRJNA1057075_S_NODE_1845_length_291_cov_8.818182_g1746_i0 PRJNA1057075 1845 291 8.818182 25.66090962 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 5.79e-4   NTclustered gi|1048003915|ref|XM_017627148.1| 28612 g1746 i0 100 0.106529209621993 31 0 11 0 34 64 708 738 PREDICTED: Rhagoletis zephyria uncharacterized LOC108371558 (LOC108371558), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
5279348 5279348 PRJNA1057075_S_NODE_4325_length_216_cov_2.898204_g4226_i0 PRJNA1057075 4325 216 2.898204 6.26012064 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1963345359|emb|OE839378.1| 629358 g4226 i0 100 0.773148148148148 29 0 13 0 141 169 6912 6940 5_Tge_b3v08 blastn 167 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
5279365 5279365 PRJNA1057075_S_NODE_7985_length_170_cov_1.280992_g7886_i0 PRJNA1057075 7985 170 1.280992 2.1776864 Malaya genurostris 325434 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2557286302|ref|XM_058589981.1| 325434 g7886 i0 100 0.494117647058824 28 0 16 0 49 76 6300 6273 PREDICTED: Malaya genurostris arginine/serine-rich coiled-coil protein 2-like (LOC131427070), transcript variant X2, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Malaya Malaya genurostris
7829188 7829188 PRJNA1057075_S_NODE_2487_length_265_cov_4.541667_g2388_i0 PRJNA1057075 2487 265 4.541667 12.03541755 Samia ricini 63990 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2883230424|dbj|AP038907.1| 63990 g2388 i0 100 0.105660377358491 28 0 11 0 31 58 1903849 1903822 Samia ricini White GU1 DNA, chromosome 12, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
9104224 9104224 PRJNA1057075_S_NODE_7388_length_174_cov_5.888000_g7289_i0 PRJNA1057075 7388 174 5.888 10.24512 Drymonia dodonaea 988176 Arthropoda Arthropoda 63.9 6.76e-6   NTclustered gi|2918369730|emb|OZ237797.1| 988176 g7289 i0 84.286 0.402298850574713 70 5 39 3 12 78 11309126 11309060 Drymonia dodonaea genome assembly, chromosome: 4 blastn 70 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
10379896 10379896 PRJNA1057075_S_NODE_3649_length_232_cov_4.409836_g3550_i0 PRJNA1057075 3649 232 4.409836 10.23081952 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2919531121|emb|OZ238343.1| 1002887 g3550 i0 100 0.120689655172414 28 0 12 0 143 170 23064710 23064683 Glaucopsyche melanops genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
10379914 10379914 PRJNA1057075_S_NODE_9929_length_157_cov_6.212963_g9830_i0 PRJNA1057075 9929 157 6.212963 9.75435191 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g9830 i0 94.595 0.942675159235669 37 0 22 2 42 76 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
18028413 18028413 PRJNA1057075_S_NODE_7415_length_174_cov_3.184000_g7316_i0 PRJNA1057075 7415 174 3.184 5.54016 Papilio polytes 76194 Arthropoda Arthropoda 296 6.12e-76   NTclustered gi|389615034|dbj|AK405121.1| 76194 g7316 i0 98.204 0.959770114942529 167 3 96 0 2 168 637 803 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 167 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
19302296 19302296 PRJNA1057075_S_NODE_1316_length_323_cov_7.036496_g1217_i0 PRJNA1057075 1316 323 7.036496 22.72788208 Eupodes cf. voxencollinus FP492 2696936 Arthropoda Arthropoda 562 1.1299999999999997e-155   NTclustered gi|1799126743|gb|MN241888.1| 2696936 g1217 i0 98.142 85.0959752321981 323 5 100 1 1 323 1742 2063 Eupodes cf. voxencollinus FP492 28S ribosomal RNA gene, partial sequence blastn 27486 562 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eupodidae Eupodes Eupodes cf. voxencollinus FP492
19302328 19302328 PRJNA1057075_S_NODE_9896_length_157_cov_13.731481_g9797_i0 PRJNA1057075 9896 157 13.731481 21.55842517 Eupodes cf. voxencollinus FP492 2696936 Arthropoda Arthropoda 285 1.17e-72   NTclustered gi|1799126733|gb|MN241878.1| 2696936 g9797 i0 99.363 100.152866242038 157 1 100 0 1 157 904 1060 Eupodes cf. voxencollinus FP492 18S ribosomal RNA gene, partial sequence blastn 15724 285 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eupodidae Eupodes Eupodes cf. voxencollinus FP492

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