RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1061474 · 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
178655 178655 PRJNA1061474_P_NODE_38821_length_286_cov_1.422535_g38575_i0 PRJNA1061474 38821 286 1.422535 4.0684501 Chloropicon primus 1764295 Plants Plants 222 1.9e-53   NTclustered gi|1678645830|ref|NC_042490.1| 1764295 g38575 i0 80.986 17.493006993007 284 50 99 3 1 282 36668 36949 Chloropicon primus culture CCMP:1205 mitochondrion, complete genome blastn 5003 222 1 Eukaryota   Viridiplantae Chlorophyta Chloropicophyceae Chloropicales Chloropicaceae Chloropicon Chloropicon primus
7389431 7389431 PRJNA1061474_P_NODE_54466_length_244_cov_0.900585_g54220_i0 PRJNA1061474 54466 244 0.900585 2.1974274 Desmochloris 138596 Plants Plants 322 1.52e-83   NTclustered gi|313476264|emb|FM882217.1| 578869 g54220 i0 98.37 75.0573770491803 184 1 75 2 15 198 344 163 Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 blastn 18314 322 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris mollenhaueri
17589500 17589500 PRJNA1061474_P_NODE_49834_length_247_cov_1.591954_g49588_i0 PRJNA1061474 49834 247 1.591954 3.93212638 Chlorophyta 3041 Plants Plants 396 8.95e-106   NTclustered gi|45385169|gb|AY553213.1| 3075 g49588 i0 95.547 100.004048582996 247 11 100 0 1 247 862 1108 Auxenochlorella protothecoides 16S small subunit ribosomal RNA gene, partial sequence; chloroplast blastn 24701 396 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides

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