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