RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA864829 · 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
8500190 8500190 PRJNA864829_S_NODE_2487_length_338_cov_2.190311_g2401_i0 PRJNA864829 2487 338 2.190311 7.40325118 Micractinium sp. LBA 32 1759591 Plants Plants 102 3.12e-17   NTclustered gi|1572791199|gb|MH718999.1| 1759591 g2401 i0 89.873 3.8698224852071 79 8 23 0 82 160 28494 28572 Micractinium sp. LBA 32 mitochondrion, complete genome blastn 1308 102 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. LBA 32
12716442 12716442 PRJNA864829_S_NODE_1210_length_446_cov_2.717884_g1124_i0 PRJNA864829 1210 446 2.717884 12.12176264 Viridiplantae 33090 Plants Plants 217 1.45e-51   NTclustered gi|371782112|emb|HE610144.1| 156128 g1124 i0 89.941 41.4484304932735 169 16 38 1 53 221 1801 1968 Nephroselmis pyriformis 5.8S rRNA gene, 28S rRNA gene (partial) and ITS2, strain CCMP717 blastn 18486 219 0.990867579908676 Eukaryota   Viridiplantae Chlorophyta Nephroselmidophyceae Nephroselmidales Nephroselmidaceae Nephroselmis Nephroselmis pyriformis
25463556 25463556 PRJNA864829_S_NODE_2620_length_331_cov_8.542553_g2534_i0 PRJNA864829 2620 331 8.542553 28.27585043 Micromonas 38832 Plants Plants 154 8.31e-33   NTclustered gi|223047906|gb|FJ032695.1| 157820 g2534 i0 96.739 37.9244712990937 92 3 41 0 214 305 1851 1760 Uncultured Prasinophyceae clone DH114_3A06 28S ribosomal RNA gene, partial sequence blastn 12553 154 1 Eukaryota   Viridiplantae Chlorophyta         uncultured prasinophyte

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