RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA812001 · 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
811010 811010 PRJNA812001_P_NODE_81101_length_251_cov_0.865169_g80855_i0 PRJNA812001 81101 251 0.865169 2.17157419 Pyrobotrys stellatus 3064 Plants Plants 206 1.65e-48   NTclustered gi|18266|emb|X68202.1| 3064 g80855 i0 81.673 2.48605577689243 251 43 99 3 1 250 269 21 C.stellata mRNA for ribosomal protein L27 blastn 624 206 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Spondylomoraceae Pyrobotrys Pyrobotrys stellatus
2499809 2499809 PRJNA812001_P_NODE_12502_length_450_cov_9.143236_g12256_i0 PRJNA812001 12502 450 9.143236 41.144562 Eukaryota 2759 Plants Plants 69.4 4.33e-7   NTclustered gi|1946821799|gb|MW380426.1| 3077 g12256 i0 100 17.4733333333333 37 0 8 0 1 37 1606 1642 Chlorella vulgaris strain H1 small subunit ribosomal RNA gene, partial sequence blastn 7863 69.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
10152910 10152910 PRJNA812001_P_NODE_137728_length_209_cov_6.750000_g137482_i0 PRJNA812001 137728 209 6.75 14.1075 Chlamydomonadales 3042 Plants Plants 298 2.13e-76   NTclustered gi|66864300|gb|DQ015755.1| 52964 g137482 i0 95.213 89.4928229665072 188 8 89 1 1 187 291 104 Dysmorphococcus globosus strain UTEX LB 65 26S ribosomal RNA gene, partial sequence blastn 18704 298 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Phacotaceae Dysmorphococcus Dysmorphococcus globosus
25450989 25450989 PRJNA812001_P_NODE_136880_length_228_cov_2.535484_g136634_i0 PRJNA812001 136880 228 2.535484 5.78090352 Desmochloris 138596 Plants Plants 350 6.44e-92   NTclustered gi|371782086|emb|HE610118.1| 138176 g136634 i0 94.298 101.513157894737 228 13 100 0 1 228 760 987 Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 blastn 23145 350 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila

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