contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1164198" and tax_phylum = "Verrucomicrobiota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2862779 | 2862779 | PRJNA1164198_P_NODE_16203_length_307_cov_2.632479_g15934_i0 | PRJNA1164198 | 16203 | 307 | 2.632479 | 8.08171053 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 239 | 2.05e-58 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g15934 | i0 | 82.394 | 189.296416938111 | 284 | 40 | 91 | 10 | 1 | 279 | 3047224 | 3047502 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 58114 | 239 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 6689890 | 6689890 | PRJNA1164198_P_NODE_21146_length_270_cov_1.517766_g20877_i0 | PRJNA1164198 | 21146 | 270 | 1.517766 | 4.0979682 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 342 | 1.31e-89 | NTclustered | gi|2621704341|emb|OY760937.1| | 2499141 | g20877 | i0 | 89.63 | 133.048148148148 | 270 | 27 | 100 | 1 | 1 | 270 | 3992068 | 3991800 | MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1 | blastn | 35923 | 342 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 7965180 | 7965180 | PRJNA1164198_P_NODE_16167_length_308_cov_1.174468_g15898_i0 | PRJNA1164198 | 16167 | 308 | 1.174468 | 3.61736144 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 525 | 1.4099999999999995e-144 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g15898 | i0 | 97.403 | 244.857142857143 | 308 | 8 | 100 | 0 | 1 | 308 | 2488 | 2795 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 75416 | 525 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 13065601 | 13065601 | PRJNA1164198_P_NODE_2991_length_725_cov_3.254601_g2770_i0 | PRJNA1164198 | 2991 | 725 | 3.254601 | 23.59585725 | Prosthecobacter dejongeii | 48465 | Bacteria | Bacteria | 1201 | 0 | NTclustered | gi|183579826|emb|AM905423.1| | 48465 | g2770 | i0 | 96.556 | 128.51724137931 | 726 | 24 | 100 | 1 | 1 | 725 | 1070 | 1795 | Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251 | blastn | 93175 | 1201 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter dejongeii | |
| 16889127 | 16889127 | PRJNA1164198_P_NODE_5994_length_513_cov_3.020455_g5739_i0 | PRJNA1164198 | 5994 | 513 | 3.020455 | 15.49493415 | Prosthecobacter debontii | 48467 | Bacteria | Bacteria | 898 | 0 | NTclustered | gi|164510703|emb|AJ966882.1| | 48467 | g5739 | i0 | 98.252 | 274.009746588694 | 515 | 5 | 100 | 3 | 1 | 513 | 4544 | 4032 | Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044 | blastn | 140567 | 898 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter debontii | |
| 23264192 | 23264192 | PRJNA1164198_P_NODE_2079_length_859_cov_2.913486_g1894_i0 | PRJNA1164198 | 2079 | 859 | 2.913486 | 25.02684474 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 1459 | 0 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g1894 | i0 | 97.322 | 272.527357392317 | 859 | 23 | 100 | 0 | 1 | 859 | 1052 | 194 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 234101 | 1459 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis |
Advanced export
JSON shape: default, array, newline-delimited
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);;