RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB2925 · 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
12779669 12779669 PRJEB2925_P_NODE_17051_length_227_cov_2.489583_g15773_i0 PRJEB2925 17051 227 2.489583 5.65135341 Monoraphidium neglectum 145388 Plants Plants 254 5.16e-63   NTclustered gi|926795717|ref|XM_014050538.1| 145388 g15773 i0 86.842 84.9383259911894 228 28 100 2 1 227 346 120 Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA blastn 19281 254 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
14054271 14054271 PRJEB2925_P_NODE_3612_length_750_cov_2.797203_g2775_i0 PRJEB2925 3612 750 2.797203 20.9790225 Chlorella variabilis 554065 Plants Plants 593 9.959999999999998e-165   NTclustered gi|552822727|ref|XM_005846130.1| 554065 g2775 i0 81.266 51.544 758 120 99 19 1 747 927 181 Chlorella variabilis ATP/ADP translocator (CHLNCDRAFT_136213) mRNA, complete cds blastn 38658 593 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
15015988 15015988 PRJEB2925_P_NODE_8832_length_406_cov_19.711590_g7572_i0 PRJEB2925 8832 406 19.71159 80.0290554 Eukaryota 2759 Plants Plants 721 0   NTclustered gi|1898545223|gb|MT951391.1| 3078 g7572 i0 98.768 100.002463054187 406 4 100 1 1 406 957 553 Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence blastn 40601 726 0.993112947658402 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella pyrenoidosa

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