RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_phylum = "Minisyncoccota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Minisyncoccota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA902848 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_kingdom 0

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
26644173 26644173 PRJNA902848_P_NODE_17121_length_247_cov_0.896552_g17071_i0 PRJNA902848 17121 247 0.896552 2.21448344 Patescibacteria group bacterium UBA2163 1948796 Bacteria Bacteria 96.7 4.28e-21   NR XKT74235.1 1948796 g17071 i0 61 0.995951417004049 82 32 99.6 0 247 2 461 542 XKT74235.1 MAG: efflux RND transporter permease subunit [Patescibacteria group bacterium UBA2163] diamond 246 96.7 1 Bacteria Bacteria candidate phyla   Minisyncoccota Minisyncoccia Candidatus Phycocordibacterales Candidatus Phycocordibacteraceae Candidatus Phycocordibacter Candidatus Phycocordibacter aenigmaticus
26960779 26960779 PRJNA902848_P_NODE_15462_length_249_cov_0.886364_g15412_i0 PRJNA902848 15462 249 0.886364 2.20704636 Minisyncoccota bacterium 2053589 Bacteria Bacteria 44.7 7.31e-4   NR HET9641418.1 2053589 g15412 i0 50 0.433734939759036 36 18 43.4 0 222 115 23 58 HET9641418.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 108 44.7 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
28887369 28887369 PRJNA902848_P_NODE_17868_length_246_cov_0.861272_g17818_i0 PRJNA902848 17868 246 0.861272 2.11872912 Minisyncoccota bacterium 2053589 Bacteria Bacteria 87 7.37e-18   NR MBP9749553.1 2053589 g17818 i0 58.8 0.975609756097561 80 33 97.6 0 242 3 324 403 MBP9749553.1 insulinase family protein [Candidatus Paceibacterota bacterium] diamond 240 87 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29550376 29550376 PRJNA902848_P_NODE_18430_length_245_cov_0.906977_g18380_i0 PRJNA902848 18430 245 0.906977 2.22209365 Minisyncoccota bacterium 2053589 Bacteria Bacteria 121 7.199999999999999e-31   NR HRY47811.1 2053589 g18380 i0 70 1.8734693877551 80 24 98 0 241 2 293 372 HRY47811.1 LptF/LptG family permease [Candidatus Paceibacterota bacterium] diamond 459 121 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29834692 29834692 PRJNA902848_P_NODE_15451_length_249_cov_0.886364_g15401_i0 PRJNA902848 15451 249 0.886364 2.20704636 Minisyncoccota bacterium 2053589 Bacteria Bacteria 140 8.41e-40   NR HRT09251.1 2053589 g15401 i0 76.8 1.97590361445783 82 19 98.8 0 1 246 50 131 HRT09251.1 proton-conducting transporter membrane subunit [Candidatus Paceibacterota bacterium] diamond 492 140 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota 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);;