RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA683902", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 2 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 2 ✖

bioproject 1

  • PRJNA683902 · 2 ✖

analysis 1

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
8318505 8318505 PRJNA683902_S_NODE_31107_length_174_cov_3.255474_g30663_i0 PRJNA683902 31107 174 3.255474 5.66452476 uncultured Chlorobiota bacterium 156405 Bacteria Bacteria 108 3.08e-19   NTclustered gi|374852364|dbj|AP011715.1| 156405 g30663 i0 93.151 5.22413793103448 73 5 42 0 1 73 37220 37292 Uncultured Chlorobi bacterium DNA, fosmid clone: JFF027_B02 blastn 909 108 1 Bacteria FCB group Pseudomonadati Chlorobiota         uncultured Chlorobiota bacterium
13419140 13419140 PRJNA683902_S_NODE_13991_length_327_cov_2.227586_g13547_i0 PRJNA683902 13991 327 2.227586 7.28420622 Prosthecochloris sp. CIB 2401 1868325 Bacteria Bacteria 215 3.71e-51   NTclustered gi|1044515116|gb|CP016432.1| 1868325 g13547 i0 79.268 484.54128440367 328 53 97 13 11 327 104023 103700 Prosthecochloris sp. CIB 2401 chromosome, complete genome blastn 158445 215 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Prosthecochloris Prosthecochloris sp. CIB 2401

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