contig_metadata
10 rows where bioproject = "PRJNA561138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820662 | 1820662 | PRJNA561138_P_NODE_16702_length_321_cov_0.931452_g16507_i0 | PRJNA561138 | 16702 | 321 | 0.931452 | 2.98996092 | Marinobacter phage AS1 | 2484222 | Viruses | Viruses | 154 | 8.03e-33 | NTclustered | gi|1500755202|gb|MK088078.1| | 2484222 | g16507 | i0 | 82.54 | 0.588785046728972 | 189 | 20 | 55 | 8 | 15 | 191 | 35037 | 34850 | Marinobacter phage AS1, complete genome | blastn | 189 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marinobacter phage AS1 | |||||
| 3095918 | 3095918 | PRJNA561138_P_NODE_12723_length_366_cov_1.051195_g12528_i0 | PRJNA561138 | 12723 | 366 | 1.051195 | 3.8473737 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 676 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12528 | i0 | 100 | 1 | 366 | 0 | 100 | 0 | 1 | 366 | 20690 | 20325 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 366 | 676 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4372442 | 4372442 | PRJNA561138_P_NODE_15304_length_335_cov_1.763359_g15109_i0 | PRJNA561138 | 15304 | 335 | 1.763359 | 5.90725265 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 619 | 6.91e-173 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g15109 | i0 | 100 | 1 | 335 | 0 | 100 | 0 | 1 | 335 | 29007 | 29341 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 335 | 619 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8198085 | 8198085 | PRJNA561138_P_NODE_30107_length_241_cov_0.916667_g29912_i0 | PRJNA561138 | 30107 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.3 | 5.99e-8 | NTclustered | gi|2058081374|tpg|BK043151.1| | 2832643 | g29912 | i0 | 84.722 | 0.759336099585062 | 72 | 9 | 29 | 2 | 46 | 116 | 27321 | 27391 | MAG TPA_asm: Caudoviricetes sp. isolate ctE0o3, partial genome | blastn | 183 | 71.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13299139 | 13299139 | PRJNA561138_P_NODE_22291_length_270_cov_1.172589_g22096_i0 | PRJNA561138 | 22291 | 270 | 1.172589 | 3.1659903 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.349999999999998e-137 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g22096 | i0 | 100 | 1 | 270 | 0 | 100 | 0 | 1 | 270 | 58462 | 58731 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 270 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14574026 | 14574026 | PRJNA561138_P_NODE_21432_length_278_cov_0.941463_g21237_i0 | PRJNA561138 | 21432 | 278 | 0.941463 | 2.61726714 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 87.9 | 7.01e-13 | NTclustered | gi|2914826450|gb|OR222314.1| | 2832643 | g21237 | i0 | 85.714 | 0.302158273381295 | 84 | 10 | 30 | 2 | 32 | 114 | 39859 | 39777 | MAG: Caudoviricetes sp. isolate MSP1088 genomic sequence | blastn | 84 | 87.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23497418 | 23497418 | PRJNA561138_P_NODE_22139_length_271_cov_1.555556_g21944_i0 | PRJNA561138 | 22139 | 271 | 1.555556 | 4.21555676 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 501 | 2.05e-137 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g21944 | i0 | 100 | 56.6678966789668 | 271 | 0 | 100 | 0 | 1 | 271 | 18406 | 18676 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 15357 | 501 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27995140 | 27995140 | PRJNA561138_P_NODE_9685_length_409_cov_1.273810_g9490_i0 | PRJNA561138 | 9685 | 409 | 1.27381 | 5.2098829 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 117 | 8.869999999999999e-31 | NR | XOR38101.1 | 2832643 | g9490 | i0 | 58.1 | 0.858190709046455 | 117 | 29 | 71.1 | 2 | 401 | 111 | 24 | 140 | XOR38101.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 351 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31437828 | 31437828 | PRJNA561138_P_NODE_23676_length_257_cov_1.673913_g23481_i0 | PRJNA561138 | 23676 | 257 | 1.673913 | 4.30195641 | Rhizobium phage P11VFA | 2763530 | Viruses | Viruses | 78.6 | 6.97e-17 | NR | QNH72157.1 | 2763530 | g23481 | i0 | 47.6 | 1.91439688715953 | 84 | 39 | 92.2 | 2 | 250 | 14 | 4 | 87 | QNH72157.1 hypothetical protein P11VFA_042 [Rhizobium phage P11VFA] | diamond | 492 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage P11VFA | |||||
| 32860147 | 32860147 | PRJNA561138_P_NODE_16680_length_321_cov_1.129032_g16485_i0 | PRJNA561138 | 16680 | 321 | 1.129032 | 3.62419272 | Vibrio phage 2.275.O._1 | 1881285 | Viruses | Viruses | 65.9 | 5.84e-11 | NR | AUS02934.1 | 1881285 | g16485 | i0 | 38.4 | 0.682242990654206 | 73 | 45 | 68.2 | 0 | 1 | 219 | 65 | 137 | AUS02934.1 NUDIX domain protein [Vibrio phage 2.275.O._10N.286.54.E11] | diamond | 219 | 65.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage 2.275.O._10N.286.54.E11 |
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);;