RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA690592" and tax_phylum = "Calditrichota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Calditrichota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690592 · 6 ✖

analysis 1

tax_clade 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
3221740 3221740 PRJNA690592_S_NODE_13163_length_807_cov_7.570845_g12313_i0 PRJNA690592 13163 807 7.570845 61.09671915 Bacteria 2 Bacteria Bacteria 147 2.2e-39   NR TDJ03996.1 1962856 g12313 i0 37.2 2.50185873605948 226 133 82.9 4 790 122 2 221 TDJ03996.1 MAG: MIP family channel protein [Caldithrix sp.] diamond 2019 148 0.993243243243243 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix sp.
27524785 27524785 PRJNA690592_S_NODE_12563_length_824_cov_2.095872_g11730_i0 PRJNA690592 12563 824 2.095872 17.26998528 Calditrichota bacterium 2212469 Bacteria Bacteria 73.2 2.71e-11   NR MCB0293765.1 2212469 g11730 i0 32.2 0.531553398058252 146 98 53.2 1 248 685 87 231 MCB0293765.1 endonuclease [Calditrichota bacterium] diamond 438 73.2 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
28641522 28641522 PRJNA690592_S_NODE_81887_length_355_cov_2.432624_g80873_i0 PRJNA690592 81887 355 2.432624 8.6358152 Bacteria 2 Bacteria Bacteria 51.2 1.29e-4   NR HHJ53046.1 187145 g80873 i0 38.5 4.35211267605634 52 32 43.9 0 165 10 69 120 HHJ53046.1 cyclic nucleotide-binding domain-containing protein [Caldithrix abyssi] diamond 1545 51.2 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix abyssi
28850750 28850750 PRJNA690592_S_NODE_30988_length_545_cov_1.444915_g29982_i0 PRJNA690592 30988 545 1.444915 7.87478675 Calditrichota bacterium 2212469 Bacteria Bacteria 126 1.82e-32   NR KAA3618267.1 2212469 g29982 i0 54.3 0.638532110091743 116 46 63.9 1 179 526 4 112 KAA3618267.1 MAG: hypothetical protein DWQ03_00730 [Calditrichota bacterium] diamond 348 126 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
31642348 31642348 PRJNA690592_S_NODE_202656_length_245_cov_1.343023_g201642_i0 PRJNA690592 202656 245 1.343023 3.29040635 Pseudomonadati 3379134 Bacteria Bacteria 131 2.1e-33   NR RMF59283.1 2212469 g201642 i0 72.8 19.5183673469388 81 22 99.2 0 245 3 870 950 RMF59283.1 MAG: glycine dehydrogenase (aminomethyl-transferring) [Calditrichota bacterium] diamond 4782 132 0.992424242424242 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
31820699 31820699 PRJNA690592_S_NODE_150097_length_277_cov_1.132353_g149083_i0 PRJNA690592 150097 277 1.132353 3.13661781 Caldithrix sp. 1962856 Bacteria Bacteria 46.2 0.00105   NR TDI86511.1 1962856 g149083 i0 35.1 2.39350180505415 77 48 83.4 2 4 234 44 118 TDI86511.1 MAG: hypothetical protein E2O78_02765 [Caldithrix sp.] diamond 663 46.2 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix sp.

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