RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1098727 · 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
26995446 26995446 PRJNA1098727_P_NODE_10522_length_187_cov_1.318841_g10281_i0 PRJNA1098727 10522 187 1.318841 2.46623267 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.1 5.46e-21   NR XP_054270932.1 74068 g10281 i0 74.5 24.1122994652406 47 12 75.4 0 3 143 117 163 XP_054270932.1 adenosine 5'-monophosphoramidase HINT1-like isoform X1 [Macrosteles quadrilineatus] diamond 4509 90.9 0.991199119911991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
28520483 28520483 PRJNA1098727_P_NODE_6467_length_246_cov_1.563452_g6226_i0 PRJNA1098727 6467 246 1.563452 3.84609192 Daphnia magna 35525 Arthropoda Arthropoda 40.4 0.0401   NR KZR97555.1 35525 g6226 i0 73.9 0.280487804878049 23 6 28 0 210 142 2 24 KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] diamond 69 40.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
32312579 32312579 PRJNA1098727_P_NODE_13119_length_168_cov_0.873950_g12878_i0 PRJNA1098727 13119 168 0.87395 1.468236 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 114 8.280000000000001e-29   NR XP_055305540.1 263140 g12878 i0 90.9 0.982142857142857 55 5 98.2 0 2 166 229 283 XP_055305540.1 venom protease-like isoform X2 [Sitodiplosis mosellana] diamond 165 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana

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