RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1228616" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1228616 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
335577 335577 PRJNA1228616_S_NODE_5181_length_184_cov_3.042553_g5158_i0 PRJNA1228616 5181 184 3.042553 5.59829752 Timema poppense 170557 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1946896637|emb|OD014535.1| 170557 g5158 i0 96.97 0.179347826086957 33 1 18 0 70 102 7407 7375 1_Tps_b3v08 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
1047092 1047092 PRJNA1228616_S_NODE_3301_length_220_cov_2.073446_g3278_i0 PRJNA1228616 3301 220 2.073446 4.5615812 Timema 61471 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|1936889605|emb|OA565165.1| 61478 g3278 i0 100 0.254545454545455 28 0 13 0 193 220 79570 79597 1_Tdi_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
7988999 7988999 PRJNA1228616_S_NODE_4927_length_188_cov_1.462069_g4904_i0 PRJNA1228616 4927 188 1.462069 2.74868972 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1965352207|emb|OE839441.1| 629358 g4904 i0 100 0.148936170212766 28 0 15 0 104 131 297109 297136 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
10539436 10539436 PRJNA1228616_S_NODE_3629_length_212_cov_2.124260_g3606_i0 PRJNA1228616 3629 212 2.12426 4.5034312 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|2918386054|emb|OZ238097.1| 346795 g3606 i0 96.774 0.14622641509434 31 1 15 0 128 158 16006770 16006740 Longitarsus dorsalis genome assembly, chromosome: 4 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
11814188 11814188 PRJNA1228616_S_NODE_1450_length_297_cov_3.307087_g1427_i0 PRJNA1228616 1450 297 3.307087 9.82204839 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1965181363|emb|OE475415.1| 61474 g1427 i0 90.909 0.148148148148148 44 1 14 2 232 272 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
11814197 11814197 PRJNA1228616_S_NODE_590_length_394_cov_8.937322_g567_i0 PRJNA1228616 590 394 8.937322 35.21304868 Timema monikensis 170555 Arthropoda Arthropoda 58.4 8.1e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g567 i0 97.059 0.228426395939086 34 1 9 0 285 318 168543 168510 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
14364557 14364557 PRJNA1228616_S_NODE_2472_length_246_cov_5.788177_g2449_i0 PRJNA1228616 2472 246 5.788177 14.23891542 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1946147745|emb|OD000010.1| 170557 g2449 i0 96.774 0.126016260162602 31 1 13 0 189 219 48332 48302 1_Tps_b3v08 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
18187106 18187106 PRJNA1228616_S_NODE_1415_length_299_cov_3.746094_g1392_i0 PRJNA1228616 1415 299 3.746094 11.20082106 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g1392 i0 96.875 0.214046822742475 32 1 11 0 118 149 24059155 24059124 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
20173430 20173430 PRJNA1228616_S_NODE_696_length_375_cov_5.397590_g673_i0 PRJNA1228616 696 375 5.39759 20.2409625 Timema 61471 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1947819235|emb|OD566261.1| 61472 g673 i0 100 0.154666666666667 29 0 8 0 124 152 111477 111505 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
24561757 24561757 PRJNA1228616_S_NODE_5520_length_180_cov_1.832117_g5497_i0 PRJNA1228616 5520 180 1.832117 3.2978106 Cydia pomonella 82600 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g5497 i0 100 0.311111111111111 28 0 16 0 19 46 126 99 PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
24561761 24561761 PRJNA1228616_S_NODE_6820_length_166_cov_1.146341_g6797_i0 PRJNA1228616 6820 166 1.146341 1.90292606 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 60.2 8.31e-5   NTclustered gi|2919538070|emb|OZ238348.1| 1002887 g6797 i0 97.222 0.578313253012048 36 0 22 1 22 57 23637999 23637965 Glaucopsyche melanops genome assembly, chromosome: 7 blastn 96 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops

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