RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA807347" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 4 ✖

bioproject 1

  • PRJNA807347 · 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
12702042 12702042 PRJNA807347_P_NODE_14650_length_246_cov_1.791908_g14547_i0 PRJNA807347 14650 246 1.791908 4.40809368 Fischerella sp. 1191 Bacteria Bacteria 130 2.01e-36   NR MCX7596623.1 1191 g14547 i0 81.7 0.865853658536585 71 13 86.6 0 33 245 2 72 MCX7596623.1 peroxiredoxin [Fischerella sp.] diamond 213 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella sp.
13559900 13559900 PRJNA807347_P_NODE_15151_length_245_cov_1.802326_g15048_i0 PRJNA807347 15151 245 1.802326 4.4156987 Sphaerospermopsis torques-reginae 984207 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2080647037|gb|CP080598.1| 984208 g15048 i0 100 10.8204081632653 245 0 100 0 1 245 4798240 4798484 Sphaerospermopsis torques-reginae ITEP-024 chromosome blastn 2651 453 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Sphaerospermopsis Sphaerospermopsis torques-reginae
31326927 31326927 PRJNA807347_P_NODE_16375_length_243_cov_0.917647_g16272_i0 PRJNA807347 16375 243 0.917647 2.22988221 Cyanophyceae 3028117 Bacteria Bacteria 110 8.850000000000001e-27   NR NJM66414.1 2720442 g16272 i0 85 4.44444444444444 60 9 74.1 0 62 241 1 60 NJM66414.1 transposase [Acaryochloris sp. RU_4_1] diamond 1080 111 0.990990990990991 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Acaryochloridaceae Acaryochloris Acaryochloris sp. RU_4_1
32307962 32307962 PRJNA807347_P_NODE_6919_length_311_cov_2.373950_g6816_i0 PRJNA807347 6919 311 2.37395 7.3829845 root 1 Root_unresolved Root_unresolved 49.7 2.57e-4   NR OLA94891.1 1913460 g6816 i0 55.8 1.90996784565916 43 19 41.5 0 310 182 157 199 OLA94891.1 MAG: acetylglutamate kinase [Candidatus Melainabacteria bacterium LEY3_CP_29_8] diamond 594 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium LEY3_CP_29_8

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