contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA753112" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 728756 | 728756 | PRJNA753112_P_NODE_12461_length_384_cov_1.289389_g12119_i0 | PRJNA753112 | 12461 | 384 | 1.289389 | 4.95125376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 708 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12119 | i0 | 100 | 0.997395833333333 | 383 | 0 | 99 | 0 | 1 | 383 | 26361 | 25979 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 383 | 708 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2004922 | 2004922 | PRJNA753112_P_NODE_18842_length_313_cov_1.300000_g18500_i0 | PRJNA753112 | 18842 | 313 | 1.3 | 4.069 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 390 | 5.459999999999999e-104 | NTclustered | gi|2914812743|gb|OR221853.1| | 2832643 | g18500 | i0 | 89.137 | 1.98722044728435 | 313 | 34 | 100 | 0 | 1 | 313 | 22455 | 22143 | MAG: Caudoviricetes sp. isolate MSP1161 genomic sequence | blastn | 622 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4557406 | 4557406 | PRJNA753112_P_NODE_24184_length_277_cov_1.421569_g23842_i0 | PRJNA753112 | 24184 | 277 | 1.421569 | 3.93774613 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 512 | 9.73e-141 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g23842 | i0 | 100 | 1 | 277 | 0 | 100 | 0 | 1 | 277 | 39683 | 39407 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 277 | 512 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5832397 | 5832397 | PRJNA753112_P_NODE_14965_length_351_cov_3.223022_g14623_i0 | PRJNA753112 | 14965 | 351 | 3.223022 | 11.31280722 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 647 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g14623 | i0 | 100 | 1.07692307692308 | 350 | 0 | 99 | 0 | 2 | 351 | 35842 | 36191 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 378 | 647 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5832653 | 5832653 | PRJNA753112_P_NODE_27105_length_261_cov_1.659574_g26763_i0 | PRJNA753112 | 27105 | 261 | 1.659574 | 4.33148814 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 361 | 3.48e-95 | NTclustered | gi|2914812743|gb|OR221853.1| | 2832643 | g26763 | i0 | 91.571 | 9.67049808429119 | 261 | 22 | 100 | 0 | 1 | 261 | 7541 | 7281 | MAG: Caudoviricetes sp. isolate MSP1161 genomic sequence | blastn | 2524 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5832884 | 5832884 | PRJNA753112_P_NODE_7805_length_489_cov_1.961538_g7463_i0 | PRJNA753112 | 7805 | 489 | 1.961538 | 9.59192082 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 904 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g7463 | i0 | 100 | 1.67484662576687 | 489 | 0 | 100 | 0 | 1 | 489 | 42171 | 42659 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 819 | 904 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12208224 | 12208224 | PRJNA753112_P_NODE_11890_length_394_cov_1.177570_g11548_i0 | PRJNA753112 | 11890 | 394 | 1.17757 | 4.6396258 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 728 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g11548 | i0 | 100 | 1 | 394 | 0 | 100 | 0 | 1 | 394 | 33163 | 33556 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 394 | 728 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12208520 | 12208520 | PRJNA753112_P_NODE_28410_length_254_cov_2.342541_g28068_i0 | PRJNA753112 | 28410 | 254 | 2.342541 | 5.95005414 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 337 | 5.69e-88 | NTclustered | gi|2914812743|gb|OR221853.1| | 2832643 | g28068 | i0 | 90.551 | 2.70866141732283 | 254 | 24 | 100 | 0 | 1 | 254 | 12685 | 12938 | MAG: Caudoviricetes sp. isolate MSP1161 genomic sequence | blastn | 688 | 337 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14758094 | 14758094 | PRJNA753112_P_NODE_34492_length_232_cov_2.911950_g34150_i0 | PRJNA753112 | 34492 | 232 | 2.91195 | 6.755724 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 8.2e-116 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g34150 | i0 | 100 | 1 | 232 | 0 | 100 | 0 | 1 | 232 | 37729 | 37498 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 232 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16031523 | 16031523 | PRJNA753112_P_NODE_19813_length_305_cov_1.344828_g19471_i0 | PRJNA753112 | 19813 | 305 | 1.344828 | 4.1017254 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g19471 | i0 | 100 | 1.32131147540984 | 305 | 0 | 100 | 0 | 1 | 305 | 42959 | 42655 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 403 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16031653 | 16031653 | PRJNA753112_P_NODE_26653_length_263_cov_4.068421_g26311_i0 | PRJNA753112 | 26653 | 263 | 4.068421 | 10.69994723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.58e-131 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g26311 | i0 | 99.62 | 1 | 263 | 1 | 100 | 0 | 1 | 263 | 36863 | 36601 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 263 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18580608 | 18580608 | PRJNA753112_P_NODE_15375_length_346_cov_2.380952_g15033_i0 | PRJNA753112 | 15375 | 346 | 2.380952 | 8.23809392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 490 | 5.859999999999998e-134 | NTclustered | gi|2914812743|gb|OR221853.1| | 2832643 | g15033 | i0 | 92.42 | 5.95375722543353 | 343 | 26 | 99 | 0 | 4 | 346 | 13679 | 13337 | MAG: Caudoviricetes sp. isolate MSP1161 genomic sequence | blastn | 2060 | 490 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18580647 | 18580647 | PRJNA753112_P_NODE_17195_length_327_cov_2.070866_g16853_i0 | PRJNA753112 | 17195 | 327 | 2.070866 | 6.77173182 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 599 | 8.759999999999997e-167 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g16853 | i0 | 99.694 | 1 | 327 | 1 | 100 | 0 | 1 | 327 | 40789 | 40463 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 327 | 599 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18581081 | 18581081 | PRJNA753112_P_NODE_8575_length_465_cov_1.808673_g8233_i0 | PRJNA753112 | 8575 | 465 | 1.808673 | 8.41032945 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 854 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g8233 | i0 | 99.785 | 1.7741935483871 | 465 | 1 | 100 | 0 | 1 | 465 | 44501 | 44037 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 825 | 854 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21131430 | 21131430 | PRJNA753112_P_NODE_17537_length_324_cov_1.673307_g17195_i0 | PRJNA753112 | 17537 | 324 | 1.673307 | 5.42151468 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 599 | 8.67e-167 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17195 | i0 | 100 | 1 | 324 | 0 | 100 | 0 | 1 | 324 | 27663 | 27986 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 324 | 599 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22406318 | 22406318 | PRJNA753112_P_NODE_19558_length_307_cov_1.470085_g19216_i0 | PRJNA753112 | 19558 | 307 | 1.470085 | 4.51316095 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 568 | 2.3e-157 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g19216 | i0 | 100 | 1.1042345276873 | 307 | 0 | 100 | 0 | 1 | 307 | 53244 | 53550 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 339 | 568 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22406322 | 22406322 | PRJNA753112_P_NODE_19778_length_305_cov_2.017241_g19436_i0 | PRJNA753112 | 19778 | 305 | 2.017241 | 6.15258505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g19436 | i0 | 100 | 1 | 305 | 0 | 100 | 0 | 1 | 305 | 39369 | 39065 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 305 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22406491 | 22406491 | PRJNA753112_P_NODE_29038_length_252_cov_1.743017_g28696_i0 | PRJNA753112 | 29038 | 252 | 1.743017 | 4.39240284 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 339 | 1.57e-88 | NTclustered | gi|2914812743|gb|OR221853.1| | 2832643 | g28696 | i0 | 90.873 | 1.98809523809524 | 252 | 23 | 100 | 0 | 1 | 252 | 7252 | 7001 | MAG: Caudoviricetes sp. isolate MSP1161 genomic sequence | blastn | 501 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23682304 | 23682304 | PRJNA753112_P_NODE_9499_length_440_cov_2.343324_g9157_i0 | PRJNA753112 | 9499 | 440 | 2.343324 | 10.3106256 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 808 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9157 | i0 | 99.773 | 1 | 440 | 1 | 100 | 0 | 1 | 440 | 40725 | 41164 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 440 | 808 | 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);;