contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27258053 | 27258053 | PRJNA1120060_P_NODE_1450243_length_295_cov_7.590090_g1432258_i0 | PRJNA1120060 | 1450243 | 295 | 7.59009 | 22.3907655 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 104 | 2.51e-24 | NR | MFA7054871.1 | 2212473 | g1432258 | i0 | 94 | 0.508474576271186 | 50 | 3 | 50.8 | 0 | 144 | 293 | 172 | 221 | MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium] | diamond | 150 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28111406 | 28111406 | PRJNA1120060_P_NODE_2766865_length_247_cov_0.890805_g2748781_i0 | PRJNA1120060 | 2766865 | 247 | 0.890805 | 2.20028835 | Kiritimatiellota bacterium | 2599938 | Bacteria | Bacteria | 43.1 | 0.0283 | NR | MCL1920442.1 | 2599938 | g2748781 | i0 | 37.5 | 0.680161943319838 | 56 | 30 | 64.4 | 3 | 84 | 242 | 374 | 427 | MCL1920442.1 glycoside hydrolase [Kiritimatiellota bacterium] | diamond | 168 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium | |||||
| 28237820 | 28237820 | PRJNA1120060_P_NODE_3082666_length_237_cov_2.207317_g3064565_i0 | PRJNA1120060 | 3082666 | 237 | 2.207317 | 5.23134129 | Kiritimatiellota bacterium | 2599938 | Bacteria | Bacteria | 42.4 | 0.0247 | NR | MCL2104969.1 | 2599938 | g3064565 | i0 | 33.3 | 0.759493670886076 | 60 | 26 | 58.2 | 2 | 31 | 168 | 35 | 94 | MCL2104969.1 cellulase family glycosylhydrolase [Kiritimatiellota bacterium] | diamond | 180 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium | |||||
| 28553287 | 28553287 | PRJNA1120060_P_NODE_2117007_length_268_cov_1.928205_g2098963_i0 | PRJNA1120060 | 2117007 | 268 | 1.928205 | 5.1675894 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 44.7 | 0.0106 | NR | MCQ2391836.1 | 2212473 | g2098963 | i0 | 32.8 | 0.649253731343284 | 58 | 30 | 54.9 | 1 | 115 | 261 | 363 | 420 | MCQ2391836.1 heparinase II/III-family protein [Kiritimatiellia bacterium] | diamond | 174 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30353574 | 30353574 | PRJNA1120060_P_NODE_1987232_length_273_cov_2.320000_g1969204_i0 | PRJNA1120060 | 1987232 | 273 | 2.32 | 6.3336 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 44.3 | 0.0144 | NR | MBQ7188996.1 | 2212473 | g1969204 | i0 | 33.3 | 0.89010989010989 | 81 | 53 | 87.9 | 1 | 31 | 270 | 210 | 290 | MBQ7188996.1 ABC transporter ATP-binding protein [Kiritimatiellia bacterium] | diamond | 243 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30890322 | 30890322 | PRJNA1120060_P_NODE_2037874_length_271_cov_2.196970_g2019837_i0 | PRJNA1120060 | 2037874 | 271 | 2.19697 | 5.9537887 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 43.1 | 0.0388 | NR | MBP5511123.1 | 2212473 | g2019837 | i0 | 34.8 | 0.730627306273063 | 66 | 41 | 70.8 | 2 | 27 | 218 | 1147 | 1212 | MBP5511123.1 DUF3320 domain-containing protein [Kiritimatiellia bacterium] | diamond | 198 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31395728 | 31395728 | PRJNA1120060_P_NODE_1484716_length_294_cov_2.520362_g1466729_i0 | PRJNA1120060 | 1484716 | 294 | 2.520362 | 7.40986428 | Candidatus Colisoma equi | 3083071 | Bacteria | Bacteria | 43.1 | 0.0469 | NR | MBQ0031421.1 | 3083071 | g1466729 | i0 | 46.3 | 0.418367346938776 | 41 | 22 | 41.8 | 0 | 171 | 49 | 115 | 155 | MBQ0031421.1 glycosyltransferase [Candidatus Colisoma equi] | diamond | 123 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Candidatus Colisoma | Candidatus Colisoma equi |
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);;