RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA306153" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA306153 · 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
27168831 27168831 PRJNA306153_S_NODE_902_length_251_cov_3.536036_g889_i0 PRJNA306153 902 251 3.536036 8.87545036 Pedinophyceae sp. YPF-7 765719 Plants Plants 131 9.18e-37   NR CAG9462620.1 765719 g889 i0 72.3 18.8486055776892 83 23 99.2 0 249 1 10 92 CAG9462620.1 unnamed protein product [Pedinophyceae sp. YPF-701] diamond 4731 131 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Pedinophyceae       Pedinophyceae sp. YPF-701
27281593 27281593 PRJNA306153_S_NODE_1403_length_204_cov_5.017143_g1390_i0 PRJNA306153 1403 204 5.017143 10.23497172 Chlorellaceae 35461 Plants Plants 73.6 1.22e-13   NR PRW39386.1 3076 g1390 i0 57.4 6.11764705882353 61 25 88.2 1 204 25 198 258 PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana] diamond 1248 74.3 0.990578734858681 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
30422183 30422183 PRJNA306153_S_NODE_1193_length_220_cov_3.570681_g1180_i0 PRJNA306153 1193 220 3.570681 7.8554982 Scenedesmus sp. NREL 46B-D3 2650976 Plants Plants 103 6.22e-25   NR KAF6257032.1 2650976 g1180 i0 70.8 11.6727272727273 72 19 95.5 1 216 7 63 134 KAF6257032.1 component of cytosolic 80S ribosome and 40S small subunit [Scenedesmus sp. NREL 46B-D3] diamond 2568 103 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. NREL 46B-D3

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