RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB2368" 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

  • PRJEB2368 · 6 ✖

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
27538820 27538820 PRJEB2368_P_NODE_12564_length_202_cov_2.557576_g12245_i0 PRJEB2368 12564 202 2.557576 5.16630352 Minisyncoccota bacterium 2053589 Bacteria Bacteria 62.4 2.57e-9   NR MBP6883961.1 2053589 g12245 i0 55.2 1.99009900990099 67 28 99.5 2 1 201 144 208 MBP6883961.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 402 62.4 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29685445 29685445 PRJEB2368_P_NODE_8330_length_287_cov_1.656000_g8012_i0 PRJEB2368 8330 287 1.656 4.75272 Minisyncoccota bacterium 2053589 Bacteria Bacteria 45.1 0.00926   NR HEY4508737.1 2053589 g8012 i0 76 0.261324041811847 25 6 26.1 0 212 286 238 262 HEY4508737.1 pitrilysin family protein [Candidatus Paceibacterota bacterium] diamond 75 45.1 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31107300 31107300 PRJEB2368_P_NODE_7175_length_287_cov_2.468000_g6857_i0 PRJEB2368 7175 287 2.468 7.08316 Minisyncoccota bacterium 2053589 Bacteria Bacteria 48.9 3.43e-4   NR MFA6338997.1 2053589 g6857 i0 88 0.261324041811847 25 3 26.1 0 212 286 201 225 MFA6338997.1 class I SAM-dependent methyltransferase [Candidatus Paceibacterota bacterium] diamond 75 48.9 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31455318 31455318 PRJEB2368_P_NODE_8936_length_287_cov_1.492000_g8618_i0 PRJEB2368 8936 287 1.492 4.28204 Minisyncoccota bacterium 2053589 Bacteria Bacteria 50.8 7.22e-5   NR MFA7216617.1 2053589 g8618 i0 92 0.261324041811847 25 2 26.1 0 76 2 54 78 MFA7216617.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 75 50.8 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31487097 31487097 PRJEB2368_P_NODE_9836_length_287_cov_1.352000_g9518_i0 PRJEB2368 9836 287 1.352 3.88024 Minisyncoccota bacterium 2053589 Bacteria Bacteria 47 0.00204   NR MBP6949056.1 2053589 g9518 i0 76 0.261324041811847 25 6 26.1 0 287 213 336 360 MBP6949056.1 AAA family ATPase [Candidatus Paceibacterota bacterium] diamond 75 47 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32877364 32877364 PRJEB2368_P_NODE_9340_length_287_cov_1.424000_g9022_i0 PRJEB2368 9340 287 1.424 4.08688 Minisyncoccota bacterium 2053589 Bacteria Bacteria 52.4 2.54e-5   NR MFA6397762.1 2053589 g9022 i0 82.6 0.491289198606272 23 4 24 0 1 69 497 519 MFA6397762.1 phenylalanine--tRNA ligase subunit beta [Candidatus Paceibacterota bacterium] diamond 141 52.4 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);;