contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13592334 | 13592334 | PRJNA849822_P_NODE_28751_length_272_cov_1.567839_g28577_i0 | PRJNA849822 | 28751 | 272 | 1.567839 | 4.26452208 | Mycobacterium phage Laurie | 1874015 | Viruses | Viruses | 147 | 1.57e-39 | NR | YP_010012418.1 | 1874015 | g28577 | i0 | 83.3 | 0.992647058823529 | 90 | 15 | 99.3 | 0 | 270 | 1 | 225 | 314 | YP_010012418.1 DNA helicase [Mycobacterium phage Laurie] | diamond | 270 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rosebushvirus | Rosebushvirus laurie | ||||
| 26865389 | 26865389 | PRJNA849822_P_NODE_34681_length_252_cov_0.871508_g34507_i0 | PRJNA849822 | 34681 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.4 | 1.92e-21 | NR | XOR20509.1 | 2832643 | g34507 | i0 | 67.7 | 0.738095238095238 | 62 | 20 | 73.8 | 0 | 1 | 186 | 427 | 488 | XOR20509.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 186 | 97.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27117937 | 27117937 | PRJNA849822_P_NODE_36922_length_249_cov_0.886364_g36748_i0 | PRJNA849822 | 36922 | 249 | 0.886364 | 2.20704636 | Thermus phage YS4 | 2494333 | Viruses | Viruses | 147 | 1.82e-39 | NR | AZU97664.1 | 2494333 | g36748 | i0 | 82.7 | 0.975903614457831 | 81 | 14 | 97.6 | 0 | 247 | 5 | 82 | 162 | AZU97664.1 hypothetical protein PGDDIFCJ_00034 [Thermus phage YS40_Isch] | diamond | 243 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage YS40_Isch | |||||
| 27560302 | 27560302 | PRJNA849822_P_NODE_41224_length_244_cov_0.912281_g41050_i0 | PRJNA849822 | 41224 | 244 | 0.912281 | 2.22596564 | Haloferax tailed virus 1 | 2507575 | Viruses | Viruses | 58.5 | 7.08e-8 | NR | YP_010355945.1 | 2507575 | g41050 | i0 | 46.3 | 1.81967213114754 | 80 | 42 | 98.4 | 1 | 243 | 4 | 38 | 116 | YP_010355945.1 PCNA [Haloferax tailed virus 1] | diamond | 444 | 58.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Haloferuviridae | Retbasiphovirus | Retbasiphovirus hantatum | ||
| 28539530 | 28539530 | PRJNA849822_P_NODE_38747_length_247_cov_0.896552_g38573_i0 | PRJNA849822 | 38747 | 247 | 0.896552 | 2.21448344 | Halorubrum virus HRTV-11 | 2877992 | Viruses | Viruses | 51.6 | 2.89e-5 | NR | UBF22343.1 | 2877992 | g38573 | i0 | 38.9 | 0.874493927125506 | 72 | 41 | 85 | 2 | 210 | 1 | 48 | 118 | UBF22343.1 hypothetical protein HRTV-11_gp86 [Halorubrum virus HRTV-11] | diamond | 216 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Hafunaviridae | Mincapvirus | Halorubrum virus HRTV-11 | ||
| 29233988 | 29233988 | PRJNA849822_P_NODE_34349_length_252_cov_0.871508_g34175_i0 | PRJNA849822 | 34349 | 252 | 0.871508 | 2.19620016 | Rhizobium phage RHph_TM21B | 2509757 | Viruses | Viruses | 112 | 2.5e-30 | NR | QIG77368.1 | 2509757 | g34175 | i0 | 77.6 | 1.38095238095238 | 58 | 13 | 69 | 0 | 175 | 2 | 1 | 58 | QIG77368.1 hypothetical protein EVB61_040 [Rhizobium phage RHph_TM21B] | diamond | 348 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kleczkowskaviridae | Cuauhnahuacvirus | Rhizobium phage RHph_TM21B | |||
| 29423137 | 29423137 | PRJNA849822_P_NODE_34709_length_252_cov_0.871508_g34535_i0 | PRJNA849822 | 34709 | 252 | 0.871508 | 2.19620016 | Nitrincola phage 1M3-16 | 1472912 | Viruses | Viruses | 87.8 | 5.66e-18 | NR | YP_009037283.1 | 1472912 | g34535 | i0 | 51.8 | 0.988095238095238 | 83 | 39 | 97.6 | 1 | 6 | 251 | 26 | 108 | YP_009037283.1 DNA polymerase [Nitrincola phage 1M3-16] | diamond | 249 | 87.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Nitrincola phage 1M3-16 | |||||
| 29612435 | 29612435 | PRJNA849822_P_NODE_40490_length_245_cov_0.906977_g40316_i0 | PRJNA849822 | 40490 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 76.6 | 4.17e-14 | NR | UOF78612.1 | 2832643 | g40316 | i0 | 39.5 | 0.991836734693878 | 81 | 49 | 99.2 | 0 | 243 | 1 | 111 | 191 | UOF78612.1 hypothetical protein [Caudoviricetes sp.] | diamond | 243 | 76.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31508842 | 31508842 | PRJNA849822_P_NODE_42336_length_243_cov_0.917647_g42162_i0 | PRJNA849822 | 42336 | 243 | 0.917647 | 2.22988221 | Brevundimonas phage vB_BpoS-MaInes | 2948603 | Viruses | Viruses | 58.2 | 4.67e-8 | NR | UTC30072.1 | 2948603 | g42162 | i0 | 47.5 | 0.753086419753086 | 61 | 32 | 75.3 | 0 | 214 | 32 | 8 | 68 | UTC30072.1 hypothetical protein MAINES_00330 [Brevundimonas phage vB_BpoS-MaInes] | diamond | 183 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Brevundimonas phage vB_BpoS-MaInes |
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);;