contig_metadata
16 rows where bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5315978 | 5315978 | PRJNA1108009_P_NODE_26185_length_249_cov_0.875000_g25867_i0 | PRJNA1108009 | 26185 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 213 | 9.77e-51 | NTclustered | gi|2054476463|tpg|BK031853.1| | 2832643 | g25867 | i0 | 82.329 | 2.54618473895582 | 249 | 40 | 98 | 3 | 1 | 245 | 7888 | 8136 | MAG TPA_asm: Caudoviricetes sp. isolate ct5fQ2, partial genome | blastn | 634 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9140746 | 9140746 | PRJNA1108009_P_NODE_28328_length_246_cov_0.890173_g28010_i0 | PRJNA1108009 | 28328 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 7.19e-77 | NTclustered | gi|2054620537|tpg|BK022110.1| | 2832643 | g28010 | i0 | 88.889 | 5.89430894308943 | 243 | 27 | 99 | 0 | 4 | 246 | 34458 | 34700 | MAG TPA_asm: Caudoviricetes sp. isolate ct2qM1, partial genome | blastn | 1450 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10416635 | 10416635 | PRJNA1108009_P_NODE_31669_length_241_cov_0.916667_g31351_i0 | PRJNA1108009 | 31669 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.5 | 9.95e-11 | NTclustered | gi|2914880774|gb|OR222049.1| | 2832643 | g31351 | i0 | 86.301 | 0.302904564315353 | 73 | 10 | 30 | 0 | 1 | 73 | 133080 | 133152 | MAG: Caudoviricetes sp. isolate MSP0066 genomic sequence | blastn | 73 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11691890 | 11691890 | PRJNA1108009_P_NODE_31510_length_241_cov_0.916667_g31192_i0 | PRJNA1108009 | 31510 | 241 | 0.916667 | 2.20916747 | Siphoviridae sp. ctBLh2 | 2827803 | Viruses | Viruses | 252 | 1.99e-62 | NTclustered | gi|2052864000|tpg|BK032514.1| | 2827803 | g31192 | i0 | 85.477 | 7.72614107883817 | 241 | 35 | 100 | 0 | 1 | 241 | 37810 | 37570 | MAG TPA_asm: Siphoviridae sp. ctBLh2, partial genome | blastn | 1862 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctBLh2 | |||||
| 15515782 | 15515782 | PRJNA1108009_P_NODE_30453_length_243_cov_0.905882_g30135_i0 | PRJNA1108009 | 30453 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.53e-73 | NTclustered | gi|2059589935|tpg|BK036862.1| | 2832643 | g30135 | i0 | 88.066 | 1.69958847736626 | 243 | 29 | 100 | 0 | 1 | 243 | 5547 | 5305 | MAG TPA_asm: Caudoviricetes sp. isolate ctBFi11, partial genome | blastn | 413 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16790043 | 16790043 | PRJNA1108009_P_NODE_19814_length_289_cov_1.092593_g19496_i0 | PRJNA1108009 | 19814 | 289 | 1.092593 | 3.15759377 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 368 | 2.34e-97 | NTclustered | gi|2052890717|tpg|BK017484.1| | 2832643 | g19496 | i0 | 89.619 | 10.7923875432526 | 289 | 30 | 100 | 0 | 1 | 289 | 43436 | 43148 | MAG TPA_asm: Caudoviricetes sp. isolate ctvwP2, partial genome | blastn | 3119 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18064763 | 18064763 | PRJNA1108009_P_NODE_27635_length_247_cov_0.885057_g27317_i0 | PRJNA1108009 | 27635 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 268 | 2.04e-67 | NTclustered | gi|2057135438|tpg|BK058212.1| | 2832643 | g27317 | i0 | 86.29 | 1.00404858299595 | 248 | 32 | 100 | 2 | 1 | 247 | 147 | 393 | MAG TPA_asm: Caudoviricetes sp. isolate ctGMM1, partial genome | blastn | 248 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27320680 | 27320680 | PRJNA1108009_P_NODE_30563_length_243_cov_0.905882_g30245_i0 | PRJNA1108009 | 30563 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.9 | 2.21e-4 | NR | DAH37247.1 | 2832643 | g30245 | i0 | 57.1 | 0.432098765432099 | 35 | 15 | 43.2 | 0 | 8 | 112 | 250 | 284 | DAH37247.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 105 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27920470 | 27920470 | PRJNA1108009_P_NODE_28145_length_246_cov_0.890173_g27827_i0 | PRJNA1108009 | 28145 | 246 | 0.890173 | 2.18982558 | Butyrivibrio virus Bo-Finn | 2696358 | Viruses | Viruses | 98.2 | 1.17e-21 | NR | QHJ73677.1 | 2696358 | g27827 | i0 | 78.3 | 0.731707317073171 | 60 | 13 | 73.2 | 0 | 181 | 2 | 1 | 60 | QHJ73677.1 tape measure protein [Butyrivibrio virus Bo-Finn] | diamond | 180 | 98.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Butyrivibrio virus Bo-Finn | |||||
| 29088860 | 29088860 | PRJNA1108009_P_NODE_25248_length_250_cov_1.542373_g24930_i0 | PRJNA1108009 | 25248 | 250 | 1.542373 | 3.8559325 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 43.9 | 0.0115 | NR | QBH85162.1 | 10310 | g24930 | i0 | 37.2 | 1.488 | 78 | 44 | 91.2 | 3 | 11 | 238 | 90 | 164 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 372 | 43.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 29941501 | 29941501 | PRJNA1108009_P_NODE_24331_length_253_cov_1.405556_g24013_i0 | PRJNA1108009 | 24331 | 253 | 1.405556 | 3.55605668 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57 | 4.04e-7 | NR | DAI55429.1 | 2832643 | g24013 | i0 | 41.8 | 2.01581027667984 | 91 | 39 | 91.3 | 2 | 8 | 238 | 654 | 744 | DAI55429.1 MAG TPA: Portal protein [Caudoviricetes sp.] | diamond | 510 | 57 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30289265 | 30289265 | PRJNA1108009_P_NODE_29172_length_245_cov_0.895349_g28854_i0 | PRJNA1108009 | 29172 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57.4 | 2.72e-7 | NR | DAH56770.1 | 2832643 | g28854 | i0 | 43.8 | 0.979591836734694 | 80 | 43 | 98 | 2 | 245 | 6 | 3107 | 3184 | DAH56770.1 MAG TPA: nuclease [Caudoviricetes sp.] | diamond | 240 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30699511 | 30699511 | PRJNA1108009_P_NODE_27774_length_247_cov_0.885057_g27456_i0 | PRJNA1108009 | 27774 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.1 | 0.0109 | NR | DAI99246.1 | 2832643 | g27456 | i0 | 60.7 | 0.340080971659919 | 28 | 10 | 32.8 | 1 | 246 | 166 | 57 | 84 | DAI99246.1 MAG TPA: putative cytoplasmic protein [Caudoviricetes sp.] | diamond | 84 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30762901 | 30762901 | PRJNA1108009_P_NODE_20814_length_281_cov_1.447115_g20496_i0 | PRJNA1108009 | 20814 | 281 | 1.447115 | 4.06639315 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.5 | 0.0318 | NR | DAN37732.1 | 2832643 | g20496 | i0 | 77.3 | 0.234875444839858 | 22 | 5 | 23.5 | 0 | 1 | 66 | 813 | 834 | DAN37732.1 MAG TPA: DNA directed RNA polymerase [Caudoviricetes sp.] | diamond | 66 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30984138 | 30984138 | PRJNA1108009_P_NODE_23854_length_257_cov_0.836957_g23536_i0 | PRJNA1108009 | 23854 | 257 | 0.836957 | 2.15097949 | Aeromonas phage avDM6 | 3101602 | Viruses | Viruses | 40 | 0.0453 | NR | UYD59232.1 | 3101602 | g23536 | i0 | 38.1 | 0.490272373540856 | 42 | 25 | 49 | 1 | 103 | 228 | 7 | 47 | UYD59232.1 hypothetical protein HPMBJEAJ_00117 [Aeromonas phage avDM6] | diamond | 126 | 40 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Ishigurovirus | Aeromonas phage avDM6 | ||
| 31110166 | 31110166 | PRJNA1108009_P_NODE_20195_length_286_cov_1.211268_g19877_i0 | PRJNA1108009 | 20195 | 286 | 1.211268 | 3.46422648 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.9 | 2.22e-9 | NR | DAH99580.1 | 2832643 | g19877 | i0 | 79.4 | 0.356643356643357 | 34 | 7 | 35.7 | 0 | 103 | 2 | 1 | 34 | DAH99580.1 MAG TPA: portal protein [Caudoviricetes sp.] | diamond | 102 | 63.9 | 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);;