contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA760904" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5845789 | 5845789 | PRJNA760904_P_NODE_13065_length_263_cov_1.247368_g13008_i0 | PRJNA760904 | 13065 | 263 | 1.247368 | 3.28057784 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 5.96e-83 | NTclustered | gi|2915009995|gb|OR222441.1| | 2832643 | g13008 | i0 | 96.859 | 0.726235741444867 | 191 | 6 | 73 | 0 | 1 | 191 | 13465 | 13655 | MAG: Caudoviricetes sp. isolate MSP0950 genomic sequence | blastn | 191 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5845816 | 5845816 | PRJNA760904_P_NODE_18705_length_244_cov_0.900585_g18648_i0 | PRJNA760904 | 18705 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 274 | 4.31e-69 | NTclustered | gi|2915007560|gb|OR222406.1| | 2832643 | g18648 | i0 | 98.089 | 2.69262295081967 | 157 | 3 | 64 | 0 | 1 | 157 | 36056 | 36212 | MAG: Caudoviricetes sp. isolate MSP0991 genomic sequence | blastn | 657 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9670679 | 9670679 | PRJNA760904_P_NODE_19488_length_243_cov_0.905882_g19431_i0 | PRJNA760904 | 19488 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.53e-73 | NTclustered | gi|2915007560|gb|OR222406.1| | 2832643 | g19431 | i0 | 96.045 | 1.66666666666667 | 177 | 7 | 73 | 0 | 2 | 178 | 44451 | 44627 | MAG: Caudoviricetes sp. isolate MSP0991 genomic sequence | blastn | 405 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10946328 | 10946328 | PRJNA760904_P_NODE_15209_length_250_cov_0.870056_g15152_i0 | PRJNA760904 | 15209 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 8.949999999999998e-116 | NTclustered | gi|2054542014|tpg|BK047874.1| | 2832643 | g15152 | i0 | 97.6 | 2.94 | 250 | 6 | 100 | 0 | 1 | 250 | 22658 | 22907 | MAG TPA_asm: Caudoviricetes sp. isolate ctudM4, partial genome | blastn | 735 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12221901 | 12221901 | PRJNA760904_P_NODE_3470_length_443_cov_2.140541_g3413_i0 | PRJNA760904 | 3470 | 443 | 2.140541 | 9.48259663 | Theiavirus salishense | 3060737 | Viruses | Viruses | 110 | 2.51e-19 | NTclustered | gi|2500354595|ref|NC_075036.1| | 2024608 | g3413 | i0 | 82.787 | 0.386004514672686 | 122 | 21 | 28 | 0 | 321 | 442 | 72324 | 72203 | Bodo saltans virus strain NG1, complete genome | blastn | 171 | 110 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 16044879 | 16044879 | PRJNA760904_P_NODE_13293_length_261_cov_1.425532_g13236_i0 | PRJNA760904 | 13293 | 261 | 1.425532 | 3.72063852 | Propionibacterium phage PaP11-13 | 2951241 | Viruses | Viruses | 327 | 3.53e-85 | NTclustered | gi|2258688004|gb|ON557706.1| | 2951241 | g13236 | i0 | 89.615 | 88.0459770114943 | 260 | 24 | 99 | 1 | 2 | 261 | 13123 | 12867 | Propionibacterium phage PaP11-13, complete genome | blastn | 22980 | 327 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage PaP11-13 | ||||
| 17320504 | 17320504 | PRJNA760904_P_NODE_11654_length_274_cov_1.034826_g11597_i0 | PRJNA760904 | 11654 | 274 | 1.034826 | 2.83542324 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 9.88e-121 | NTclustered | gi|2914763246|gb|OR221877.1| | 2832643 | g11597 | i0 | 95.985 | 3.97445255474453 | 274 | 11 | 100 | 0 | 1 | 274 | 18064 | 18337 | MAG: Caudoviricetes sp. isolate MSP1125 genomic sequence | blastn | 1089 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18593951 | 18593951 | PRJNA760904_P_NODE_55_length_2194_cov_12.586044_g48_i0 | PRJNA760904 | 55 | 2194 | 12.586044 | 276.13780536 | Clandestinovirus | 2831644 | Viruses | Viruses | 431 | 2.49e-115 | NTclustered | gi|2072965616|gb|MZ420154.1| | 2831644 | g48 | i0 | 81.489 | 0.530993618960802 | 524 | 97 | 33 | 0 | 353 | 876 | 478873 | 478350 | Clandestinovirus isolate 347.936635, partial genome | blastn | 1165 | 431 | 1 | Viruses | Clandestinovirus | ||||||||
| 24968850 | 24968850 | PRJNA760904_P_NODE_19320_length_243_cov_0.905882_g19263_i0 | PRJNA760904 | 19320 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 1.1299999999999998e-109 | NTclustered | gi|2915033111|gb|OR222673.1| | 2832643 | g19263 | i0 | 97.89 | 98.880658436214 | 237 | 4 | 98 | 1 | 7 | 243 | 26360 | 26595 | MAG: Caudoviricetes sp. isolate MSP0260 genomic sequence | blastn | 24028 | 409 | 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);;