contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3273375 | 3273375 | PRJNA743294_P_NODE_34243_length_287_cov_1.677570_g33787_i0 | PRJNA743294 | 34243 | 287 | 1.67757 | 4.8146259 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2058072134|tpg|BK042964.1| | 2832643 | g33787 | i0 | 96.774 | 0.10801393728223 | 31 | 1 | 11 | 0 | 127 | 157 | 8785 | 8815 | MAG TPA_asm: Caudoviricetes sp. isolate ct6Al7, partial genome | blastn | 31 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5026571 | 5026571 | PRJNA743294_P_NODE_35204_length_284_cov_1.203791_g34748_i0 | PRJNA743294 | 35204 | 284 | 1.203791 | 3.41876644 | Jamesmcgillvirus | 2948768 | Viruses | Viruses | 507 | 4.66e-139 | NTclustered | gi|48697070|ref|NC_005884.1| | 270673 | g34748 | i0 | 98.94 | 10.9683098591549 | 283 | 3 | 99 | 0 | 2 | 284 | 2803 | 3085 | Pseudomonas phage PaP2, complete genome | blastn | 3115 | 507 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fredfastierviridae | Jamesmcgillvirus | Pseudomonas phage PaP2 | |||
| 6302365 | 6302365 | PRJNA743294_P_NODE_45685_length_254_cov_1.685083_g45229_i0 | PRJNA743294 | 45685 | 254 | 1.685083 | 4.28011082 | Kayvirus | 1857843 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|1841992804|ref|NC_047723.1| | 1195077 | g45229 | i0 | 100 | 1.10236220472441 | 28 | 0 | 11 | 0 | 132 | 159 | 22783 | 22756 | Staphylococcus phage A3R, complete genome | blastn | 280 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Kayvirus | Kayvirus G1 | |||
| 7100571 | 7100571 | PRJNA743294_P_NODE_10706_length_484_cov_3.420925_g10250_i0 | PRJNA743294 | 10706 | 484 | 3.420925 | 16.557277 | Nairobivirus nv36 | 3430989 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1503528737|gb|MH884513.1| | 2419622 | g10250 | i0 | 100 | 0.597107438016529 | 29 | 0 | 6 | 0 | 181 | 209 | 21547 | 21575 | Bacillus phage vB_BpsS-36, complete genome | blastn | 289 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ehrlichviridae | Nairobivirus | Nairobivirus nv36 | |||
| 7100930 | 7100930 | PRJNA743294_P_NODE_58626_length_232_cov_2.113208_g58170_i0 | PRJNA743294 | 58626 | 232 | 2.113208 | 4.90264256 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2057837639|tpg|BK055660.1| | 2832643 | g58170 | i0 | 92.308 | 0.168103448275862 | 39 | 1 | 16 | 2 | 157 | 194 | 23089 | 23052 | MAG TPA_asm: Caudoviricetes sp. isolate ctdwb5, partial genome | blastn | 39 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16024567 | 16024567 | PRJNA743294_P_NODE_25573_length_326_cov_1.766798_g25117_i0 | PRJNA743294 | 25573 | 326 | 1.766798 | 5.75976148 | Metrivirus ME3 | 2560269 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|1631917922|ref|NC_041884.1| | 1837876 | g25117 | i0 | 100 | 0.0858895705521472 | 28 | 0 | 9 | 0 | 167 | 194 | 100728 | 100755 | Acinetobacter phage vB_AbaM_ME3, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 20324786 | 20324786 | PRJNA743294_P_NODE_47436_length_252_cov_0.871508_g46980_i0 | PRJNA743294 | 47436 | 252 | 0.871508 | 2.19620016 | Pahexavirus | 1982251 | Viruses | Viruses | 444 | 3.2299999999999996e-120 | NTclustered | gi|408905844|ref|NC_018849.1| | 1229788 | g46980 | i0 | 98.413 | 80.1150793650794 | 252 | 4 | 100 | 0 | 1 | 252 | 14991 | 14740 | Propionibacterium phage P105, complete genome | blastn | 20189 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P105 |
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);;