contig_metadata
3 rows where bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5663829 | 5663829 | PRJNA575566_P_NODE_24645_length_208_cov_1.564626_g24448_i0 | PRJNA575566 | 24645 | 208 | 1.564626 | 3.25442208 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 351 | 1.6e-92 | NTclustered | gi|2914973772|gb|OR222059.1| | 2832643 | g24448 | i0 | 97.115 | 99.9903846153846 | 208 | 6 | 100 | 0 | 1 | 208 | 141788 | 141581 | MAG: Caudoviricetes sp. isolate MSP0056 genomic sequence | blastn | 20798 | 351 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12039053 | 12039053 | PRJNA575566_P_NODE_15950_length_264_cov_1.261084_g15753_i0 | PRJNA575566 | 15950 | 264 | 1.261084 | 3.32926176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 466 | 7.27e-127 | NTclustered | gi|2915007431|gb|OR222405.1| | 2832643 | g15753 | i0 | 98.485 | 1 | 264 | 4 | 100 | 0 | 1 | 264 | 25391 | 25128 | MAG: Caudoviricetes sp. isolate MSP0990 genomic sequence | blastn | 264 | 466 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14589075 | 14589075 | PRJNA575566_P_NODE_5652_length_441_cov_2.223684_g5455_i0 | PRJNA575566 | 5652 | 441 | 2.223684 | 9.80644644 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2906153688|gb|PQ646746.1| | 2832643 | g5455 | i0 | 94.444 | 0.0816326530612245 | 36 | 2 | 8 | 0 | 134 | 169 | 27949 | 27914 | MAG: Caudoviricetes sp. isolate k127_1959817 genomic sequence | blastn | 36 | 56.5 | 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);;