RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA788929", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA788929 · 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
5872692 5872692 PRJNA788929_P_NODE_17045_length_402_cov_39.212766_g16386_i0 PRJNA788929 17045 402 39.212766 157.63531932 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 128 4.84e-33   NR MEX2526958.1 2026742 g16386 i0 63.5 4.71641791044776 85 31 63.4 0 26 280 223 307 MEX2526958.1 fatty acid desaturase [Gemmatimonadota bacterium] diamond 1896 128 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
10973202 10973202 PRJNA788929_P_NODE_19269_length_374_cov_9.242525_g18609_i0 PRJNA788929 19269 374 9.242525 34.5670435 Roseisolibacter agri 2014610 Bacteria Bacteria 133 1.7299999999999999e-34   NR WP_284351518.1 2014610 g18609 i0 58.4 1.7807486631016 113 47 90.6 0 14 352 147 259 WP_284351518.1 hypothetical protein [Roseisolibacter agri] diamond 666 133 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
21172083 21172083 PRJNA788929_P_NODE_42297_length_241_cov_13.547619_g41636_i0 PRJNA788929 42297 241 13.547619 32.64976179 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 228 3.3599999999999994e-55   NTclustered gi|2874253978|emb|OY970303.1| 412054 g41636 i0 87.081 245.473029045643 209 18 88 9 17 221 5915241 5915444 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 59159 228 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
28926075 28926075 PRJNA788929_P_NODE_42188_length_242_cov_0.911243_g41527_i0 PRJNA788929 42188 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 68.6 2.93e-11   NR MEX2472806.1 2026742 g41527 i0 60.3 7.87190082644628 73 25 90.5 3 240 22 334 402 MEX2472806.1 copper resistance system multicopper oxidase [Gemmatimonadota bacterium] diamond 1905 68.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium

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