RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Latescibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Latescibacterota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA556992 · 4 ✖

analysis 1

  • diamond · 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
12013308 12013308 PRJNA556992_P_NODE_889530_length_241_cov_2.398810_g887340_i0 PRJNA556992 889530 241 2.39881 5.7811321 FCB group 1783270 Bacteria Bacteria 151 4.82e-43   NR HIM55859.1 2053570 g887340 i0 87.5 13.8796680497925 80 10 99.6 0 241 2 223 302 HIM55859.1 ABC transporter permease [Candidatus Latescibacterota bacterium] diamond 3345 152 0.993421052631579 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
28310395 28310395 PRJNA556992_P_NODE_564946_length_261_cov_8.750000_g562757_i0 PRJNA556992 564946 261 8.75 22.8375 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 107 3.45e-25   NR MFC1542116.1 2053570 g562757 i0 56 0.96551724137931 84 37 96.6 0 9 260 211 294 MFC1542116.1 lipopolysaccharide biosynthesis protein [Candidatus Latescibacterota bacterium] diamond 252 107 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
30946105 30946105 PRJNA556992_P_NODE_641194_length_255_cov_4.208791_g639005_i0 PRJNA556992 641194 255 4.208791 10.73241705 Pseudomonadati 3379134 Bacteria Bacteria 86.7 1.97e-18   NR MFA6112110.1 2053570 g639005 i0 66.1 3.65882352941176 56 19 65.9 0 5 172 195 250 MFA6112110.1 glycosyltransferase [Candidatus Latescibacterota bacterium] diamond 933 87 0.996551724137931 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
31026455 31026455 PRJNA556992_P_NODE_304935_length_288_cov_1.655814_g302746_i0 PRJNA556992 304935 288 1.655814 4.76874432 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 117 2.79e-28   NR RPJ49241.1 2053570 g302746 i0 68.4 0.791666666666667 76 24 79.2 0 288 61 766 841 RPJ49241.1 MAG: hypothetical protein EHM19_00810 [Candidatus Latescibacterota bacterium] diamond 228 117 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota 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);;