RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_phylum = "Minisyncoccota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Minisyncoccota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1196438 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26787820 26787820 PRJNA1196438_P_NODE_81241_length_231_cov_2.879747_g80814_i0 PRJNA1196438 81241 231 2.879747 6.65221557 Minisyncoccota bacterium 2053589 Bacteria Bacteria 46.6 0.0013   NR MDR3581681.1 2053589 g80814 i0 39.6 0.688311688311688 53 32 68.8 0 193 35 48 100 MDR3581681.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 159 46.6 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29062114 29062114 PRJNA1196438_P_NODE_42508_length_285_cov_1.471698_g42081_i0 PRJNA1196438 42508 285 1.471698 4.1943393 Minisyncoccota bacterium 2053589 Bacteria Bacteria 165 2.02e-48   NR MDR3571450.1 2053589 g42081 i0 84 1.97894736842105 94 14 98.9 1 3 284 108 200 MDR3571450.1 nucleotidyltransferase [Candidatus Paceibacterota bacterium] diamond 564 165 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31652515 31652515 PRJNA1196438_P_NODE_10737_length_325_cov_1.563492_g10311_i0 PRJNA1196438 10737 325 1.563492 5.081349 Minisyncoccota bacterium 2053589 Bacteria Bacteria 124 1.17e-33   NR MEX0596343.1 2053589 g10311 i0 60 0.923076923076923 100 40 92.3 0 11 310 1 100 MEX0596343.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 300 124 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31779134 31779134 PRJNA1196438_P_NODE_50797_length_272_cov_1.527638_g50370_i0 PRJNA1196438 50797 272 1.527638 4.15517536 Minisyncoccota bacterium 2053589 Bacteria Bacteria 48.1 4.1e-4   NR MEX0596344.1 2053589 g50370 i0 27.6 0.959558823529412 87 63 96 0 267 7 101 187 MEX0596344.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 261 48.1 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31905753 31905753 PRJNA1196438_P_NODE_59357_length_259_cov_1.930108_g58930_i0 PRJNA1196438 59357 259 1.930108 4.99897972 Minisyncoccota bacterium 2053589 Bacteria Bacteria 114 2.7600000000000004e-27   NR MBP6946295.1 2053589 g58930 i0 69.1 0.938223938223938 81 24 92.7 1 3 242 88 168 MBP6946295.1 bifunctional DNA primase/polymerase [Candidatus Paceibacterota bacterium] diamond 243 114 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32190656 32190656 PRJNA1196438_P_NODE_71658_length_246_cov_0.901734_g71231_i0 PRJNA1196438 71658 246 0.901734 2.21826564 Minisyncoccota bacterium 2053589 Bacteria Bacteria 45.1 0.00464   NR MEX0595156.1 2053589 g71231 i0 36.4 0.939024390243902 77 49 93.9 0 233 3 52 128 MEX0595156.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 231 45.1 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);;