contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26756455 | 26756455 | PRJNA1237347_P_NODE_374921_length_290_cov_1.861751_g368348_i0 | PRJNA1237347 | 374921 | 290 | 1.861751 | 5.3990779 | Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_ | 2052152 | Bacteria | Bacteria | 72.4 | 2.43e-12 | NR | OGI69003.1 | 1801743 | g368348 | i0 | 63.4 | 2.04827586206897 | 71 | 21 | 69.3 | 2 | 285 | 85 | 251 | 320 | OGI69003.1 MAG: hypothetical protein A2824_02480 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_42_16] | diamond | 594 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_42_16 | ||||||
| 26756622 | 26756622 | PRJNA1237347_P_NODE_506141_length_247_cov_0.885057_g499568_i0 | PRJNA1237347 | 506141 | 247 | 0.885057 | 2.18609079 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 130 | 1.58e-33 | NR | USN96510.1 | 2052152 | g499568 | i0 | 79.3 | 1.97975708502024 | 82 | 17 | 99.6 | 0 | 1 | 246 | 125 | 206 | USN96510.1 MAG: arginine--tRNA ligase [Candidatus Nomurabacteria bacterium] | diamond | 489 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 27231175 | 27231175 | PRJNA1237347_P_NODE_399263_length_280_cov_1.154589_g392690_i0 | PRJNA1237347 | 399263 | 280 | 1.154589 | 3.2328492 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 68.6 | 5.01e-11 | NR | MDR0591100.1 | 2052152 | g392690 | i0 | 40.2 | 1.09285714285714 | 102 | 52 | 99.6 | 2 | 280 | 2 | 91 | 192 | MDR0591100.1 IPT/TIG domain-containing protein [Candidatus Nomurabacteria bacterium] | diamond | 306 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 28715401 | 28715401 | PRJNA1237347_P_NODE_373287_length_291_cov_1.412844_g366714_i0 | PRJNA1237347 | 373287 | 291 | 1.412844 | 4.11137604 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 70.9 | 9.16e-12 | NR | MCB9814244.1 | 2052152 | g366714 | i0 | 39.2 | 1.95876288659794 | 97 | 58 | 100 | 1 | 291 | 1 | 320 | 415 | MCB9814244.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 570 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 28828348 | 28828348 | PRJNA1237347_P_NODE_431148_length_267_cov_1.190722_g424575_i0 | PRJNA1237347 | 431148 | 267 | 1.190722 | 3.17922774 | Bacillati | 1783272 | Bacteria | Bacteria | 52.8 | 1.45e-5 | NR | MCC7160159.1 | 2052152 | g424575 | i0 | 49.2 | 3.24719101123596 | 59 | 28 | 64 | 1 | 265 | 95 | 121 | 179 | MCC7160159.1 peptidoglycan-binding protein [Candidatus Nomurabacteria bacterium] | diamond | 867 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 32064451 | 32064451 | PRJNA1237347_P_NODE_298178_length_335_cov_1.759542_g291605_i0 | PRJNA1237347 | 298178 | 335 | 1.759542 | 5.8944657 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 110 | 2.6e-25 | NR | USN92664.1 | 2052152 | g291605 | i0 | 58.6 | 0.886567164179105 | 99 | 37 | 85.1 | 1 | 51 | 335 | 341 | 439 | USN92664.1 MAG: right-handed parallel beta-helix repeat-containing protein [Candidatus Nomurabacteria bacterium] | diamond | 297 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 32128013 | 32128013 | PRJNA1237347_P_NODE_296798_length_336_cov_1.718631_g290225_i0 | PRJNA1237347 | 296798 | 336 | 1.718631 | 5.77460016 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 54.3 | 1.01e-5 | NR | MDR0591100.1 | 2052152 | g290225 | i0 | 49 | 0.455357142857143 | 51 | 26 | 45.5 | 0 | 7 | 159 | 88 | 138 | MDR0591100.1 IPT/TIG domain-containing protein [Candidatus Nomurabacteria bacterium] | diamond | 153 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 32159378 | 32159378 | PRJNA1237347_P_NODE_109218_length_644_cov_1.651489_g102758_i0 | PRJNA1237347 | 109218 | 644 | 1.651489 | 10.63558916 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 89.4 | 1.47e-16 | NR | MDR0591100.1 | 2052152 | g102758 | i0 | 30.1 | 1.02018633540373 | 219 | 135 | 94.6 | 5 | 34 | 642 | 157 | 373 | MDR0591100.1 IPT/TIG domain-containing protein [Candidatus Nomurabacteria bacterium] | diamond | 657 | 89.4 | 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);;