RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA450632 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
4266284 4266284 PRJNA450632_P_NODE_17004_length_188_cov_1.542484_g16825_i0 PRJNA450632 17004 188 1.542484 2.89986992 Stichococcus bacillaris 37433 Plants Plants 320 4e-83   NTclustered gi|371782093|emb|HE610125.1| 37433 g16825 i0 97.34 99.8936170212766 188 5 100 0 1 188 4628 4441 Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 blastn 18780 320 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus bacillaris
16395180 16395180 PRJNA450632_P_NODE_23853_length_151_cov_1.353448_g23674_i0 PRJNA450632 23853 151 1.353448 2.04370648 Trebouxia 13786 Plants Plants 206 8.94e-49   NTclustered gi|2105087|emb|Z95381.1| 53268 g23674 i0 91.391 89.8013245033113 151 12 99 1 1 150 995 1145 T.arboricola 26S rRNA gene blastn 13560 206 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia arboricola
20840973 20840973 PRJNA450632_P_NODE_18597_length_177_cov_1.676056_g18418_i0 PRJNA450632 18597 177 1.676056 2.96661912 Microglena uva-maris 327073 Plants Plants 250 4.94e-62   NTclustered gi|66864279|gb|DQ015734.1| 327073 g18418 i0 92.09 86.5028248587571 177 14 100 0 1 177 2953 3129 Microglena uva-maris strain SAG 19.89 26S ribosomal RNA gene, partial sequence blastn 15311 250 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Microglena Microglena uva-maris
21494384 21494384 PRJNA450632_P_NODE_19317_length_172_cov_2.131387_g19138_i0 PRJNA450632 19317 172 2.131387 3.66598564 Chlamydomonas 3052 Plants Plants 122 1.0799999999999999e-23   NTclustered gi|18144|emb|X53574.1| 3055 g19138 i0 80.117 38.1046511627907 171 28 98 6 5 172 1446 1613 C. reinhardtii Cblp gene for a G protein beta subunit-like polypeptide blastn 6554 122 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii

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