RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA235310 · 3 ✖

analysis 1

  • blastn · 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
8020720 8020720 PRJNA235310_P_NODE_1007_length_397_cov_7.448276_g981_i0 PRJNA235310 1007 397 7.448276 29.56965572 Monoraphidium neglectum 145388 Plants Plants 63.9 1.76e-5   NTclustered gi|926791790|ref|XM_014048915.1| 145388 g981 i0 82.667 0.974811083123426 75 10 18 2 116 187 1112 1186 Monoraphidium neglectum WD repeat, SAM and U-box domain-containing protein 1 mRNA blastn 387 63.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
20182672 20182672 PRJNA235310_P_NODE_1916_length_285_cov_12.682203_g1890_i0 PRJNA235310 1916 285 12.682203 36.14427855 Opisthokonta 33154 Plants Plants 99 3.33e-16   NTclustered gi|612395756|ref|XM_007513336.1| 41875 g1890 i0 80.303 1.92631578947368 132 24 46 2 99 229 171 41 Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA blastn 549 100 0.99 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos
23319431 23319431 PRJNA235310_P_NODE_4619_length_173_cov_1.298387_g4593_i0 PRJNA235310 4619 173 1.298387 2.24620951 Micromonas commoda 296587 Plants Plants 124 3.04e-24   NTclustered gi|255076040|ref|XM_002501649.1| 296587 g4593 i0 87.85 0.61849710982659 107 11 61 2 56 161 382 487 Micromonas commoda predicted protein partial mRNA blastn 107 124 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda

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