RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA720429" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA720429 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
709963 709963 PRJNA720429_P_NODE_2041_length_298_cov_1.026667_g1984_i0 PRJNA720429 2041 298 1.026667 3.05946766 Liposcelis paeta 209927 Arthropoda Arthropoda 189 2.02e-43   NTclustered gi|557954255|gb|KF649225.1| 209927 g1984 i0 83.333 35.496644295302 216 24 71 10 88 298 7038 7246 Liposcelis paeta minichromosome II mitochondrion, complete sequence blastn 10578 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis paeta
5813551 5813551 PRJNA720429_P_NODE_1985_length_302_cov_1.890830_g1928_i0 PRJNA720429 1985 302 1.89083 5.7103066 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1946153605|emb|OD012397.1| 170557 g1928 i0 100 0.0927152317880795 28 0 9 0 150 177 9148 9121 1_Tps_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
12189316 12189316 PRJNA720429_P_NODE_4870_length_242_cov_0.911243_g4813_i0 PRJNA720429 4870 242 0.911243 2.20520806 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1535900673|ref|XM_027349550.1| 6956 g4813 i0 96.875 0.132231404958678 32 1 13 0 147 178 34 3 PREDICTED: Dermatophagoides pteronyssinus ankyrin repeat and KH domain-containing protein mask-like (LOC113798956), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
16496490 16496490 PRJNA720429_P_NODE_1713_length_322_cov_1.228916_g1656_i0 PRJNA720429 1713 322 1.228916 3.95710952 Insecta 50557 Arthropoda Arthropoda 147 1.35e-30   NTclustered gi|545909513|gb|KF528387.1| 222813 g1656 i0 93.069 29.9937888198758 101 6 31 1 5 104 770 670 Xiphydria prolongata voucher P1815 28S ribosomal RNA gene, partial sequence blastn 9658 148 0.993243243243243 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Xiphydriidae Xiphydria Xiphydria prolongata
17288027 17288027 PRJNA720429_P_NODE_3794_length_248_cov_0.880000_g3737_i0 PRJNA720429 3794 248 0.88 2.1824 Zerynthia rumina 132710 Arthropoda Arthropoda 58.4 4.82e-4   NTclustered gi|2918382960|emb|OZ238066.1| 132710 g3737 i0 92.683 0.165322580645161 41 2 17 1 140 180 14560642 14560603 Zerynthia rumina genome assembly, chromosome: Z blastn 41 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
21112611 21112611 PRJNA720429_P_NODE_4117_length_246_cov_1.572254_g4060_i0 PRJNA720429 4117 246 1.572254 3.86774484 Anabrus simplex 316456 Arthropoda Arthropoda 176 1.26e-39   NTclustered gi|2801270950|ref|XM_067152723.2| 316456 g4060 i0 80.258 43.8739837398374 233 46 95 0 10 242 384 616 PREDICTED: Anabrus simplex arginine kinase (LOC136879019), transcript variant X1, mRNA blastn 10793 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
24936558 24936558 PRJNA720429_P_NODE_3880_length_248_cov_0.880000_g3823_i0 PRJNA720429 3880 248 0.88 2.1824 Drosophila gunungcola 103775 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2427892456|ref|XM_053002247.1| 103775 g3823 i0 100 1.01612903225806 28 0 11 0 140 167 2405 2432 PREDICTED: Drosophila gunungcola potassium voltage-gated channel protein Shaker (LOC128265985), transcript variant X8, mRNA blastn 252 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila gunungcola

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