RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB39643", tax_clade = "Bacteria candidate phyla" 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

  • Bacteria candidate phyla · 5 ✖

bioproject 1

  • PRJEB39643 · 5 ✖

analysis 1

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
26685090 26685090 PRJEB39643_P_NODE_46741_length_288_cov_1.432558_g46548_i0 PRJEB39643 46741 288 1.432558 4.12576704 Minisyncoccota bacterium 2053589 Bacteria Bacteria 179 5.13e-53   NR HVX91236.1 2053589 g46548 i0 86.3 6.76041666666667 95 13 99 0 287 3 257 351 HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium] diamond 1947 179 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32113264 32113264 PRJEB39643_P_NODE_66638_length_277_cov_1.509804_g66445_i0 PRJEB39643 66638 277 1.509804 4.18215708 Bacteria 2 Bacteria Bacteria 82.8 2.25e-16   NR MFA7169733.1 2053589 g66445 i0 45.1 2.91335740072202 91 45 97.5 2 272 3 46 132 MFA7169733.1 glycosyltransferase [Candidatus Paceibacterota bacterium] diamond 807 82.8 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32119973 32119973 PRJEB39643_P_NODE_87018_length_267_cov_1.587629_g86825_i0 PRJEB39643 87018 267 1.587629 4.23896943 Minisyncoccota bacterium 2053589 Bacteria Bacteria 97.4 1.29e-22   NR MBP6879546.1 2053589 g86825 i0 56 0.943820224719101 84 37 94.4 0 8 259 151 234 MBP6879546.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 252 97.4 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32404646 32404646 PRJEB39643_P_NODE_34359_length_317_cov_2.942623_g34166_i0 PRJEB39643 34359 317 2.942623 9.32811491 Minisyncoccota bacterium 2053589 Bacteria Bacteria 75.9 1.11e-13   NR MDR3571115.1 2053589 g34166 i0 43.2 0.832807570977918 88 49 82.3 1 288 28 140 227 MDR3571115.1 glycosyltransferase family 2 protein [Candidatus Paceibacterota bacterium] diamond 264 75.9 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32846099 32846099 PRJEB39643_P_NODE_27980_length_347_cov_2.167883_g27787_i0 PRJEB39643 27980 347 2.167883 7.52255401 Minisyncoccota bacterium 2053589 Bacteria Bacteria 68.2 1.01e-10   NR MDR3571115.1 2053589 g27787 i0 38 0.864553314121037 100 61 85.6 1 50 346 140 239 MDR3571115.1 glycosyltransferase family 2 protein [Candidatus Paceibacterota bacterium] diamond 300 68.2 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);;