contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1249535" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27484588 | 27484588 | PRJNA1249535_S_NODE_81043_length_400_cov_1.314985_g77662_i0 | PRJNA1249535 | 81043 | 400 | 1.314985 | 5.25994 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 45.1 | 0.0219 | NR | DAR16837.1 | 2832643 | g77662 | i0 | 38.2 | 0.4125 | 55 | 34 | 41.3 | 0 | 205 | 369 | 52 | 106 | DAR16837.1 MAG TPA: putative cytoplasmic protein [Caudoviricetes sp.] | diamond | 165 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28621307 | 28621307 | PRJNA1249535_S_NODE_170727_length_322_cov_5.477912_g167344_i0 | PRJNA1249535 | 170727 | 322 | 5.477912 | 17.63887664 | Citrobacter phage CkP1 | 2799684 | Viruses | Viruses | 43.1 | 0.0341 | NR | QQG32173.1 | 2799684 | g167344 | i0 | 47.7 | 0.409937888198758 | 44 | 17 | 41 | 1 | 254 | 123 | 48 | 85 | QQG32173.1 hypothetical protein CkP1_0011 [Citrobacter phage CkP1] | diamond | 132 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Karamvirus | Citrobacter phage CkP1 | ||
| 30042046 | 30042046 | PRJNA1249535_S_NODE_134711_length_345_cov_4.893382_g131328_i0 | PRJNA1249535 | 134711 | 345 | 4.893382 | 16.8821679 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42.4 | 0.0132 | NR | DAE83087.1 | 2832643 | g131328 | i0 | 39.5 | 0.373913043478261 | 43 | 25 | 36.5 | 1 | 131 | 6 | 3 | 45 | DAE83087.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 129 | 42.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;