contig_metadata
7 rows where bioproject = "PRJNA1255065" and tax_phylum = "Nitrospirota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28747561 | 28747561 | PRJNA1255065_P_NODE_138267_length_164_cov_0.904348_g136039_i0 | PRJNA1255065 | 138267 | 164 | 0.904348 | 1.48313072 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 68.6 | 1.64e-13 | NR | MFO0705273.1 | 70125 | g136039 | i0 | 65.2 | 0.841463414634146 | 46 | 16 | 84.1 | 0 | 3 | 140 | 10 | 55 | MFO0705273.1 hypothetical protein [Nitrospira sp.] | diamond | 138 | 68.6 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 28986737 | 28986737 | PRJNA1255065_P_NODE_152748_length_162_cov_0.920354_g150520_i0 | PRJNA1255065 | 152748 | 162 | 0.920354 | 1.49097348 | Nitrospira | 1234 | Bacteria | Bacteria | 106 | 3.77e-25 | NR | WP_143838597.1 | 96242 | g150520 | i0 | 96.2 | 5.88888888888889 | 53 | 2 | 98.1 | 0 | 161 | 3 | 457 | 509 | WP_143838597.1 Lon protease family protein, partial [Nitrospira cf. moscoviensis SBR1015] | diamond | 954 | 106 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira cf. moscoviensis SBR1015 | ||
| 30010791 | 30010791 | PRJNA1255065_P_NODE_55971_length_262_cov_0.976526_g53743_i0 | PRJNA1255065 | 55971 | 262 | 0.976526 | 2.55849812 | Candidatus Nitronereus thalassa | 3020898 | Bacteria | Bacteria | 43.5 | 0.0253 | NR | WP_313833734.1 | 3020898 | g53743 | i0 | 51.6 | 0.354961832061069 | 31 | 15 | 35.5 | 0 | 153 | 245 | 527 | 557 | WP_313833734.1 hypothetical protein [Candidatus Nitronereus thalassa] | diamond | 93 | 43.5 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Candidatus Nitronereus | Candidatus Nitronereus thalassa | ||
| 31337665 | 31337665 | PRJNA1255065_P_NODE_139556_length_164_cov_0.904348_g137328_i0 | PRJNA1255065 | 139556 | 164 | 0.904348 | 1.48313072 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 124 | 1.4699999999999998e-35 | NR | TKB65094.1 | 70125 | g137328 | i0 | 100 | 1.97560975609756 | 54 | 0 | 98.8 | 0 | 164 | 3 | 13 | 66 | TKB65094.1 MAG: hypothetical protein E8D52_18650, partial [Nitrospira sp.] | diamond | 324 | 124 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 32350282 | 32350282 | PRJNA1255065_P_NODE_133879_length_165_cov_0.896552_g131651_i0 | PRJNA1255065 | 133879 | 165 | 0.896552 | 1.4793108 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 96.7 | 1.36e-21 | NR | NOU10305.1 | 70125 | g131651 | i0 | 75.9 | 0.981818181818182 | 54 | 13 | 98.2 | 0 | 162 | 1 | 479 | 532 | NOU10305.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Nitrospira sp.] | diamond | 162 | 96.7 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 32697365 | 32697365 | PRJNA1255065_P_NODE_146500_length_163_cov_0.912281_g144272_i0 | PRJNA1255065 | 146500 | 163 | 0.912281 | 1.48701803 | Candidatus Nitrospira nitrosa | 1742972 | Bacteria | Bacteria | 109 | 4.660000000000001e-27 | NR | WP_090743850.1 | 1742972 | g144272 | i0 | 98.1 | 1.91411042944785 | 52 | 1 | 95.7 | 0 | 6 | 161 | 213 | 264 | WP_090743850.1 glycosyltransferase family 4 protein [Candidatus Nitrospira nitrosa] | diamond | 312 | 109 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Candidatus Nitrospira nitrosa | ||
| 32872669 | 32872669 | PRJNA1255065_P_NODE_151640_length_162_cov_0.920354_g149412_i0 | PRJNA1255065 | 151640 | 162 | 0.920354 | 1.49097348 | Nitrospira | 1234 | Bacteria | Bacteria | 86.3 | 2.74e-18 | NR | HMS85978.1 | 70125 | g149412 | i0 | 89.1 | 11.0555555555556 | 46 | 5 | 85.2 | 0 | 156 | 19 | 302 | 347 | HMS85978.1 NAD(P)-dependent alcohol dehydrogenase [Nitrospira sp.] | diamond | 1791 | 86.3 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. |
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);;