RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA554794" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA554794 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1796550 1796550 PRJNA554794_P_NODE_9222_length_455_cov_1.056650_g5425_i0 PRJNA554794 9222 455 1.05665 4.8077575 Bathycoccus prasinos 41875 Plants Plants 86.1 4.35e-12   NTclustered gi|290770787|emb|FN563099.1| 41875 g5425 i0 89.706 15.2307692307692 68 5 15 2 263 328 2256 2189 Bathycoccus prasinos plastid 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), strain SCCAP K-0417 blastn 6930 86.1 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos
8173702 8173702 PRJNA554794_P_NODE_24007_length_163_cov_0.885965_g20078_i0 PRJNA554794 24007 163 0.885965 1.44412295 Chlamydomonas reinhardtii 3055 Plants Plants 165 1.67e-36   NTclustered gi|2082248650|ref|XM_043063418.1| 3055 g20078 i0 86.577 12 149 20 91 0 1 149 780 632 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA blastn 1956 165 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
15823697 15823697 PRJNA554794_P_NODE_22833_length_166_cov_0.871795_g18904_i0 PRJNA554794 22833 166 0.871795 1.4471797 Chlorella variabilis 554065 Plants Plants 65.8 1.79e-6   NTclustered gi|552838620|ref|XM_005849555.1| 554065 g18904 i0 97.368 5.7289156626506 38 1 23 0 4 41 147 110 Chlorella variabilis expressed protein (CHLNCDRAFT_143104) mRNA, partial cds blastn 951 65.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
18372625 18372625 PRJNA554794_P_NODE_12735_length_266_cov_1.497696_g8806_i0 PRJNA554794 12735 266 1.497696 3.98387136 Pseudoscourfieldia marina 41886 Plants Plants 281 2.85e-71   NTclustered gi|308035576|dbj|AB491630.1| 41886 g8806 i0 85.932 92.0037593984962 263 37 99 0 1 263 417 155 Pseudoscourfieldia marina Btub gene for beta-tubulin, partial cds, strain: NIES-1419 blastn 24473 281 1 Eukaryota   Viridiplantae Chlorophyta Pseudoscourfieldiophyceae Pseudoscourfieldiales Pseudoscourfieldiaceae Pseudoscourfieldia Pseudoscourfieldia marina
19647304 19647304 PRJNA554794_P_NODE_24136_length_162_cov_1.088496_g20207_i0 PRJNA554794 24136 162 1.088496 1.76336352 Micromonas commoda 296587 Plants Plants 113 6.1e-21   NTclustered gi|255084000|ref|XM_002508529.1| 296587 g20207 i0 81.429 5 140 24 86 2 24 162 983 845 Micromonas commoda fatty acid desaturase mRNA blastn 810 113 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
22197800 22197800 PRJNA554794_P_NODE_20138_length_199_cov_1.193333_g16209_i0 PRJNA554794 20138 199 1.193333 2.37473267 Micromonas commoda 296587 Plants Plants 141 3.5800000000000003e-29   NTclustered gi|255080797|ref|XM_002503926.1| 296587 g16209 i0 82.911 8.1356783919598 158 25 79 2 43 199 371 215 Micromonas commoda predicted protein mRNA blastn 1619 141 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
24747120 24747120 PRJNA554794_P_NODE_13980_length_231_cov_1.181319_g10051_i0 PRJNA554794 13980 231 1.181319 2.72884689 Micromonas pusilla 38833 Plants Plants 132 2.58e-26   NTclustered gi|303283335|ref|XM_003060913.1| 564608 g10051 i0 87.069 3.84415584415584 116 15 50 0 75 190 715 600 Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_49684), partial mRNA blastn 888 132 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla

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