RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA283169 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1059028 1059028 PRJNA283169_P_NODE_3021_length_238_cov_1.645503_g2958_i0 PRJNA283169 3021 238 1.645503 3.91629714 Eukaryota 2759 Plants Plants 311 3.19e-80   NTclustered gi|168144|gb|M62995.1|FRIUGEAA 3171 g2958 i0 100 84.890756302521 168 0 71 0 1 168 906 739 Friedmannia israeliensis 18S ribosomal RNA gene blastn 20204 311 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia Myrmecia israelensis
4198860 4198860 PRJNA283169_P_NODE_1384_length_340_cov_1.061856_g1322_i0 PRJNA283169 1384 340 1.061856 3.6103104 Trebouxia aggregata 160068 Plants Plants 383 9.999999999999999e-102   NTclustered gi|162134340|gb|EU123979.1| 160068 g1322 i0 94.048 89.7705882352941 252 15 74 0 54 305 1908 2159 Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast blastn 30522 383 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia aggregata
18910435 18910435 PRJNA283169_S_NODE_1915_length_203_cov_1.448052_g1901_i0 PRJNA283169 1915 203 1.448052 2.93954556 root 1 Root_unresolved Root_unresolved 375 9.24e-100   NTclustered gi|1714003650|gb|MN243923.1| 3079 g1901 i0 100 100.113300492611 203 0 100 0 1 203 620 822 Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence blastn 20323 375 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sp.
19497726 19497726 PRJNA283169_P_NODE_5216_length_187_cov_1.130435_g5153_i0 PRJNA283169 5216 187 1.130435 2.11391345 Trebouxia aggregata 160068 Plants Plants 263 6.79e-66   NTclustered gi|162134316|gb|EU123974.1| 160068 g5153 i0 91.979 30.524064171123 187 15 100 0 1 187 1837 2023 Trebouxia aggregata strain SAG 219-1d D2 reaction center protein of photosystem II (psbD), CP43 chlorophyll apoprotein of photosystem II (psbC), apocytochrome b6 of cytochrome b6/f complex (petB), and subunit IV of cytochrome b6/f complex (petD) genes, complete cds; chloroplast blastn 5708 263 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia aggregata
20185049 20185049 PRJNA283169_P_NODE_576_length_502_cov_3.796909_g514_i0 PRJNA283169 576 502 3.796909 19.06048318 Trebouxia 13786 Plants Plants 725 0   NTclustered gi|255653894|gb|FJ804760.1| 53268 g514 i0 92.843 122.910358565737 503 30 99 6 1 498 21 522 Trebouxia arboricola strain SAG 219-1A large subunit ribosomal RNA gene, partial sequence; and hypothetical protein genes, complete cds; chloroplast blastn 61701 725 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia arboricola

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