RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA631119" 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

  • PRJNA631119 · 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
27649648 27649648 PRJNA631119_P_NODE_2684_length_658_cov_13.372650_g2576_i0 PRJNA631119 2684 658 13.37265 87.992037 Minisyncoccota bacterium 2053589 Bacteria Bacteria 78.6 3.96e-15   NR MDR3572201.1 2053589 g2576 i0 79.6 0.223404255319149 49 10 22.3 0 638 492 40 88 MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 147 78.6 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29638352 29638352 PRJNA631119_P_NODE_40570_length_229_cov_2.935897_g40452_i0 PRJNA631119 40570 229 2.935897 6.72320413 Minisyncoccota bacterium 2053589 Bacteria Bacteria 47.8 1.45e-4   NR MDR3572083.1 2053589 g40452 i0 35.5 0.995633187772926 76 48 99.6 1 229 2 44 118 MDR3572083.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 228 47.8 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31154804 31154804 PRJNA631119_P_NODE_30275_length_253_cov_1.200000_g30157_i0 PRJNA631119 30275 253 1.2 3.036 Minisyncoccota bacterium 2053589 Bacteria Bacteria 129 3.42e-33   NR MDR3558125.1 2053589 g30157 i0 69 0.99604743083004 84 26 99.6 0 1 252 191 274 MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 252 129 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31945678 31945678 PRJNA631119_P_NODE_8657_length_405_cov_1.376506_g8539_i0 PRJNA631119 8657 405 1.376506 5.5748493 Minisyncoccota bacterium 2053589 Bacteria Bacteria 52.8 6.75e-5   NR MEZ0209192.1 2053589 g8539 i0 34.6 0.77037037037037 104 62 74.8 4 42 344 212 312 MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 312 52.8 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32325888 32325888 PRJNA631119_P_NODE_16019_length_322_cov_1.481928_g15901_i0 PRJNA631119 16019 322 1.481928 4.77180816 Minisyncoccota bacterium 2053589 Bacteria Bacteria 75.5 1.4e-14   NR MDR3571063.1 2053589 g15901 i0 68.5 0.503105590062112 54 17 50.3 0 1 162 99 152 MDR3571063.1 prohibitin family protein [Candidatus Paceibacterota bacterium] diamond 162 75.5 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32861997 32861997 PRJNA631119_P_NODE_60_length_2356_cov_4.871660_g51_i0 PRJNA631119 60 2356 4.87166 114.7763096 Minisyncoccota bacterium 2053589 Bacteria Bacteria 182 4.54e-44   NR MEZ0209192.1 2053589 g51 i0 28 0.719439728353141 565 367 69.5 19 1937 300 122 665 MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 1695 182 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);;