RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 6 ✖

bioproject 1

  • PRJNA1011833 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27919069 27919069 PRJNA1011833_S_NODE_8645_length_390_cov_4.400576_g8228_i0 PRJNA1011833 8645 390 4.400576 17.1622464 Dunaliella salina 3046 Plants Plants 72 9.25e-12   NR KAF5829124.1 3046 g8228 i0 47.7 0.5 65 34 50 0 389 195 122 186 KAF5829124.1 hypothetical protein DUNSADRAFT_16524 [Dunaliella salina] diamond 195 72 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina
27943210 27943210 PRJNA1011833_S_NODE_14605_length_315_cov_12.047794_g14185_i0 PRJNA1011833 14605 315 12.047794 37.9505511 Eukaryota 2759 Plants Plants 140 4.37e-40   NR KXZ41934.1 33097 g14185 i0 71.7 6.57142857142857 99 27 94.3 1 6 302 74 171 KXZ41934.1 hypothetical protein GPECTOR_240g576 [Gonium pectorale] diamond 2070 140 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Gonium Gonium pectorale
29206247 29206247 PRJNA1011833_S_NODE_3429_length_525_cov_16.095436_g3037_i0 PRJNA1011833 3429 525 16.095436 84.501039 Eukaryota 2759 Plants Plants 84.7 1.32e-16   NR KAK2079222.1 3111 g3037 i0 30 7.28 150 104 85.7 1 1 450 60 208 KAK2079222.1 hypothetical protein QBZ16_002913 [Prototheca wickerhamii] diamond 3822 85.1 0.995299647473561 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Prototheca Prototheca wickerhamii
29616197 29616197 PRJNA1011833_S_NODE_13830_length_323_cov_5.660714_g13410_i0 PRJNA1011833 13830 323 5.660714 18.28410622 Eukaryota 2759 Plants Plants 137 7.25e-36   NR PRW60758.1 3076 g13410 i0 71.3 132.38080495356 94 27 87.3 0 5 286 54 147 PRW60758.1 putative histone H2A variant 3 [Chlorella sorokiniana] diamond 42759 137 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
30382664 30382664 PRJNA1011833_S_NODE_27793_length_224_cov_2.651934_g27373_i0 PRJNA1011833 27793 224 2.651934 5.94033216 Volvox reticuliferus 1737510 Plants Plants 46.2 0.0013   NR GIL75151.1 1737510 g27373 i0 35.8 1.86160714285714 67 40 85.7 1 192 1 133 199 GIL75151.1 hypothetical protein Vretifemale_4930, partial [Volvox reticuliferus] diamond 417 46.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox reticuliferus
31330185 31330185 PRJNA1011833_S_NODE_10356_length_365_cov_6.065217_g9938_i0 PRJNA1011833 10356 365 6.065217 22.13804205 Dunaliella salina 3046 Plants Plants 54.7 7.51e-6   NR KAF5836707.1 3046 g9938 i0 34.9 1.68493150684932 109 60 89.6 2 3 329 191 288 KAF5836707.1 LAG1-domain-containing protein [Dunaliella salina] diamond 615 54.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina

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