contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4262052 | 4262052 | PRJNA438572_P_NODE_20564_length_248_cov_0.891429_g20445_i0 | PRJNA438572 | 20564 | 248 | 0.891429 | 2.21074392 | Klebsiella phage PhiKpNIH-6 | 2689112 | Viruses | Viruses | 160 | 1.6599999999999996e-43 | NR | QHB49514.1 | 2689112 | g20445 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 2 | 247 | 732 | 813 | QHB49514.1 baseplate wedge subunit [Klebsiella phage PhiKpNIH-6] | diamond | 246 | 160 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 28528901 | 28528901 | PRJNA438572_P_NODE_17787_length_252_cov_0.871508_g17668_i0 | PRJNA438572 | 17787 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 163 | 1.39e-44 | NR | XOR52197.1 | 2832643 | g17668 | i0 | 89.3 | 2 | 84 | 9 | 100 | 0 | 252 | 1 | 591 | 674 | XOR52197.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 504 | 163 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28528904 | 28528904 | PRJNA438572_P_NODE_19467_length_249_cov_0.886364_g19348_i0 | PRJNA438572 | 19467 | 249 | 0.886364 | 2.20704636 | Methylophilaceae phage P1925 | 1913040 | Viruses | Viruses | 43.1 | 0.0296 | NR | APC43904.1 | 1913040 | g19348 | i0 | 46.6 | 0.698795180722892 | 58 | 28 | 66.3 | 1 | 83 | 247 | 798 | 855 | APC43904.1 host specificity protein J [Methylophilaceae phage P19250A] | diamond | 174 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Methylophilaceae phage P19250A | |||||
| 28765959 | 28765959 | PRJNA438572_P_NODE_20707_length_247_cov_1.344828_g20588_i0 | PRJNA438572 | 20707 | 247 | 1.344828 | 3.32172516 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00334 | NR | BAR34331.1 | 1407671 | g20588 | i0 | 57.6 | 1.46963562753036 | 33 | 14 | 40.1 | 0 | 2 | 100 | 1242 | 1274 | BAR34331.1 hypothetical protein [uncultured Mediterranean phage uvMED] | diamond | 363 | 46.2 | 0.991341991341991 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 29349735 | 29349735 | PRJNA438572_P_NODE_14369_length_275_cov_1.158416_g14250_i0 | PRJNA438572 | 14369 | 275 | 1.158416 | 3.185644 | Ralstonia phage RsoM2USA | 2070027 | Viruses | Viruses | 51.6 | 4.26e-5 | NR | AVH85344.1 | 2070027 | g14250 | i0 | 44.8 | 1.38545454545455 | 58 | 32 | 63.3 | 0 | 273 | 100 | 191 | 248 | AVH85344.1 hypothetical protein RsoM2USA_416 [Ralstonia phage RsoM2USA] | diamond | 381 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RsoM2USA | |||||
| 30644566 | 30644566 | PRJNA438572_P_NODE_22853_length_244_cov_0.912281_g22734_i0 | PRJNA438572 | 22853 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75.1 | 1.51e-13 | NR | DAS78333.1 | 2832643 | g22734 | i0 | 48.8 | 2.01639344262295 | 82 | 36 | 99.6 | 3 | 244 | 2 | 485 | 561 | DAS78333.1 MAG TPA: DNA polymerase B [Caudoviricetes sp.] | diamond | 492 | 75.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31830509 | 31830509 | PRJNA438572_P_NODE_23177_length_244_cov_0.912281_g23058_i0 | PRJNA438572 | 23177 | 244 | 0.912281 | 2.22596564 | Straboviridae | 2946170 | Viruses | Viruses | 54.3 | 2.15e-7 | NR | YP_010092337.1 | 2006942 | g23058 | i0 | 53.5 | 1.56147540983607 | 43 | 20 | 52.9 | 0 | 1 | 129 | 43 | 85 | YP_010092337.1 hypothetical protein KNT72_gp229 [Serratia phage X20] | diamond | 381 | 54.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Winklervirus | Winklervirus xtwenty |
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);;