contig_metadata
17 rows where analysis = "blastn", 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 | ||||
| 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. |
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);;