contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26631732 | 26631732 | PRJNA376117_P_NODE_37061_length_248_cov_0.880000_g36759_i0 | PRJNA376117 | 37061 | 248 | 0.88 | 2.1824 | Enterococcus phage EF-P29 | 1932891 | Viruses | Viruses | 83.6 | 3.82e-17 | NR | APU00244.1 | 1932891 | g36759 | i0 | 53.8 | 0.967741935483871 | 80 | 37 | 96.8 | 0 | 245 | 6 | 164 | 243 | APU00244.1 hypothetical protein EFP29_58 [Enterococcus phage EF-P29] | diamond | 240 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saphexavirus | Enterococcus phage EF-P29 | ||||
| 26965389 | 26965389 | PRJNA376117_P_NODE_15322_length_350_cov_1.920578_g15020_i0 | PRJNA376117 | 15322 | 350 | 1.920578 | 6.722023 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 4.79e-7 | NR | XOS24387.1 | 2832643 | g15020 | i0 | 39 | 1.23428571428571 | 77 | 46 | 66 | 1 | 113 | 343 | 76 | 151 | XOS24387.1 MAG: putative tail fiber protein [Caudoviricetes sp.] | diamond | 432 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27675380 | 27675380 | PRJNA376117_P_NODE_39444_length_246_cov_0.890173_g39142_i0 | PRJNA376117 | 39444 | 246 | 0.890173 | 2.18982558 | Pseudomonas phage GP1 | 2055238 | Viruses | Viruses | 152 | 8.03e-41 | NR | SPF82138.1 | 2055238 | g39142 | i0 | 93.8 | 0.98780487804878 | 81 | 5 | 98.8 | 0 | 244 | 2 | 1143 | 1223 | SPF82138.1 hypothetical protein [Pseudomonas phage GP100] | diamond | 243 | 152 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 27770077 | 27770077 | PRJNA376117_P_NODE_31324_length_260_cov_1.235294_g31022_i0 | PRJNA376117 | 31324 | 260 | 1.235294 | 3.2117644 | Vibrio phage jenny 12G5 | 573176 | Viruses | Viruses | 123 | 1.18e-32 | NR | AGN51381.1 | 573176 | g31022 | i0 | 69.8 | 1.97307692307692 | 86 | 26 | 99.2 | 0 | 1 | 258 | 87 | 172 | AGN51381.1 DNA methylase [Vibrio phage jenny 12G5] | diamond | 513 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage jenny 12G5 | |||||
| 28369671 | 28369671 | PRJNA376117_P_NODE_30206_length_264_cov_1.554974_g29904_i0 | PRJNA376117 | 30206 | 264 | 1.554974 | 4.10513136 | Aeromonas phage 1233 | 3074390 | Viruses | Viruses | 115 | 2.14e-30 | NR | WMX18609.1 | 3074390 | g29904 | i0 | 63.6 | 1 | 88 | 27 | 100 | 1 | 1 | 264 | 1 | 83 | WMX18609.1 hypothetical protein [Aeromonas phage 1233] | diamond | 264 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage 1233 | |||||
| 28464625 | 28464625 | PRJNA376117_P_NODE_44406_length_241_cov_0.916667_g44104_i0 | PRJNA376117 | 44406 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.4 | 6.48e-5 | NR | DAE71708.1 | 2832643 | g44104 | i0 | 55 | 0.49792531120332 | 40 | 18 | 49.8 | 0 | 120 | 239 | 17 | 56 | DAE71708.1 MAG TPA: DNA REPLICATION protein [Caudoviricetes sp.] | diamond | 120 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28496189 | 28496189 | PRJNA376117_P_NODE_31147_length_261_cov_0.872340_g30845_i0 | PRJNA376117 | 31147 | 261 | 0.87234 | 2.2768074 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 89 | 5.38e-19 | NR | XOR63742.1 | 2832643 | g30845 | i0 | 47.1 | 1 | 87 | 46 | 100 | 0 | 261 | 1 | 93 | 179 | XOR63742.1 MAG: putative virion structural protein [Caudoviricetes sp.] | diamond | 261 | 89 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28702707 | 28702707 | PRJNA376117_P_NODE_42447_length_243_cov_0.905882_g42145_i0 | PRJNA376117 | 42447 | 243 | 0.905882 | 2.20129326 | Winklervirus | 2560256 | Viruses | Viruses | 71.6 | 8.25e-13 | NR | YP_010092347.1 | 2006942 | g42145 | i0 | 43.9 | 2.80246913580247 | 66 | 37 | 81.5 | 0 | 2 | 199 | 59 | 124 | YP_010092347.1 baseplate hub assembly catalyst [Serratia phage X20] | diamond | 681 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Winklervirus | Winklervirus xtwenty | ||
| 29285251 | 29285251 | PRJNA376117_P_NODE_31229_length_260_cov_1.647059_g30927_i0 | PRJNA376117 | 31229 | 260 | 1.647059 | 4.2823534 | Pseudomonas phage PaBG | 1335230 | Viruses | Viruses | 56.2 | 8.26e-7 | NR | YP_008433590.2 | 1335230 | g30927 | i0 | 44.6 | 0.75 | 65 | 29 | 71.5 | 2 | 253 | 68 | 21 | 81 | YP_008433590.2 putative adhesin [Pseudomonas phage PaBG] | diamond | 195 | 56.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Baikalvirus | Baikalvirus PaBG | ||||
| 29537908 | 29537908 | PRJNA376117_P_NODE_27050_length_276_cov_1.034483_g26748_i0 | PRJNA376117 | 27050 | 276 | 1.034483 | 2.85517308 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 158 | 1.46e-42 | NR | XOR25286.1 | 2832643 | g26748 | i0 | 87.9 | 0.989130434782609 | 91 | 11 | 98.9 | 0 | 2 | 274 | 450 | 540 | XOR25286.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 273 | 158 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29663927 | 29663927 | PRJNA376117_P_NODE_20430_length_306_cov_1.111588_g20128_i0 | PRJNA376117 | 20430 | 306 | 1.111588 | 3.40145928 | Synechococcus phage S-H35 | 1983572 | Viruses | Viruses | 42 | 0.0156 | NR | YP_010090281.1 | 1983572 | g20128 | i0 | 27.4 | 0.607843137254902 | 62 | 45 | 60.8 | 0 | 86 | 271 | 1 | 62 | YP_010090281.1 hypothetical protein KNT63_gp014 [Synechococcus phage S-H35] | diamond | 186 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Shandvirus | Shandvirus sh35 | ||
| 31022806 | 31022806 | PRJNA376117_P_NODE_33275_length_252_cov_2.016760_g32973_i0 | PRJNA376117 | 33275 | 252 | 2.01676 | 5.0822352 | Pseudomonas phage MR4 | 2711171 | Viruses | Viruses | 71.2 | 2.46e-13 | NR | QJD54730.1 | 2711171 | g32973 | i0 | 68 | 0.595238095238095 | 50 | 16 | 59.5 | 0 | 251 | 102 | 102 | 151 | QJD54730.1 putative GNAT family acetyltransferase protein [Pseudomonas phage MR4] | diamond | 150 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Gajwadongvirus | Gajwadongvirus MR4 | |||
| 32288216 | 32288216 | PRJNA376117_P_NODE_25679_length_280_cov_1.545894_g25377_i0 | PRJNA376117 | 25679 | 280 | 1.545894 | 4.3285032 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99 | 8.7e-22 | NR | XOR74384.1 | 2832643 | g25377 | i0 | 60 | 1.77857142857143 | 75 | 30 | 80.4 | 0 | 278 | 54 | 442 | 516 | XOR74384.1 MAG: virion structural protein [Caudoviricetes sp.] | diamond | 498 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32855921 | 32855921 | PRJNA376117_P_NODE_40720_length_244_cov_2.403509_g40418_i0 | PRJNA376117 | 40720 | 244 | 2.403509 | 5.86456196 | Pectobacterium phage vB_PcaM_CBB | 2772511 | Viruses | Viruses | 63.9 | 7.36e-10 | NR | YP_009594642.1 | 2772511 | g40418 | i0 | 62.2 | 0.55327868852459 | 45 | 17 | 55.3 | 0 | 232 | 98 | 200 | 244 | YP_009594642.1 metallo-phosphoesterase [Pectobacterium phage vB_PcaM_CBB] | diamond | 135 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Mimasvirus CBB |
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);;