RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA934472 · 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
911076 911076 PRJNA934472_P_NODE_30301_length_270_cov_1.263959_g29923_i0 PRJNA934472 30301 270 1.263959 3.4126893 Nephroselmis olivacea 31312 Plants Plants 76.8 1.47e-9   NTclustered gi|110225635|ref|NC_008239.1| 31312 g29923 i0 91.071 72.4814814814815 56 5 21 0 214 269 1718 1773 Nephroselmis olivacea mitochondrion, complete genome blastn 19570 76.8 1 Eukaryota   Viridiplantae Chlorophyta Nephroselmidophyceae Nephroselmidales Nephroselmidaceae Nephroselmis Nephroselmis olivacea
6359568 6359568 PRJNA934472_P_NODE_30065_length_271_cov_1.272727_g29687_i0 PRJNA934472 30065 271 1.272727 3.44909017 Chlamydomonadales 3042 Plants Plants 451 2.0999999999999997e-122   NTclustered gi|397124|emb|X68919.1| 28464 g29687 i0 96.679 131.726937269373 271 9 100 0 1 271 2248 2518 Chloroplast Chlamydomonas zebra rrnL gene, exon 1 blastn 35698 451 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas zebra
10184238 10184238 PRJNA934472_P_NODE_31548_length_265_cov_1.203125_g31170_i0 PRJNA934472 31548 265 1.203125 3.18828125 root 1 Root_unresolved Root_unresolved 178 3.83e-40   NTclustered gi|1236573378|ref|XR_002608755.1| 41875 g31170 i0 90.977 49.3509433962264 133 10 50 2 118 249 1851 1720 Bathycoccus prasinos ribosomal RNA EukLSU (n/a) (rRNA_EukLSU), rRNA blastn 13078 178 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos
12390401 12390401 PRJNA934472_P_NODE_38770_length_241_cov_1.500000_g38392_i0 PRJNA934472 38770 241 1.5 3.615 Golenkinia longispicula 204992 Plants Plants 353 5.31e-93   NTclustered gi|952953743|gb|KT625111.1| 204992 g38392 i0 93.361 142.091286307054 241 12 99 3 1 240 4370 4607 Golenkinia longispicula clone contig295 chloroplast, partial genome blastn 34244 353 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Golenkiniaceae Golenkinia Golenkinia longispicula
12734898 12734898 PRJNA934472_P_NODE_1690_length_1017_cov_3.918432_g1463_i0 PRJNA934472 1690 1017 3.918432 39.85045344 root 1 Root_unresolved Root_unresolved 983 0   NTclustered gi|1279575454|gb|MF683078.1| 44745 g1463 i0 84.851 260.546705998033 1010 115 97 33 5 994 3591 2600 Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 264976 985 0.997969543147208 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
25137101 25137101 PRJNA934472_P_NODE_24380_length_297_cov_1.848214_g24002_i0 PRJNA934472 24380 297 1.848214 5.48919558 Nephroselmis astigmatica 259378 Plants Plants 71.3 7.62e-8   NTclustered gi|371782113|emb|HE610145.1| 259378 g24002 i0 85.294 3.87205387205387 68 10 23 0 224 291 3846 3779 Nephroselmis astigmatica 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain NIES N-252 blastn 1150 71.3 1 Eukaryota   Viridiplantae Chlorophyta Nephroselmidophyceae Nephroselmidales Nephroselmidaceae Nephroselmis Nephroselmis astigmatica

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