contig_metadata
5 rows where bioproject = "PRJEB28062" and tax_phylum = "Candidatus Nomuraibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16600681 | 16600681 | PRJEB28062_P_NODE_121774_length_256_cov_3.153005_g119410_i0 | PRJEB28062 | 121774 | 256 | 3.153005 | 8.0716928 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 339 | 1.5999999999999998e-88 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g119410 | i0 | 92.735 | 82.86328125 | 234 | 17 | 91 | 0 | 1 | 234 | 962529 | 962762 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 21213 | 339 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 26780103 | 26780103 | PRJEB28062_P_NODE_51221_length_497_cov_6.603774_g48871_i0 | PRJEB28062 | 51221 | 497 | 6.603774 | 32.82075678 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 166 | 8.94e-50 | NR | MCB9822400.1 | 2052152 | g48871 | i0 | 86.1 | 1.21931589537223 | 101 | 14 | 61 | 0 | 486 | 184 | 23 | 123 | MCB9822400.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 606 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 31392172 | 31392172 | PRJEB28062_P_NODE_118056_length_265_cov_3.145833_g115693_i0 | PRJEB28062 | 118056 | 265 | 3.145833 | 8.33645745 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 140 | 4.08e-40 | NR | MDB5259797.1 | 2052152 | g115693 | i0 | 86.4 | 1.82264150943396 | 81 | 11 | 91.7 | 0 | 264 | 22 | 80 | 160 | MDB5259797.1 translation initiation factor translation initiation factor [Candidatus Nomurabacteria bacterium] | diamond | 483 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 31898123 | 31898123 | PRJEB28062_P_NODE_83997_length_364_cov_3.683849_g81635_i0 | PRJEB28062 | 83997 | 364 | 3.683849 | 13.40921036 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 70.5 | 2.66e-11 | NR | USN96967.1 | 2052152 | g81635 | i0 | 49.3 | 1.76373626373626 | 69 | 35 | 56.9 | 0 | 54 | 260 | 466 | 534 | USN96967.1 MAG: glycosyltransferase family 2 protein [Candidatus Nomurabacteria bacterium] | diamond | 642 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 31961361 | 31961361 | PRJEB28062_P_NODE_89158_length_347_cov_12.762774_g86796_i0 | PRJEB28062 | 89158 | 347 | 12.762774 | 44.28682578 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 90.5 | 5.24e-20 | NR | HCC06221.1 | 2052152 | g86796 | i0 | 71.7 | 1.03746397694524 | 60 | 17 | 51.9 | 0 | 333 | 154 | 37 | 96 | HCC06221.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 360 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium |
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);;