contig_metadata
9 rows where bioproject = "PRJNA977246", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25177959 | 25177959 | PRJNA977246_S_NODE_8060_length_550_cov_7.299424_g7219_i0 | PRJNA977246 | 8060 | 550 | 7.299424 | 40.146832 | Dissulfurispira thermophila | 2715679 | Bacteria | Bacteria | 701 | 0 | NTclustered | gi|1901208073|dbj|AP022873.1| | 2715679 | g7219 | i0 | 90.548 | 0.961818181818182 | 529 | 50 | 96 | 0 | 4 | 532 | 373812 | 373284 | Dissulfurispira thermophila T55J DNA, complete genome | blastn | 529 | 701 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Thermodesulfovibrionia | Thermodesulfovibrionales | Dissulfurispiraceae | Dissulfurispira | Dissulfurispira thermophila | ||
| 26772956 | 26772956 | PRJNA977246_S_NODE_45401_length_165_cov_2.389706_g44409_i0 | PRJNA977246 | 45401 | 165 | 2.389706 | 3.9430149 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 42 | 0.0255 | NR | UVT15741.1 | 70125 | g44409 | i0 | 42.9 | 0.890909090909091 | 49 | 28 | 89.1 | 0 | 13 | 159 | 12 | 60 | UVT15741.1 MAG: RHS repeat protein [Nitrospira sp.] | diamond | 147 | 42 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 27247379 | 27247379 | PRJNA977246_S_NODE_49803_length_154_cov_3.208000_g48811_i0 | PRJNA977246 | 49803 | 154 | 3.208 | 4.94032 | Nitrospiraceae bacterium | 2026770 | Bacteria | Bacteria | 80.1 | 7.43e-16 | NR | MFQ5931369.1 | 2026770 | g48811 | i0 | 80 | 1.94805194805195 | 50 | 9 | 97.4 | 1 | 153 | 4 | 184 | 232 | MFQ5931369.1 Hsp70 family protein [Nitrospiraceae bacterium] | diamond | 300 | 80.1 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospiraceae bacterium | |||
| 28542283 | 28542283 | PRJNA977246_S_NODE_19507_length_315_cov_3.828671_g18515_i0 | PRJNA977246 | 19507 | 315 | 3.828671 | 12.06031365 | Nitrospirales bacterium | 2358460 | Bacteria | Bacteria | 106 | 5.61e-25 | NR | MEX2490135.1 | 2358460 | g18515 | i0 | 53.8 | 1.66666666666667 | 93 | 43 | 88.6 | 0 | 23 | 301 | 72 | 164 | MEX2490135.1 hypothetical protein [Nitrospirales bacterium] | diamond | 525 | 106 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospirales bacterium | ||||
| 30784421 | 30784421 | PRJNA977246_S_NODE_23734_length_273_cov_2.696721_g22742_i0 | PRJNA977246 | 23734 | 273 | 2.696721 | 7.36204833 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 171 | 3.4e-50 | NR | HEX5549688.1 | 70125 | g22742 | i0 | 95.6 | 0.989010989010989 | 90 | 4 | 98.9 | 0 | 271 | 2 | 65 | 154 | HEX5549688.1 Gfo/Idh/MocA family oxidoreductase [Nitrospira sp.] | diamond | 270 | 171 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 31194771 | 31194771 | PRJNA977246_S_NODE_30955_length_221_cov_3.296875_g29963_i0 | PRJNA977246 | 30955 | 221 | 3.296875 | 7.28609375 | Thermodesulfovibrio sp. 1176 | 3043424 | Bacteria | Bacteria | 51.6 | 2.11e-5 | NR | WP_281320892.1 | 3043424 | g29963 | i0 | 41.5 | 1.35746606334842 | 53 | 31 | 71.9 | 0 | 61 | 219 | 374 | 426 | WP_281320892.1 ribonucleoside triphosphate reductase [Thermodesulfovibrio sp. 1176] | diamond | 300 | 51.6 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Thermodesulfovibrionia | Thermodesulfovibrionales | Thermodesulfovibrionaceae | Thermodesulfovibrio | Thermodesulfovibrio sp. 1176 | ||
| 31226646 | 31226646 | PRJNA977246_S_NODE_51835_length_150_cov_2.066116_g50843_i0 | PRJNA977246 | 51835 | 150 | 2.066116 | 3.099174 | Nitrospirota bacterium | 2026887 | Bacteria | Bacteria | 68.6 | 5.45e-12 | NR | MEK7301034.1 | 2026887 | g50843 | i0 | 91.4 | 0.7 | 35 | 3 | 70 | 0 | 128 | 24 | 270 | 304 | MEK7301034.1 NAD(P)/FAD-dependent oxidoreductase [Nitrospirota bacterium] | diamond | 105 | 68.6 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospirota bacterium | ||||||
| 32087058 | 32087058 | PRJNA977246_S_NODE_18658_length_325_cov_2.976351_g17666_i0 | PRJNA977246 | 18658 | 325 | 2.976351 | 9.67314075 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 176 | 2.38e-51 | NR | MCS6896487.1 | 70125 | g17666 | i0 | 80.2 | 2.79692307692308 | 101 | 20 | 93.2 | 0 | 11 | 313 | 242 | 342 | MCS6896487.1 hypothetical protein [Nitrospira sp.] | diamond | 909 | 177 | 0.994350282485876 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 32838815 | 32838815 | PRJNA977246_S_NODE_17140_length_344_cov_3.320635_g16148_i0 | PRJNA977246 | 17140 | 344 | 3.320635 | 11.4229844 | Nitrospiraceae bacterium | 2026770 | Bacteria | Bacteria | 174 | 4.309999999999999e-52 | NR | MBX9659592.1 | 2026770 | g16148 | i0 | 98.9 | 0.784883720930233 | 90 | 1 | 78.5 | 0 | 271 | 2 | 100 | 189 | MBX9659592.1 hypothetical protein [Nitrospiraceae bacterium] | diamond | 270 | 174 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospiraceae 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);;