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