contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA459724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1717909 | 1717909 | PRJNA459724_P_NODE_182_length_1303_cov_3.333595_g92_i0 | PRJNA459724 | 182 | 1303 | 3.333595 | 43.43674285 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 2.8e-18 | NTclustered | gi|2906143737|gb|PQ646059.1| | 2832643 | g92 | i0 | 96.875 | 0.0491174213353799 | 64 | 2 | 5 | 0 | 391 | 454 | 6798 | 6735 | MAG: Caudoviricetes sp. isolate k127_1709622 genomic sequence | blastn | 64 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1717927 | 1717927 | PRJNA459724_S_NODE_242_length_270_cov_15971.787234_g239_i0 | PRJNA459724 | 242 | 270 | 15971.787234 | 43123.8255318 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.33e-79 | NTclustered | gi|2059896131|tpg|BK041245.1| | 2832643 | g239 | i0 | 95.812 | 32.5962962962963 | 191 | 8 | 71 | 0 | 80 | 270 | 4534 | 4344 | MAG TPA_asm: Caudoviricetes sp. isolate ct0eg2, partial genome | blastn | 8801 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6197031 | 6197031 | PRJNA459724_P_NODE_2605_length_310_cov_3.320285_g2214_i0 | PRJNA459724 | 2605 | 310 | 3.320285 | 10.2928835 | Muminvirus | 2843426 | Viruses | Viruses | 302 | 2.6e-77 | NTclustered | gi|1859666402|ref|NC_048831.1| | 2686245 | g2214 | i0 | 86.063 | 9.69677419354839 | 287 | 32 | 91 | 7 | 24 | 306 | 5291 | 5009 | Flavobacterium phage vB_FspS_filifjonk9-1, complete genome | blastn | 3006 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Muminvirus | Muminvirus filifjonk | ||||
| 6820701 | 6820701 | PRJNA459724_P_NODE_3166_length_264_cov_1.970213_g2775_i0 | PRJNA459724 | 3166 | 264 | 1.970213 | 5.20136232 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 237 | 6.2e-58 | NTclustered | gi|2906151900|gb|PQ646623.1| | 2832643 | g2775 | i0 | 94.194 | 3.23863636363636 | 155 | 9 | 59 | 0 | 21 | 175 | 155 | 1 | MAG: Caudoviricetes sp. isolate k127_4103174 genomic sequence | blastn | 855 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6820707 | 6820707 | PRJNA459724_P_NODE_5126_length_175_cov_1.821918_g4734_i0 | PRJNA459724 | 5126 | 175 | 1.821918 | 3.1883565 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 2.38e-25 | NTclustered | gi|2906151900|gb|PQ646623.1| | 2832643 | g4734 | i0 | 92.222 | 0.514285714285714 | 90 | 7 | 51 | 0 | 86 | 175 | 842 | 753 | MAG: Caudoviricetes sp. isolate k127_4103174 genomic sequence | blastn | 90 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6820713 | 6820713 | PRJNA459724_S_NODE_106_length_321_cov_3.003497_g103_i0 | PRJNA459724 | 106 | 321 | 3.003497 | 9.64122537 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 549 | 8.759999999999997e-152 | NTclustered | gi|2914884942|gb|OR222361.1| | 2832643 | g103 | i0 | 98.397 | 5.84423676012461 | 312 | 5 | 97 | 0 | 6 | 317 | 23715 | 24026 | MAG: Caudoviricetes sp. isolate MSP1035 genomic sequence | blastn | 1876 | 549 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14471697 | 14471697 | PRJNA459724_P_NODE_3712_length_230_cov_2.398010_g3320_i0 | PRJNA459724 | 3712 | 230 | 2.39801 | 5.515423 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2914825358|gb|OR222259.1| | 2832643 | g3320 | i0 | 94.595 | 0.160869565217391 | 37 | 1 | 16 | 1 | 74 | 110 | 15892 | 15857 | MAG: Caudoviricetes sp. isolate MSP0705 genomic sequence | blastn | 37 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18294656 | 18294656 | PRJNA459724_P_NODE_1915_length_395_cov_1.953552_g1535_i0 | PRJNA459724 | 1915 | 395 | 1.953552 | 7.7165304 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 132 | 4.72e-26 | NTclustered | gi|2906143737|gb|PQ646059.1| | 2832643 | g1535 | i0 | 80.105 | 0.483544303797468 | 191 | 27 | 47 | 11 | 146 | 332 | 6810 | 6627 | MAG: Caudoviricetes sp. isolate k127_1709622 genomic sequence | blastn | 191 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19568795 | 19568795 | PRJNA459724_P_NODE_3436_length_245_cov_1.856481_g3044_i0 | PRJNA459724 | 3436 | 245 | 1.856481 | 4.54837845 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 243 | 1.22e-59 | NTclustered | gi|2906151900|gb|PQ646623.1| | 2832643 | g3044 | i0 | 94.839 | 3.48979591836735 | 155 | 8 | 63 | 0 | 21 | 175 | 155 | 1 | MAG: Caudoviricetes sp. isolate k127_4103174 genomic sequence | blastn | 855 | 243 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20220269 | 20220269 | PRJNA459724_P_NODE_4276_length_202_cov_2.838150_g3884_i0 | PRJNA459724 | 4276 | 202 | 2.83815 | 5.733063 | Lillamyvirus | 2843418 | Viruses | Viruses | 303 | 4.4e-78 | NTclustered | gi|1859666548|ref|NC_048833.1| | 2686247 | g3884 | i0 | 96.703 | 4.50990099009901 | 182 | 6 | 90 | 0 | 10 | 191 | 2216 | 2035 | Flavobacterium phage vB_FspS_hemulen6-1, complete genome | blastn | 911 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lillamyvirus | Lillamyvirus hemulen | ||||
| 24669171 | 24669171 | PRJNA459724_P_NODE_1840_length_406_cov_1.809019_g1466_i0 | PRJNA459724 | 1840 | 406 | 1.809019 | 7.34461714 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 132 | 4.86e-26 | NTclustered | gi|2906143737|gb|PQ646059.1| | 2832643 | g1466 | i0 | 80.105 | 0.470443349753695 | 191 | 27 | 46 | 11 | 157 | 343 | 6810 | 6627 | MAG: Caudoviricetes sp. isolate k127_1709622 genomic sequence | blastn | 191 | 132 | 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);;