RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB6055" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB6055 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
125552 125552 PRJEB6055_S_NODE_5861_length_151_cov_1.551724_g5837_i0 PRJEB6055 5861 151 1.551724 2.34310324 Anopheles cruzii 68878 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2428887502|ref|XM_053009323.1| 68878 g5837 i0 97.059 0.225165562913907 34 0 22 1 117 149 774 741 PREDICTED: Anopheles cruzii alpha-protein kinase 1-like (LOC128271702), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles cruzii
2675613 2675613 PRJEB6055_S_NODE_1963_length_220_cov_6.913514_g1939_i0 PRJEB6055 1963 220 6.913514 15.2097308 Calliphora vicina 7373 Arthropoda Arthropoda 100 6.86e-17   NTclustered gi|2736842296|ref|XM_065511938.1| 7373 g1939 i0 88.095 2.50454545454545 84 10 38 0 93 176 188 271 PREDICTED: Calliphora vicina ribosomal protein L39 (RpL39), mRNA blastn 551 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
2675628 2675628 PRJEB6055_S_NODE_5203_length_158_cov_2.747967_g5179_i0 PRJEB6055 5203 158 2.747967 4.34178786 Aphidius gifuensis 684658 Arthropoda Arthropoda 62.1 2.17e-5   NTclustered gi|2106751046|ref|XM_044158564.1| 684658 g5179 i0 100 0.208860759493671 33 0 21 0 43 75 1922 1890 PREDICTED: Aphidius gifuensis putative histone-lysine N-methyltransferase 1 (LOC122856755), mRNA blastn 33 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
5228088 5228088 PRJEB6055_S_NODE_2165_length_213_cov_3.870787_g2141_i0 PRJEB6055 2165 213 3.870787 8.24477631 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 4.03e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g2141 i0 90.698 0.2018779342723 43 4 20 0 50 92 56559237 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
9052815 9052815 PRJEB6055_S_NODE_588_length_322_cov_1.623693_g564_i0 PRJEB6055 588 322 1.623693 5.22829146 Microplitis demolitor 69319 Arthropoda Arthropoda 63.9 1.4e-5   NTclustered gi|2445542943|ref|XM_008548042.2| 69319 g564 i0 78.302 12.1180124223602 106 17 32 6 50 152 636 534 PREDICTED: Microplitis demolitor dnaJ homolog subfamily B member 12 (LOC103570332), mRNA blastn 3902 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
12879171 12879171 PRJEB6055_S_NODE_1571_length_235_cov_38.995000_g1547_i0 PRJEB6055 1571 235 38.995 91.63825 Bombus monticola 103936 Arthropoda Arthropoda 58.4 4.53e-4   NTclustered gi|2919524519|emb|OZ238329.1| 103936 g1547 i0 100 0.85531914893617 31 0 13 0 1 31 2951202 2951172 Bombus monticola genome assembly, chromosome: 7 blastn 201 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus monticola
13745713 13745713 PRJEB6055_S_NODE_2631_length_199_cov_8.219512_g2607_i0 PRJEB6055 2631 199 8.219512 16.35682888 Lucilia 7374 Arthropoda Arthropoda 169 1.64e-37   NTclustered gi|2202972731|ref|XM_023452677.2| 7375 g2607 i0 92.373 59.2763819095477 118 9 59 0 64 181 1245 1128 PREDICTED: Lucilia cuprina actin-57B (LOC111690227), mRNA blastn 11796 169 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
16294933 16294933 PRJEB6055_S_NODE_4213_length_171_cov_1.867647_g4189_i0 PRJEB6055 4213 171 1.867647 3.19367637 Glycyphagidae 83156 Arthropoda Arthropoda 305 9.96e-79   NTclustered gi|125616828|gb|EF203771.1| 36936 g4189 i0 98.837 98.5789473684211 172 1 100 1 1 171 89 260 Lepidoglyphus destructor 18S ribosomal RNA gene, partial sequence blastn 16857 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Glycyphagidae Lepidoglyphus Lepidoglyphus destructor

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