RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Calditrichota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Calditrichota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120060 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26720218 26720218 PRJNA1120060_P_NODE_2074881_length_270_cov_0.984772_g2056844_i0 PRJNA1120060 2074881 270 0.984772 2.6588844 Calditrichia bacterium 2268178 Bacteria Bacteria 61.2 1.5e-8   NR NOQ97226.1 2268178 g2056844 i0 37.8 0.911111111111111 82 50 91.1 1 23 268 16 96 NOQ97226.1 glycosidase [Calditrichia bacterium] diamond 246 61.2 1 Bacteria   Pseudomonadati Calditrichota Calditrichia       Calditrichia bacterium
26720790 26720790 PRJNA1120060_P_NODE_2969141_length_242_cov_1.349112_g2951047_i0 PRJNA1120060 2969141 242 1.349112 3.26485104 Calditrichota bacterium 2212469 Bacteria Bacteria 43.5 0.0198   NR NOZ61591.1 2212469 g2951047 i0 59.1 0.272727272727273 22 9 27.3 0 121 186 389 410 NOZ61591.1 S9 family peptidase [Calditrichota bacterium] diamond 66 43.5 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
27763722 27763722 PRJNA1120060_P_NODE_1705284_length_285_cov_1.132075_g1687280_i0 PRJNA1120060 1705284 285 1.132075 3.22641375 Calditrichota bacterium 2212469 Bacteria Bacteria 45.1 0.00786   NR MEJ2050421.1 2212469 g1687280 i0 36.8 0.8 76 38 69.5 1 4 201 102 177 MEJ2050421.1 DUF4919 domain-containing protein [Calditrichota bacterium] diamond 228 45.1 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
27827436 27827436 PRJNA1120060_P_NODE_2785664_length_246_cov_2.624277_g2767578_i0 PRJNA1120060 2785664 246 2.624277 6.45572142 Calditrichia bacterium 2268178 Bacteria Bacteria 42.7 0.0368   NR MCK4560839.1 2268178 g2767578 i0 31.5 0.890243902439024 73 41 78 1 217 26 160 232 MCK4560839.1 sulfatase-like hydrolase/transferase [Calditrichia bacterium] diamond 219 42.7 1 Bacteria   Pseudomonadati Calditrichota Calditrichia       Calditrichia bacterium
28395147 28395147 PRJNA1120060_P_NODE_1987526_length_273_cov_2.280000_g1969498_i0 PRJNA1120060 1987526 273 2.28 6.2244 Calditrichota bacterium 2212469 Bacteria Bacteria 41.6 0.0255   NR MBT3231526.1 2212469 g1969498 i0 39.1 0.505494505494505 46 27 49.5 1 83 217 37 82 MBT3231526.1 hypothetical protein [Calditrichota bacterium] diamond 138 41.6 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
29468256 29468256 PRJNA1120060_P_NODE_1864390_length_278_cov_2.141463_g1846374_i0 PRJNA1120060 1864390 278 2.141463 5.95326714 Calditrichota bacterium 2212469 Bacteria Bacteria 43.5 0.0307   NR NOZ61591.1 2212469 g1846374 i0 54.5 0.237410071942446 22 10 23.7 0 220 155 389 410 NOZ61591.1 S9 family peptidase [Calditrichota bacterium] diamond 66 43.5 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
30922636 30922636 PRJNA1120060_P_NODE_2864934_length_244_cov_3.251462_g2846845_i0 PRJNA1120060 2864934 244 3.251462 7.93356728 Calditrichota bacterium 2212469 Bacteria Bacteria 42.4 0.0491   NR NQU06729.1 2212469 g2846845 i0 38.5 0.639344262295082 52 31 62.7 1 155 3 114 165 NQU06729.1 hypothetical protein [Calditrichota bacterium] diamond 156 42.4 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
32091846 32091846 PRJNA1120060_P_NODE_1932958_length_275_cov_3.079208_g1914934_i0 PRJNA1120060 1932958 275 3.079208 8.467822 Calditrichaceae bacterium 2614252 Bacteria Bacteria 43.1 0.0361   NR MBN2425036.1 2614252 g1914934 i0 32.1 0.883636363636364 81 49 87.3 2 258 19 43 118 MBN2425036.1 hypothetical protein [Calditrichaceae bacterium] diamond 243 43.1 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae   Calditrichaceae bacterium
32187975 32187975 PRJNA1120060_P_NODE_59778_length_673_cov_2.591667_g47524_i0 PRJNA1120060 59778 673 2.591667 17.44191891 Calditrichota bacterium 2212469 Bacteria Bacteria 77 7.54e-14   NR RMG67887.1 2212469 g47524 i0 38.2 0.87369985141159 102 63 45.5 0 361 56 40 141 RMG67887.1 MAG: reverse transcriptase-like protein [Calditrichota bacterium] diamond 588 77 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota 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);;