RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA438687" 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

  • PRJNA438687 · 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
435248 435248 PRJNA438687_S_NODE_121_length_657_cov_17.649518_g82_i0 PRJNA438687 121 657 17.649518 115.95733326 Daphnia pulex 6669 Arthropoda Arthropoda 360 7.52e-123   NR EFX60189.1 6669 g82 i0 89 0.995433789954338 218 1 99.5 1 657 4 122 316 EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] diamond 654 360 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
4919388 4919388 PRJNA438687_S_NODE_704_length_417_cov_3.743455_g615_i0 PRJNA438687 704 417 3.743455 15.61020735 Ixodidae 6939 Arthropoda Arthropoda 77.4 2.85e-15   NR KAL3212956.1 6941 g615 i0 56.7 0.863309352517986 60 26 43.2 0 328 149 57 116 KAL3212956.1 hypothetical protein MRX96_035779 [Rhipicephalus microplus] diamond 360 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
32841785 32841785 PRJNA438687_S_NODE_1920_length_310_cov_4.690909_g1830_i0 PRJNA438687 1920 310 4.690909 14.5418179 Araneae 6893 Arthropoda Arthropoda 53.5 4.84e-6   NR KFM60918.1 407821 g1830 i0 51.7 1.21935483870968 58 28 56.1 0 25 198 98 155 KFM60918.1 hypothetical protein X975_13633, partial [Stegodyphus mimosarum] diamond 378 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum

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