contig_metadata
28 rows where bioproject = "PRJNA390533" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1684481 | 1684481 | PRJNA390533_P_NODE_20822_length_372_cov_1.957958_g19798_i0 | PRJNA390533 | 20822 | 372 | 1.957958 | 7.28360376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 3.139999999999999e-87 | NTclustered | gi|2914933639|gb|OR221620.1| | 2832643 | g19798 | i0 | 92.704 | 3.50268817204301 | 233 | 16 | 62 | 1 | 1 | 232 | 29979 | 30211 | MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence | blastn | 1303 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1684767 | 1684767 | PRJNA390533_P_NODE_48182_length_155_cov_1.232759_g47155_i0 | PRJNA390533 | 48182 | 155 | 1.232759 | 1.91077645 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 159 | 7.3e-35 | NTclustered | gi|2915010997|gb|OR222458.1| | 2832643 | g47155 | i0 | 87.143 | 0.903225806451613 | 140 | 18 | 90 | 0 | 16 | 155 | 34585 | 34724 | MAG: Caudoviricetes sp. isolate MSP0931 genomic sequence | blastn | 140 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4236793 | 4236793 | PRJNA390533_P_NODE_30404_length_248_cov_2.540670_g29377_i0 | PRJNA390533 | 30404 | 248 | 2.54067 | 6.3008616 | Pseudomonas phage UFJF_PfPro | 3384676 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2865722204|gb|PQ412991.1| | 3384676 | g29377 | i0 | 100 | 18.25 | 248 | 0 | 100 | 0 | 1 | 248 | 9187 | 8940 | Pseudomonas phage UFJF_PfPro, complete genome | blastn | 4526 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Pseudomonas phage UFJF_PfPro | ||||
| 6181192 | 6181192 | PRJNA390533_P_NODE_40225_length_179_cov_7.257143_g39198_i0 | PRJNA390533 | 40225 | 179 | 7.257143 | 12.99028597 | root | 1 | Root_unresolved | Root_unresolved | 331 | 1.74e-86 | NTclustered | gi|2627592510|gb|OQ077661.1| | 10298 | g39198 | i0 | 100 | 81.4357541899441 | 179 | 0 | 100 | 0 | 1 | 179 | 59461 | 59283 | Mutant Human alphaherpesvirus 1 clone H129-Syn-G2, complete sequence | blastn | 14577 | 331 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 6787396 | 6787396 | PRJNA390533_P_NODE_25926_length_309_cov_1.770370_g24899_i0 | PRJNA390533 | 25926 | 309 | 1.77037 | 5.4704433 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 372 | 1.95e-98 | NTclustered | gi|2054478271|tpg|BK031892.1| | 2832643 | g24899 | i0 | 88.387 | 1.89644012944984 | 310 | 34 | 100 | 2 | 1 | 309 | 9094 | 9402 | MAG TPA_asm: Caudoviricetes sp. isolate ctCd92, partial genome | blastn | 586 | 372 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10613478 | 10613478 | PRJNA390533_P_NODE_269_length_2240_cov_11.541118_g210_i0 | PRJNA390533 | 269 | 2240 | 11.541118 | 258.5210432 | Pseudomonas phage VW-6S | 2041487 | Viruses | Viruses | 3725 | 0 | NTclustered | gi|1269168330|gb|MF975720.1| | 2041487 | g210 | i0 | 96.979 | 52.8370535714286 | 2218 | 67 | 99 | 0 | 23 | 2240 | 34592 | 36809 | Pseudomonas phage VW-6S, complete genome | blastn | 118355 | 3725 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage VW-6S | |||||
| 10613751 | 10613751 | PRJNA390533_P_NODE_7389_length_724_cov_2.429197_g6639_i0 | PRJNA390533 | 7389 | 724 | 2.429197 | 17.58738628 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 625 | 3.3999999999999998e-174 | NTclustered | gi|2915041439|gb|OR222744.1| | 2832643 | g6639 | i0 | 90.486 | 1.96132596685083 | 473 | 45 | 65 | 0 | 252 | 724 | 12250 | 11778 | MAG: Caudoviricetes sp. isolate MSP0616 genomic sequence | blastn | 1420 | 625 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11888562 | 11888562 | PRJNA390533_P_NODE_35610_length_204_cov_1.672727_g34583_i0 | PRJNA390533 | 35610 | 204 | 1.672727 | 3.41236308 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 224 | 3.5599999999999996e-54 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g34583 | i0 | 87.31 | 301.612745098039 | 197 | 23 | 96 | 2 | 1 | 196 | 17922 | 18117 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 61529 | 224 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11888680 | 11888680 | PRJNA390533_P_NODE_49530_length_152_cov_1.088496_g48503_i0 | PRJNA390533 | 49530 | 152 | 1.088496 | 1.65451392 | Pseudomonas phage UFJF_PfPro | 3384676 | Viruses | Viruses | 281 | 1.46e-71 | NTclustered | gi|2865722204|gb|PQ412991.1| | 3384676 | g48503 | i0 | 100 | 4 | 152 | 0 | 100 | 0 | 1 | 152 | 9415 | 9264 | Pseudomonas phage UFJF_PfPro, complete genome | blastn | 608 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Pseudomonas phage UFJF_PfPro | ||||
| 11888751 | 11888751 | PRJNA390533_P_NODE_8370_length_679_cov_4.070312_g7580_i0 | PRJNA390533 | 8370 | 679 | 4.070312 | 27.63741848 | Psychrobacter phage D'Alembert | 2891959 | Viruses | Viruses | 150 | 4.72e-40 | NR | CAH1193240.1 | 2891959 | g7580 | i0 | 49.3 | 3.27835051546392 | 150 | 73 | 66.3 | 1 | 655 | 206 | 1 | 147 | CAH1193240.1 XkdK-like protein [Psychrobacter phage D'Alembert] | diamond | 2226 | 150 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Psychrobacter phage D'Alembert | |||||
| 13163242 | 13163242 | PRJNA390533_P_NODE_13091_length_529_cov_1.938776_g12131_i0 | PRJNA390533 | 13091 | 529 | 1.938776 | 10.25612504 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 257 | 1.02e-63 | NTclustered | gi|2914944565|gb|OR221797.1| | 2832643 | g12131 | i0 | 93.182 | 1.13421550094518 | 176 | 10 | 33 | 1 | 336 | 509 | 21561 | 21386 | MAG: Caudoviricetes sp. isolate MSP1221 genomic sequence | blastn | 600 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13163602 | 13163602 | PRJNA390533_P_NODE_44611_length_164_cov_1.296000_g43584_i0 | PRJNA390533 | 44611 | 164 | 1.296 | 2.12544 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 202 | 1.28e-47 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g43584 | i0 | 93.382 | 0.829268292682927 | 136 | 9 | 83 | 0 | 1 | 136 | 38149 | 38014 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 136 | 202 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15712509 | 15712509 | PRJNA390533_P_NODE_41653_length_174_cov_1.429630_g40626_i0 | PRJNA390533 | 41653 | 174 | 1.42963 | 2.4875562 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 287 | 3.69e-73 | NTclustered | gi|2054478271|tpg|BK031892.1| | 2832643 | g40626 | i0 | 100 | 1.7816091954023 | 155 | 0 | 89 | 0 | 1 | 155 | 7277 | 7123 | MAG TPA_asm: Caudoviricetes sp. isolate ctCd92, partial genome | blastn | 310 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22086070 | 22086070 | PRJNA390533_P_NODE_23078_length_339_cov_1.983333_g22054_i0 | PRJNA390533 | 23078 | 339 | 1.983333 | 6.72349887 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 206 | 2.3199999999999997e-48 | NTclustered | gi|2914944268|gb|OR221794.1| | 2832643 | g22054 | i0 | 99.123 | 0.336283185840708 | 114 | 1 | 34 | 0 | 7 | 120 | 11817 | 11704 | MAG: Caudoviricetes sp. isolate MSP1228 genomic sequence | blastn | 114 | 206 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22086199 | 22086199 | PRJNA390533_P_NODE_34458_length_212_cov_1.884393_g33431_i0 | PRJNA390533 | 34458 | 212 | 1.884393 | 3.99491316 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1e-79 | NTclustered | gi|2914779034|gb|OR222246.1| | 2832643 | g33431 | i0 | 95.361 | 0.915094339622642 | 194 | 9 | 92 | 0 | 1 | 194 | 1768 | 1575 | MAG: Caudoviricetes sp. isolate MSP0721 genomic sequence | blastn | 194 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22086432 | 22086432 | PRJNA390533_P_NODE_9218_length_647_cov_1.475329_g8377_i0 | PRJNA390533 | 9218 | 647 | 1.475329 | 9.54537863 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 617 | 5.059999999999999e-172 | NTclustered | gi|2914750661|gb|OR221280.1| | 2832643 | g8377 | i0 | 91.518 | 0.91499227202473 | 448 | 38 | 91 | 0 | 178 | 625 | 35390 | 34943 | MAG: Caudoviricetes sp. isolate MSP1831 genomic sequence | blastn | 592 | 617 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23361977 | 23361977 | PRJNA390533_P_NODE_46399_length_159_cov_1.708333_g45372_i0 | PRJNA390533 | 46399 | 159 | 1.708333 | 2.71624947 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 278 | 2e-70 | NTclustered | gi|2060029373|tpg|BK027294.1| | 2832643 | g45372 | i0 | 98.113 | 1 | 159 | 3 | 100 | 0 | 1 | 159 | 17215 | 17373 | MAG TPA_asm: Caudoviricetes sp. isolate ctjyb5, partial genome | blastn | 159 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24636039 | 24636039 | PRJNA390533_P_NODE_2280_length_1173_cov_2.485009_g1924_i0 | PRJNA390533 | 2280 | 1173 | 2.485009 | 29.14915557 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1688 | 0 | NTclustered | gi|2053214783|tpg|BK017231.1| | 2832643 | g1924 | i0 | 99.251 | 2.70417732310315 | 935 | 7 | 80 | 0 | 1 | 935 | 19124 | 20058 | MAG TPA_asm: Caudoviricetes sp. isolate ctWXE1, partial genome | blastn | 3172 | 1688 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27739021 | 27739021 | PRJNA390533_P_NODE_36344_length_199_cov_2.543750_g35317_i0 | PRJNA390533 | 36344 | 199 | 2.54375 | 5.0620625 | Microbacterium phage Count | 2182352 | Viruses | Viruses | 47.8 | 3.34e-4 | NR | AWN03372.1 | 2182352 | g35317 | i0 | 51.3 | 0.587939698492462 | 39 | 19 | 58.8 | 0 | 197 | 81 | 148 | 186 | AWN03372.1 hypothetical protein PBI_COUNT_49 [Microbacterium phage Count] | diamond | 117 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Count | |||||
| 29727525 | 29727525 | PRJNA390533_P_NODE_12510_length_544_cov_5.182178_g11568_i0 | PRJNA390533 | 12510 | 544 | 5.182178 | 28.19104832 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 136 | 2.5e-37 | NR | AXF51898.1 | 2832643 | g11568 | i0 | 56.7 | 0.661764705882353 | 120 | 51 | 66.2 | 1 | 173 | 532 | 4 | 122 | AXF51898.1 MAG: NADH dehydrogenase subunit C [Caudoviricetes sp.] | diamond | 360 | 136 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30865072 | 30865072 | PRJNA390533_P_NODE_2194_length_1186_cov_9.176112_g1855_i0 | PRJNA390533 | 2194 | 1186 | 9.176112 | 108.82868832 | Acinetobacter phage MD-2 | 2865959 | Viruses | Viruses | 236 | 7.55e-72 | NR | CAH1066774.1 | 2899278 | g1855 | i0 | 62.4 | 0.430016863406408 | 170 | 64 | 43 | 0 | 1174 | 665 | 93 | 262 | CAH1066774.1 Uncharacterised protein [Acinetobacter phage MD-2021a] | diamond | 510 | 236 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage MD-2021a | |||||
| 31718799 | 31718799 | PRJNA390533_P_NODE_25537_length_315_cov_1.478261_g24510_i0 | PRJNA390533 | 25537 | 315 | 1.478261 | 4.65652215 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.2 | 9.58e-11 | NR | XOS41782.1 | 2832643 | g24510 | i0 | 45.6 | 0.542857142857143 | 57 | 31 | 54.3 | 0 | 16 | 186 | 1 | 57 | XOS41782.1 MAG: hypothetical protein MSP0993_51 [Caudoviricetes sp.] | diamond | 171 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32146965 | 32146965 | PRJNA390533_P_NODE_40118_length_180_cov_1.638298_g39091_i0 | PRJNA390533 | 40118 | 180 | 1.638298 | 2.9489364 | root | 1 | Root_unresolved | Root_unresolved | 73.2 | 7.49e-14 | NR | YP_009603591.1 | 1175654 | g39091 | i0 | 58.9 | 2.85 | 56 | 21 | 93.3 | 1 | 169 | 2 | 155 | 208 | YP_009603591.1 QueE-like radical SAM domain [Pseudomonas phage PaMx25] | diamond | 513 | 73.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Nipunavirus | Nipunavirus PaMx25 | ||||
| 32193412 | 32193412 | PRJNA390533_P_NODE_28858_length_266_cov_1.136564_g27831_i0 | PRJNA390533 | 28858 | 266 | 1.136564 | 3.02326024 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 151 | 3.3599999999999992e-43 | NR | XOQ93795.1 | 2832643 | g27831 | i0 | 83 | 0.992481203007519 | 88 | 15 | 99.2 | 0 | 3 | 266 | 22 | 109 | XOQ93795.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 264 | 151 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32414965 | 32414965 | PRJNA390533_P_NODE_31299_length_238_cov_3.542714_g30272_i0 | PRJNA390533 | 31299 | 238 | 3.542714 | 8.43165932 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47 | 8.91e-5 | NR | DAR72918.1 | 2832643 | g30272 | i0 | 57.8 | 0.567226890756303 | 45 | 18 | 55.5 | 1 | 84 | 215 | 14 | 58 | DAR72918.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 135 | 47 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32414975 | 32414975 | PRJNA390533_P_NODE_46219_length_160_cov_1.000000_g45192_i0 | PRJNA390533 | 46219 | 160 | 1 | 1.6 | Pseudanabaena phage Pan4 | 2981587 | Viruses | Viruses | 95.5 | 8.14e-22 | NR | UXO94023.1 | 2981587 | g45192 | i0 | 81.5 | 3.0375 | 54 | 9 | 99.4 | 1 | 160 | 2 | 153 | 206 | UXO94023.1 DNA methylase [Pseudanabaena phage Pan4] | diamond | 486 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudanabaena phage Pan4 | |||||
| 32510031 | 32510031 | PRJNA390533_P_NODE_1959_length_1236_cov_7.183793_g1653_i0 | PRJNA390533 | 1959 | 1236 | 7.183793 | 88.79168148 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 130 | 7.23e-33 | NR | XOR18952.1 | 2832643 | g1653 | i0 | 64.5 | 0.533980582524272 | 110 | 36 | 26.2 | 2 | 568 | 245 | 1 | 109 | XOR18952.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 660 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32541651 | 32541651 | PRJNA390533_P_NODE_12199_length_554_cov_1.933981_g11261_i0 | PRJNA390533 | 12199 | 554 | 1.933981 | 10.71425474 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94 | 1.34e-18 | NR | XOQ91086.1 | 2832643 | g11261 | i0 | 41.4 | 0.693140794223827 | 128 | 73 | 68.8 | 2 | 21 | 401 | 445 | 571 | XOQ91086.1 MAG: pre-neck appendage [Caudoviricetes sp.] | diamond | 384 | 94 | 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);;