RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Candidatus Collieribacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Collieribacteriota · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB20058 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
32945775 32945775 PRJEB20058_P_NODE_72306_length_489_cov_15.644860_g69531_i0 PRJEB20058 72306 489 15.64486 76.5033654 Candidatus Collierbacteria bacterium RIFOXYD1_FULL_4 2053540 Bacteria Bacteria 186 1.6399999999999998e-57   NR OGD84097.1 1817731 g69531 i0 91.8 0.601226993865031 98 8 60.1 0 391 98 1 98 OGD84097.1 MAG: hypothetical protein A2572_03135 [Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9] diamond 294 186 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9
32996800 32996800 PRJEB20058_P_NODE_49819_length_595_cov_10.477528_g47095_i0 PRJEB20058 49819 595 10.477528 62.3412916 Candidatus Collierbacteria bacterium GW2 2053540 Bacteria Bacteria 162 3.5799999999999993e-43   NR KKT73181.1 1618384 g47095 i0 89.2 0.46890756302521 93 10 46.9 0 11 289 507 599 KKT73181.1 MAG: Elongation factor 4 [Candidatus Collierbacteria bacterium GW2011_GWB1_44_6] diamond 279 162 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium GW2011_GWB1_44_6
33065014 33065014 PRJEB20058_P_NODE_41925_length_649_cov_8.896259_g39268_i0 PRJEB20058 41925 649 8.896259 57.73672091 Candidatus Collierbacteria bacterium GW2 2053540 Bacteria Bacteria 178 6.6e-51   NR KKT71979.1 1618384 g39268 i0 65.3 2.2095531587057 121 42 55.9 0 264 626 212 332 KKT71979.1 MAG: Mannose-1-phosphate guanylyltransferase [Candidatus Collierbacteria bacterium GW2011_GWB1_44_6] diamond 1434 178 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium GW2011_GWB1_44_6
33149482 33149482 PRJEB20058_P_NODE_117536_length_369_cov_4.743506_g114721_i0 PRJEB20058 117536 369 4.743506 17.50353714 Candidatus Collierbacteria bacterium RIFOXYD1_FULL_4 2053540 Bacteria Bacteria 164 4.2e-45   NR OGD83457.1 1817731 g114721 i0 67.3 0.91869918699187 113 37 91.9 0 5 343 441 553 OGD83457.1 MAG: hypothetical protein A2572_04945 [Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9] diamond 339 164 1 Bacteria Bacteria candidate phyla   Candidatus Collieribacteriota         Candidatus Collierbacteria bacterium RIFOXYD1_FULL_40_9

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);;