RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA692200 · 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
672828 672828 PRJNA692200_S_NODE_23721_length_153_cov_3.346154_g23664_i0 PRJNA692200 23721 153 3.346154 5.11961562 Coccomyxa subellipsoidea 248742 Plants Plants 67.6 4.48e-7   NTclustered gi|545370967|ref|XM_005650030.1| 574566 g23664 i0 97.436 24.3267973856209 39 1 25 0 25 63 428 390 Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA blastn 3722 67.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
4500974 4500974 PRJNA692200_S_NODE_6904_length_258_cov_3.071770_g6847_i0 PRJNA692200 6904 258 3.07177 7.9251666 Trentepohlia odorata 2576626 Plants Plants 143 1.35e-29   NTclustered gi|1707505678|ref|NC_043776.1| 2576626 g6847 i0 80.303 66.8565891472868 198 31 75 8 11 204 33544 33737 Trentepohlia odorata chloroplast, complete genome blastn 17249 143 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Trentepohliales Trentepohliaceae Trentepohlia Trentepohlia odorata
6283247 6283247 PRJNA692200_S_NODE_1845_length_386_cov_234.412463_g1788_i0 PRJNA692200 1845 386 234.412463 904.83210718 Eukaryota 2759 Plants Plants 627 4.8099999999999996e-175   NTclustered gi|1714003650|gb|MN243923.1| 3079 g1788 i0 100 87.4585492227979 339 0 88 0 48 386 872 534 Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence blastn 33759 627 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sp.
7557145 7557145 PRJNA692200_S_NODE_13566_length_196_cov_1.993197_g13509_i0 PRJNA692200 13566 196 1.993197 3.90666612 Botryococcus 38880 Plants Plants 67.6 6.05e-7   NTclustered gi|2724824232|gb|PP746554.1| 38881 g13509 i0 91.667 13.5459183673469 48 4 24 0 53 100 3576 3623 Botryococcus braunii culture SAG:807-1 mitochondrion, complete genome blastn 2655 67.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae     Botryococcus Botryococcus braunii

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