RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA929924 · 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
27751742 27751742 PRJNA929924_P_NODE_15364_length_168_cov_0.873950_g15201_i0 PRJNA929924 15364 168 0.87395 1.468236 Escallonia rubra 112253 Plants Plants 57 8.89e-8   NR KAK2977287.1 112253 g15201 i0 49 1.83928571428571 51 26 91.1 0 164 12 168 218 KAK2977287.1 hypothetical protein RJ640_013052 [Escallonia rubra] diamond 309 57 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Escalloniales Escalloniaceae Escallonia Escallonia rubra
29898687 29898687 PRJNA929924_P_NODE_16891_length_165_cov_0.896552_g16728_i0 PRJNA929924 16891 165 0.896552 1.4793108 Prunus armeniaca 36596 Plants Plants 45.1 0.00196   NR CAB4295177.1 36596 g16728 i0 43.1 6.89090909090909 51 29 92.7 0 163 11 235 285 CAB4295177.1 unnamed protein product [Prunus armeniaca] diamond 1137 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus armeniaca
32340079 32340079 PRJNA929924_P_NODE_16939_length_165_cov_0.896552_g16776_i0 PRJNA929924 16939 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 45.1 0.00197   NR KAJ0205032.1 4236 g16776 i0 37 2.47272727272727 54 33 98.2 1 2 163 521 573 KAJ0205032.1 hypothetical protein LSAT_V11C500233370 [Lactuca sativa] diamond 408 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa

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