RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA784979 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
29421865 29421865 PRJNA784979_S_NODE_8689_length_176_cov_2.409449_g8647_i0 PRJNA784979 8689 176 2.409449 4.24063024 Drosophila erecta 7220 Arthropoda Arthropoda 88.6 2e-19   NR XP_026838606.1 7220 g8647 i0 91.8 0.835227272727273 49 4 83.5 0 2 148 191 239 XP_026838606.1 LOW QUALITY PROTEIN: uncharacterized protein LOC113564595, partial [Drosophila erecta] diamond 147 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
30125892 30125892 PRJNA784979_S_NODE_6712_length_194_cov_0.689655_g6670_i0 PRJNA784979 6712 194 0.689655 1.3379307 Opisthokonta 33154 Arthropoda Arthropoda 51.6 1.42e-5   NR KAL3192712.1 6941 g6670 i0 78.1 2.62886597938144 32 7 49.5 0 100 5 215 246 KAL3192712.1 hypothetical protein MRX96_058767 [Rhipicephalus microplus] diamond 510 52 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
32866261 32866261 PRJNA784979_S_NODE_7280_length_188_cov_1.525180_g7238_i0 PRJNA784979 7280 188 1.52518 2.8673384 Artemia franciscana 6661 Arthropoda Arthropoda 107 1.7e-25   NR KAK2707618.1 6661 g7238 i0 100 0.877659574468085 55 0 87.8 0 165 1 338 392 KAK2707618.1 hypothetical protein QYM36_015356 [Artemia franciscana] diamond 165 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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