RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA645397" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA645397 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2434342 2434342 PRJNA645397_S_NODE_162_length_358_cov_2.074434_g160_i0 PRJNA645397 162 358 2.074434 7.42647372 Drosophila 7215 Arthropoda Arthropoda 58.4 7.29e-4   NTclustered gi|2617354815|ref|XM_060808188.1| 42062 g160 i0 100 1.5055865921787699 31 0 9 0 41 71 77 107 PREDICTED: Drosophila nasuta potassium voltage-gated channel protein Shaker (LOC132796862), transcript variant X2, mRNA blastn 539 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
4447323 4447323 PRJNA645397_P_NODE_10124_length_165_cov_1.344828_g10051_i0 PRJNA645397 10124 165 1.344828 2.2189662 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2918376580|emb|OZ238010.1| 307131 g10051 i0 96.875 1.9030303030303 32 1 19 0 47 78 7913943 7913974 Ceutorhynchus obstrictus genome assembly, chromosome: 1 blastn 314 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
6998190 6998190 PRJNA645397_P_NODE_3706_length_280_cov_0.943723_g3633_i0 PRJNA645397 3706 280 0.943723 2.6424244 Aphis glycines 307491 Arthropoda Arthropoda 501 2.13e-137   NTclustered gi|402170154|gb|JQ259057.1| 307491 g3633 i0 98.929 99.0714285714286 280 3 100 0 1 280 1707 1428 Aphis glycines 28S ribosomal RNA gene, partial sequence blastn 27740 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines
10087680 10087680 PRJNA645397_P_NODE_7968_length_183_cov_0.970149_g7895_i0 PRJNA645397 7968 183 0.970149 1.77537267 Insecta 50557 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1962695364|emb|OE197254.1| 61474 g7895 i0 100 2.26775956284153 29 0 16 0 88 116 211 183 2_Tcm_b3v08 blastn 415 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
11362583 11362583 PRJNA645397_S_NODE_949_length_191_cov_1.774648_g947_i0 PRJNA645397 949 191 1.774648 3.38957768 root 1 Root_unresolved Root_unresolved 52.8 0.016   NTclustered gi|2639390682|ref|XM_061868808.1| 82600 g947 i0 100 0.586387434554974 28 0 15 0 59 86 126 99 PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
15922458 15922458 PRJNA645397_P_NODE_8673_length_174_cov_1.432000_g8600_i0 PRJNA645397 8673 174 1.432 2.49168 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918386103|emb|OZ238124.1| 876074 g8600 i0 96.97 1.95977011494253 33 1 19 0 64 96 27495834 27495866 Satyrium ilicis genome assembly, chromosome: 15 blastn 341 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis

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