contig_metadata
9 rows where bioproject = "PRJNA383995" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405293 | 405293 | PRJNA383995_P_NODE_5821_length_262_cov_0.957746_g5722_i0 | PRJNA383995 | 5821 | 262 | 0.957746 | 2.50929452 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 479 | 9.249999999999999e-131 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g5722 | i0 | 99.618 | 92.4083969465649 | 262 | 1 | 100 | 0 | 1 | 262 | 90628 | 90889 | Salmonella phage SP3, partial genome | blastn | 24211 | 479 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 405302 | 405302 | PRJNA383995_P_NODE_9941_length_207_cov_1.291139_g9842_i0 | PRJNA383995 | 9941 | 207 | 1.291139 | 2.67265773 | Salmonella phage SP1a | 2109652 | Viruses | Viruses | 383 | 5.65e-102 | NTclustered | gi|1251987296|gb|MF774690.1| | 2109652 | g9842 | i0 | 100 | 121.990338164251 | 207 | 0 | 100 | 0 | 1 | 207 | 1400 | 1194 | Salmonella phage SP1a clone contig.00004 genomic sequence, sequence | blastn | 25252 | 383 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Salmonella phage SP1a | |||
| 1680127 | 1680127 | PRJNA383995_P_NODE_8302_length_224_cov_1.165714_g8203_i0 | PRJNA383995 | 8302 | 224 | 1.165714 | 2.61119936 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 409 | 1.03e-109 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g8203 | i0 | 100 | 99.1964285714286 | 221 | 0 | 99 | 0 | 4 | 224 | 19950 | 19730 | Salmonella phage SP3, partial genome | blastn | 22220 | 409 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 2351201 | 2351201 | PRJNA383995_P_NODE_5242_length_275_cov_0.783186_g5143_i0 | PRJNA383995 | 5242 | 275 | 0.783186 | 2.1537615 | Tequintavirus | 187218 | Viruses | Viruses | 470 | 5.89e-128 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g5143 | i0 | 97.455 | 101.021818181818 | 275 | 7 | 100 | 0 | 1 | 275 | 18526 | 18252 | Salmonella phage SP3, partial genome | blastn | 27781 | 470 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 4232376 | 4232376 | PRJNA383995_P_NODE_10984_length_198_cov_1.026846_g10885_i0 | PRJNA383995 | 10984 | 198 | 1.026846 | 2.03315508 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.21e-68 | NTclustered | gi|2914935757|gb|OR221655.1| | 2832643 | g10885 | i0 | 91.457 | 3.01010101010101 | 199 | 15 | 100 | 2 | 1 | 198 | 15025 | 14828 | MAG: Caudoviricetes sp. isolate MSP1392 genomic sequence | blastn | 596 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8058563 | 8058563 | PRJNA383995_P_NODE_16747_length_165_cov_0.879310_g16648_i0 | PRJNA383995 | 16747 | 165 | 0.87931 | 1.4508615 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g16648 | i0 | 100 | 55.1272727272727 | 165 | 0 | 100 | 0 | 1 | 165 | 3408 | 3244 | Salmonella phage SP3, partial genome | blastn | 9096 | 305 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 13159001 | 13159001 | PRJNA383995_P_NODE_18391_length_162_cov_0.902655_g18292_i0 | PRJNA383995 | 18391 | 162 | 0.902655 | 1.4623011 | Shewanella phage FishSpeaker | 2985553 | Viruses | Viruses | 244 | 2.07e-60 | NTclustered | gi|2316690595|gb|OP589283.1| | 2985553 | g18292 | i0 | 93.827 | 1 | 162 | 10 | 100 | 0 | 1 | 162 | 33343 | 33182 | Shewanella phage FishSpeaker, complete genome | blastn | 162 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shewanella phage FishSpeaker | |||||
| 17653364 | 17653364 | PRJNA383995_P_NODE_11754_length_192_cov_1.055944_g11655_i0 | PRJNA383995 | 11754 | 192 | 1.055944 | 2.02741248 | Tequintavirus | 187218 | Viruses | Viruses | 339 | 1.13e-88 | NTclustered | gi|1779416030|emb|LR597659.1| | 2742946 | g11655 | i0 | 98.438 | 99.328125 | 192 | 3 | 100 | 0 | 1 | 192 | 70576 | 70767 | Escherichia phage T5_ev212 genome assembly, chromosome: 1 | blastn | 19071 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Escherichia phage T5_ev212 | |||
| 23357348 | 23357348 | PRJNA383995_P_NODE_9919_length_207_cov_1.613924_g9820_i0 | PRJNA383995 | 9919 | 207 | 1.613924 | 3.34082268 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 1.6099999999999997e-87 | NTclustered | gi|2914885844|gb|OR222395.1| | 2832643 | g9820 | i0 | 97.449 | 1.80193236714976 | 196 | 5 | 95 | 0 | 1 | 196 | 26484 | 26289 | MAG: Caudoviricetes sp. isolate MSP1008 genomic sequence | blastn | 373 | 335 | 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);;