contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27672926 | 27672926 | PRJNA1198392_P_NODE_18504_length_246_cov_0.890173_g18363_i0 | PRJNA1198392 | 18504 | 246 | 0.890173 | 2.18982558 | Vibrio phage Va1 | 2508852 | Viruses | Viruses | 112 | 8.090000000000001e-27 | NR | QAU04482.1 | 2508852 | g18363 | i0 | 70.7 | 1 | 82 | 23 | 98.8 | 1 | 244 | 2 | 295 | 376 | QAU04482.1 putative DNA polymerase [Vibrio phage Va1] | diamond | 246 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage Va1 | |||||
| 30357407 | 30357407 | PRJNA1198392_P_NODE_17392_length_248_cov_1.348571_g17251_i0 | PRJNA1198392 | 17392 | 248 | 1.348571 | 3.34445608 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 52 | 2.14e-5 | NR | CAB4143662.1 | 2100421 | g17251 | i0 | 50.7 | 0.810483870967742 | 67 | 25 | 81 | 2 | 2 | 202 | 293 | 351 | CAB4143662.1 hypothetical protein UFOVP450_193 [uncultured Caudovirales phage] | diamond | 201 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31463201 | 31463201 | PRJNA1198392_P_NODE_3356_length_415_cov_0.900585_g3215_i0 | PRJNA1198392 | 3356 | 415 | 0.900585 | 3.73742775 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 3.86e-24 | NR | DAM72212.1 | 2832643 | g3215 | i0 | 45 | 1.87228915662651 | 129 | 66 | 90.4 | 3 | 38 | 412 | 29 | 156 | DAM72212.1 MAG TPA: HNHc [Caudoviricetes sp.] | diamond | 777 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32601793 | 32601793 | PRJNA1198392_P_NODE_3700_length_398_cov_1.006154_g3559_i0 | PRJNA1198392 | 3700 | 398 | 1.006154 | 4.00449292 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 195 | 8.039999999999999e-60 | NR | QTP16066.1 | 2832643 | g3559 | i0 | 68.2 | 5.83417085427136 | 129 | 41 | 97.2 | 0 | 396 | 10 | 123 | 251 | QTP16066.1 terminase large subunit TerL, partial [Caudoviricetes sp.] | diamond | 2322 | 195 | 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);;