contig_metadata
9 rows where bioproject = "PRJEB81171" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 996645 | 996645 | PRJEB81171_P_NODE_7801_length_252_cov_1.385475_g7674_i0 | PRJEB81171 | 7801 | 252 | 1.385475 | 3.491397 | Jamesmcgillvirus | 2948768 | Viruses | Viruses | 449 | 6.94e-122 | NTclustered | gi|48697070|ref|NC_005884.1| | 270673 | g7674 | i0 | 98.81 | 7.36111111111111 | 252 | 3 | 100 | 0 | 1 | 252 | 38307 | 38558 | Pseudomonas phage PaP2, complete genome | blastn | 1855 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fredfastierviridae | Jamesmcgillvirus | Pseudomonas phage PaP2 | |||
| 1414107 | 1414107 | PRJEB81171_P_NODE_9362_length_245_cov_0.906977_g9235_i0 | PRJEB81171 | 9362 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.19e-79 | NTclustered | gi|2060040681|tpg|BK027668.1| | 2832643 | g9235 | i0 | 89.388 | 2 | 245 | 26 | 100 | 0 | 1 | 245 | 26151 | 26395 | MAG TPA_asm: Caudoviricetes sp. isolate ct6vn6, partial genome | blastn | 490 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6517689 | 6517689 | PRJEB81171_P_NODE_9746_length_243_cov_0.917647_g9619_i0 | PRJEB81171 | 9746 | 243 | 0.917647 | 2.22988221 | Pormufvirus salinum | 3431827 | Viruses | Viruses | 261 | 3.34e-65 | NTclustered | gi|2231638396|ref|NC_062761.1| | 2878009 | g9619 | i0 | 86.008 | 1 | 243 | 34 | 100 | 0 | 1 | 243 | 20733 | 20491 | Halorubrum virus HRTV-28, complete genome | blastn | 243 | 261 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Suolaviridae | Pormufvirus | Pormufvirus salinum | |||
| 7791766 | 7791766 | PRJEB81171_P_NODE_9067_length_246_cov_0.901734_g8940_i0 | PRJEB81171 | 9067 | 246 | 0.901734 | 2.21826564 | Bacillus phage vB_BpuM-ZY1 | 3096073 | Viruses | Viruses | 303 | 5.56e-78 | NTclustered | gi|2622943848|gb|OR820920.1| | 3096073 | g8940 | i0 | 89.256 | 0.983739837398374 | 242 | 26 | 98 | 0 | 3 | 244 | 36791 | 37032 | Bacillus phage vB_BpuM-ZY1, complete genome | blastn | 242 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Bacillus phage vB_BpuM-ZY1 | ||||
| 16716156 | 16716156 | PRJEB81171_P_NODE_5254_length_291_cov_1.146789_g5127_i0 | PRJEB81171 | 5254 | 291 | 1.146789 | 3.33715599 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.3699999999999994e-119 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g5127 | i0 | 94.425 | 1.96219931271478 | 287 | 16 | 99 | 0 | 2 | 288 | 11652 | 11938 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 571 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28448365 | 28448365 | PRJEB81171_P_NODE_7166_length_260_cov_1.668449_g7039_i0 | PRJEB81171 | 7166 | 260 | 1.668449 | 4.3379674 | Viruses | 10239 | Viruses | Viruses | 54.7 | 5.95e-7 | NR | YP_006560771.1 | 1132026 | g7039 | i0 | 48.1 | 1.26923076923077 | 54 | 25 | 58.8 | 1 | 218 | 66 | 21 | 74 | YP_006560771.1 tail completion or Neck1 protein [Burkholderia phage vB_BceS_KL1] | diamond | 330 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kilunavirus | Kilunavirus KL1 | ||||
| 29560389 | 29560389 | PRJEB81171_P_NODE_5710_length_283_cov_1.485714_g5583_i0 | PRJEB81171 | 5710 | 283 | 1.485714 | 4.20457062 | Rhodococcus phage Finch | 2094144 | Viruses | Viruses | 153 | 4.02e-41 | NR | YP_010059023.1 | 2094144 | g5583 | i0 | 71.3 | 0.996466431095406 | 94 | 27 | 99.6 | 0 | 2 | 283 | 439 | 532 | YP_010059023.1 terminase [Rhodococcus phage Finch] | diamond | 282 | 153 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Finchvirus | Finchvirus finch | ||||
| 32088978 | 32088978 | PRJEB81171_P_NODE_9318_length_245_cov_0.906977_g9191_i0 | PRJEB81171 | 9318 | 245 | 0.906977 | 2.22209365 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.9 | 4.51e-12 | NR | CAB4170702.1 | 2100421 | g9191 | i0 | 81.1 | 0.906122448979592 | 37 | 7 | 45.3 | 0 | 111 | 1 | 1 | 37 | CAB4170702.1 major capsid protein [uncultured Caudovirales phage] | diamond | 222 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32088979 | 32088979 | PRJEB81171_P_NODE_9878_length_242_cov_1.781065_g9751_i0 | PRJEB81171 | 9878 | 242 | 1.781065 | 4.3101773 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 107 | 5.66e-26 | NR | XOR47457.1 | 2832643 | g9751 | i0 | 62 | 0.979338842975207 | 79 | 30 | 97.9 | 0 | 239 | 3 | 10 | 88 | XOR47457.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 237 | 107 | 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);;