contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9573250 | 9573250 | PRJNA674308_P_NODE_29368_length_186_cov_1.518248_g29133_i0 | PRJNA674308 | 29368 | 186 | 1.518248 | 2.82394128 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 110 | 2.7e-26 | NR | XOR83203.1 | 2832643 | g29133 | i0 | 82 | 0.983870967741935 | 61 | 11 | 98.4 | 0 | 1 | 183 | 298 | 358 | XOR83203.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 183 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26606763 | 26606763 | PRJNA674308_P_NODE_44881_length_165_cov_0.896552_g44646_i0 | PRJNA674308 | 44881 | 165 | 0.896552 | 1.4793108 | Bacillus phage B1 | 10778 | Viruses | Viruses | 82.8 | 3.18e-17 | NR | NP_690645.1 | 2994042 | g44646 | i0 | 67.9 | 0.963636363636364 | 53 | 17 | 96.4 | 0 | 159 | 1 | 11 | 63 | NP_690645.1 adaptor Ad4 [Bacillus phage B103] | diamond | 159 | 82.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Beecentumtrevirus | Beecentumtrevirus B103 | |||
| 27081807 | 27081807 | PRJNA674308_P_NODE_47702_length_164_cov_0.904348_g47467_i0 | PRJNA674308 | 47702 | 164 | 0.904348 | 1.48313072 | Pantoea phage vB_PagS_AAS21 | 2575261 | Viruses | Viruses | 57.8 | 4.24e-9 | NR | QCW23777.1 | 2575261 | g47467 | i0 | 93.5 | 0.567073170731707 | 31 | 2 | 56.7 | 0 | 1 | 93 | 67 | 97 | QCW23777.1 putative nucleoside triphosphate pyrophosphohydrolase [Pantoea phage vB_PagS_AAS21] | diamond | 93 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Keyvirus | Keyvirus AAS21 | |||
| 27113242 | 27113242 | PRJNA674308_P_NODE_50162_length_163_cov_0.912281_g49927_i0 | PRJNA674308 | 50162 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.9 | 4.46e-16 | NR | XOR36271.1 | 2832643 | g49927 | i0 | 72.2 | 1.98773006134969 | 54 | 15 | 99.4 | 0 | 162 | 1 | 95 | 148 | XOR36271.1 MAG: putative phage structural protein [Caudoviricetes sp.] | diamond | 324 | 80.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27461148 | 27461148 | PRJNA674308_P_NODE_53543_length_162_cov_0.920354_g53308_i0 | PRJNA674308 | 53543 | 162 | 0.920354 | 1.49097348 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94 | 7.170000000000001e-21 | NR | DAV36678.1 | 2832643 | g53308 | i0 | 84.9 | 0.981481481481482 | 53 | 8 | 98.1 | 0 | 3 | 161 | 354 | 406 | DAV36678.1 MAG TPA: THERMOSTABLE DNA LIGASE [Caudoviricetes sp.] | diamond | 159 | 94 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27555518 | 27555518 | PRJNA674308_P_NODE_41064_length_167_cov_0.881356_g40829_i0 | PRJNA674308 | 41064 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 67.4 | 2.66e-11 | NR | DAY01898.1 | 2832643 | g40829 | i0 | 56.1 | 1.18562874251497 | 66 | 13 | 98.8 | 2 | 166 | 2 | 269 | 329 | DAY01898.1 MAG TPA: DNA POLYMERASE [Caudoviricetes sp.] | diamond | 198 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28187002 | 28187002 | PRJNA674308_P_NODE_48186_length_164_cov_0.904348_g47951_i0 | PRJNA674308 | 48186 | 164 | 0.904348 | 1.48313072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.1 | 1.48e-17 | NR | XOS04997.1 | 2832643 | g47951 | i0 | 81.5 | 0.98780487804878 | 54 | 10 | 98.8 | 0 | 164 | 3 | 383 | 436 | XOS04997.1 MAG: p005a protein, partial [Caudoviricetes sp.] | diamond | 162 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28218527 | 28218527 | PRJNA674308_P_NODE_22746_length_208_cov_1.943396_g22511_i0 | PRJNA674308 | 22746 | 208 | 1.943396 | 4.04226368 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 5.19e-9 | NR | DAV36652.1 | 2832643 | g22511 | i0 | 58.5 | 0.764423076923077 | 53 | 22 | 76.4 | 0 | 7 | 165 | 536 | 588 | DAV36652.1 MAG TPA: stage V sporulation protein K [Caudoviricetes sp.] | diamond | 159 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29765749 | 29765749 | PRJNA674308_P_NODE_31311_length_181_cov_1.181818_g31076_i0 | PRJNA674308 | 31311 | 181 | 1.181818 | 2.13909058 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 107 | 2.77e-25 | NR | XOR99870.1 | 2832643 | g31076 | i0 | 80 | 0.994475138121547 | 60 | 12 | 99.4 | 0 | 1 | 180 | 435 | 494 | XOR99870.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] | diamond | 180 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30207886 | 30207886 | PRJNA674308_P_NODE_51492_length_163_cov_0.912281_g51257_i0 | PRJNA674308 | 51492 | 163 | 0.912281 | 1.48701803 | Pantoea phage vB_PagS_AAS21 | 2575261 | Viruses | Viruses | 108 | 8.37e-26 | NR | QCW23755.1 | 2575261 | g51257 | i0 | 96.3 | 0.993865030674847 | 54 | 2 | 99.4 | 0 | 1 | 162 | 765 | 818 | QCW23755.1 putative tail protein [Pantoea phage vB_PagS_AAS21] | diamond | 162 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Keyvirus | Keyvirus AAS21 | |||
| 30650280 | 30650280 | PRJNA674308_P_NODE_36033_length_169_cov_0.866667_g35798_i0 | PRJNA674308 | 36033 | 169 | 0.866667 | 1.46466723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.2 | 3.95e-9 | NR | DAY72191.1 | 2832643 | g35798 | i0 | 54.7 | 0.940828402366864 | 53 | 24 | 94.1 | 0 | 167 | 9 | 608 | 660 | DAY72191.1 MAG TPA: chitosanase [Caudoviricetes sp.] | diamond | 159 | 61.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31377526 | 31377526 | PRJNA674308_P_NODE_48376_length_164_cov_0.904348_g48141_i0 | PRJNA674308 | 48376 | 164 | 0.904348 | 1.48313072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94.7 | 5.089999999999999e-23 | NR | XOQ91038.1 | 2832643 | g48141 | i0 | 70.4 | 0.98780487804878 | 54 | 16 | 98.8 | 0 | 163 | 2 | 40 | 93 | XOQ91038.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 94.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31409088 | 31409088 | PRJNA674308_P_NODE_50416_length_163_cov_0.912281_g50181_i0 | PRJNA674308 | 50416 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.8 | 1.0300000000000001e-22 | NR | XOR08292.1 | 2832643 | g50181 | i0 | 88.7 | 0.975460122699387 | 53 | 6 | 97.5 | 0 | 161 | 3 | 120 | 172 | XOR08292.1 MAG: intein-containing putative ribonucleoside diphosphate reductase alpha subunit precursor [Caudoviricetes sp.] | diamond | 159 | 99.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32295161 | 32295161 | PRJNA674308_P_NODE_19359_length_223_cov_1.195402_g19124_i0 | PRJNA674308 | 19359 | 223 | 1.195402 | 2.66574646 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 136 | 1.9699999999999998e-38 | NR | DAV82004.1 | 2832643 | g19124 | i0 | 80.8 | 0.982062780269058 | 73 | 14 | 98.2 | 0 | 221 | 3 | 70 | 142 | DAV82004.1 MAG TPA: E1 enzyme family protein [Caudoviricetes sp.] | diamond | 219 | 136 | 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);;