contig_metadata
13 rows where bioproject = "PRJNA1134759" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6661997 | 6661997 | PRJNA1134759_P_NODE_30866_length_303_cov_1.134783_g30690_i0 | PRJNA1134759 | 30866 | 303 | 1.134783 | 3.43839249 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 287 | 7.11e-73 | NTclustered | gi|2914832067|gb|OR222576.1| | 2832643 | g30690 | i0 | 97.605 | 0.815181518151815 | 167 | 4 | 81 | 0 | 59 | 225 | 87437 | 87603 | MAG: Caudoviricetes sp. isolate MSP0358 genomic sequence | blastn | 247 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6662071 | 6662071 | PRJNA1134759_P_NODE_52206_length_248_cov_0.891429_g52030_i0 | PRJNA1134759 | 52206 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 5.49e-93 | NTclustered | gi|2914889217|gb|OR222626.1| | 2832643 | g52030 | i0 | 92.339 | 4.00403225806452 | 248 | 19 | 100 | 0 | 1 | 248 | 52230 | 51983 | MAG: Caudoviricetes sp. isolate MSP0308 genomic sequence | blastn | 993 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14313146 | 14313146 | PRJNA1134759_P_NODE_55852_length_243_cov_0.917647_g55676_i0 | PRJNA1134759 | 55852 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g55676 | i0 | 99.588 | 1 | 243 | 1 | 100 | 0 | 1 | 243 | 39571 | 39813 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 243 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15059587 | 15059587 | PRJNA1134759_P_NODE_50932_length_249_cov_2.795455_g50756_i0 | PRJNA1134759 | 50932 | 249 | 2.795455 | 6.96068295 | Viruses | 10239 | Viruses | Viruses | 344 | 3.32e-90 | NTclustered | gi|670140887|gb|KJ936628.1| | 1524880 | g50756 | i0 | 91.566 | 9.01606425702811 | 249 | 21 | 100 | 0 | 1 | 249 | 42284 | 42036 | Vibrio phage VPp1, complete genome | blastn | 2245 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage VPp1 | |||||
| 16334306 | 16334306 | PRJNA1134759_P_NODE_31833_length_299_cov_1.548673_g31657_i0 | PRJNA1134759 | 31833 | 299 | 1.548673 | 4.63053227 | Viruses | 10239 | Viruses | Viruses | 252 | 2.55e-62 | NTclustered | gi|1227483992|gb|MF431726.1| | 2024229 | g31657 | i0 | 85.957 | 1.5752508361204 | 235 | 33 | 79 | 0 | 65 | 299 | 11983 | 11749 | Vibrio phage vB_ValP_IME271, complete genome | blastn | 471 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_ValP_IME271 | |||||
| 18135870 | 18135870 | PRJNA1134759_P_NODE_24415_length_333_cov_1.776923_g24239_i0 | PRJNA1134759 | 24415 | 333 | 1.776923 | 5.91715359 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 472 | 2.03e-128 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g24239 | i0 | 92.192 | 2 | 333 | 26 | 100 | 0 | 1 | 333 | 27532 | 27200 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 666 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26817371 | 26817371 | PRJNA1134759_P_NODE_56501_length_242_cov_0.923077_g56325_i0 | PRJNA1134759 | 56501 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 92.4 | 9.06e-22 | NR | XOR99885.1 | 2832643 | g56325 | i0 | 62.5 | 1.98347107438017 | 80 | 21 | 99.2 | 1 | 3 | 242 | 44 | 114 | XOR99885.1 MAG: conserved phage structural protein [Caudoviricetes sp.] | diamond | 480 | 92.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28428462 | 28428462 | PRJNA1134759_P_NODE_48346_length_253_cov_2.177778_g48170_i0 | PRJNA1134759 | 48346 | 253 | 2.177778 | 5.50977834 | Erwinia phage vB_EamM_Kwan | 1883374 | Viruses | Viruses | 94 | 4.04e-20 | NR | YP_009278885.1 | 1883374 | g48170 | i0 | 52.4 | 0.99604743083004 | 84 | 40 | 99.6 | 0 | 253 | 2 | 204 | 287 | YP_009278885.1 tail sheath [Erwinia phage vB_EamM_Kwan] | diamond | 252 | 94 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Wellingtonvirus | Wellingtonvirus wellington | |||
| 28933623 | 28933623 | PRJNA1134759_P_NODE_4568_length_697_cov_2.844551_g4413_i0 | PRJNA1134759 | 4568 | 697 | 2.844551 | 19.82652047 | Erwinia phage vB_EamM_ChrisDB | 1883371 | Viruses | Viruses | 174 | 3.83e-48 | NR | YP_009292758.1 | 1883371 | g4413 | i0 | 50 | 2.47489239598278 | 192 | 93 | 81.8 | 2 | 574 | 5 | 1 | 191 | YP_009292758.1 internal head protein [Erwinia phage vB_EamM_ChrisDB] | diamond | 1725 | 174 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Machinavirus | Erwinia phage vB_EamM_ChrisDB | |||
| 30007347 | 30007347 | PRJNA1134759_P_NODE_29271_length_309_cov_2.830508_g29095_i0 | PRJNA1134759 | 29271 | 309 | 2.830508 | 8.74626972 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.5 | 2.69e-8 | NR | XOS23766.1 | 2832643 | g29095 | i0 | 31.4 | 1.92233009708738 | 102 | 70 | 99 | 0 | 3 | 308 | 93 | 194 | XOS23766.1 MAG: hypothetical protein MSP0020_13 [Caudoviricetes sp.] | diamond | 594 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30575622 | 30575622 | PRJNA1134759_P_NODE_49773_length_251_cov_1.432584_g49597_i0 | PRJNA1134759 | 49773 | 251 | 1.432584 | 3.59578584 | Erwinia phage pEa_SNUABM_11 | 2859245 | Viruses | Viruses | 111 | 2.29e-26 | NR | QXO09710.1 | 2859245 | g49597 | i0 | 64.6 | 1.91235059760956 | 79 | 28 | 94.4 | 0 | 246 | 10 | 46 | 124 | QXO09710.1 hypothetical protein pEaSNUABM11_00286 [Erwinia phage pEa_SNUABM_11] | diamond | 480 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Wellingtonvirus | Erwinia phage pEa_SNUABM_11 | |||
| 31050129 | 31050129 | PRJNA1134759_P_NODE_54315_length_245_cov_0.906977_g54139_i0 | PRJNA1134759 | 54315 | 245 | 0.906977 | 2.22209365 | Microbacterium phage LeeroyJenkins | 2593338 | Viruses | Viruses | 61.6 | 2.96e-9 | NR | QDK01467.1 | 2593338 | g54139 | i0 | 57.4 | 1.2734693877551 | 47 | 20 | 57.6 | 0 | 168 | 28 | 6 | 52 | QDK01467.1 acetyltransferase [Microbacterium phage LeeroyJenkins] | diamond | 312 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage LeeroyJenkins | |||||
| 32410011 | 32410011 | PRJNA1134759_P_NODE_6339_length_603_cov_2.928302_g6170_i0 | PRJNA1134759 | 6339 | 603 | 2.928302 | 17.65766106 | Erwinia phage pEa_SNUABM_11 | 2859245 | Viruses | Viruses | 108 | 8.02e-24 | NR | QXO09483.1 | 2859245 | g6170 | i0 | 42.3 | 0.706467661691542 | 142 | 78 | 69.2 | 3 | 421 | 5 | 3 | 143 | QXO09483.1 hypothetical protein pEaSNUABM11_00059 [Erwinia phage pEa_SNUABM_11] | diamond | 426 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Wellingtonvirus | Erwinia phage pEa_SNUABM_11 |
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);;