RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA603943 · 6 ✖

analysis 1

  • blastn · 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
577295 577295 PRJNA603943_P_NODE_4341_length_716_cov_2.429238_g4163_i0 PRJNA603943 4341 716 2.429238 17.39334408 Micromonas commoda 296587 Plants Plants 211 1.12e-49   NTclustered gi|255081109|ref|XM_002504075.1| 296587 g4163 i0 81.641 16.409217877095 256 45 36 2 1 255 20 274 Micromonas commoda predicted protein partial mRNA blastn 11749 211 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
1852308 1852308 PRJNA603943_P_NODE_16742_length_410_cov_1.403561_g16550_i0 PRJNA603943 16742 410 1.403561 5.7546001 Mantoniella tinhauana 3097027 Plants Plants 315 4.55e-81   NTclustered gi|2735153278|gb|CP140063.1| 3097027 g16550 i0 80.723 83.6975609756098 415 70 100 9 1 410 631882 631473 Mantoniella tinhauana isolate LFS chromosome 2 blastn 34316 315 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
3128082 3128082 PRJNA603943_P_NODE_36943_length_302_cov_3.017467_g36751_i0 PRJNA603943 36943 302 3.017467 9.11275034 Micromonas commoda 296587 Plants Plants 183 9.559999999999998e-42   NTclustered gi|255072468|ref|XM_002499863.1| 296587 g36751 i0 87.117 18.4370860927152 163 19 54 2 4 165 29 190 Micromonas commoda predicted protein mRNA blastn 5568 183 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
15879281 15879281 PRJNA603943_P_NODE_11873_length_470_cov_2.506297_g11681_i0 PRJNA603943 11873 470 2.506297 11.7795959 Auxenochlorella protothecoides 3075 Plants Plants 359 2.4e-94   NTclustered gi|760444702|ref|XM_011401118.1| 3075 g11681 i0 84.615 66.1744680851064 364 52 77 3 80 441 485 124 Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA blastn 31102 359 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
19703757 19703757 PRJNA603943_P_NODE_3856_length_753_cov_3.527941_g3680_i0 PRJNA603943 3856 753 3.527941 26.56539573 Micromonas commoda 296587 Plants Plants 363 3.0699999999999996e-95   NTclustered gi|255081970|ref|XM_002508158.1| 296587 g3680 i0 80.679 60.8220451527224 471 87 62 4 268 736 509 41 Micromonas commoda predicted protein mRNA blastn 45799 363 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
23530045 23530045 PRJNA603943_P_NODE_51599_length_254_cov_1.276243_g51407_i0 PRJNA603943 51599 254 1.276243 3.24165722 Trebouxia sp. SL0000003 3350044 Plants Plants 52.8 0.023   NTclustered gi|2917929623|emb|OZ234911.1| 3350044 g51407 i0 100 0.110236220472441 28 0 11 0 69 96 1862726 1862699 Trebouxia sp. SL0000003 genome assembly, chromosome: 6 blastn 28 52.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. SL0000003

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