contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1016321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26749571 | 26749571 | PRJNA1016321_P_NODE_29961_length_332_cov_2.428571_g29730_i0 | PRJNA1016321 | 29961 | 332 | 2.428571 | 8.06285572 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 177 | 4.45e-49 | NR | YP_874015.1 | 407392 | g29730 | i0 | 77.3 | 0.993975903614458 | 110 | 24 | 99.4 | 1 | 2 | 331 | 743 | 851 | YP_874015.1 hypothetical protein YS40_002 [Thermus phage phiYS40] | diamond | 330 | 177 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 27161006 | 27161006 | PRJNA1016321_P_NODE_34882_length_304_cov_1.017316_g34651_i0 | PRJNA1016321 | 34882 | 304 | 1.017316 | 3.09264064 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 174 | 7.21e-50 | NR | XOR12631.1 | 2832643 | g34651 | i0 | 81.2 | 0.996710526315789 | 101 | 19 | 99.7 | 0 | 2 | 304 | 228 | 328 | XOR12631.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 303 | 174 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27571984 | 27571984 | PRJNA1016321_P_NODE_35384_length_301_cov_1.350877_g35153_i0 | PRJNA1016321 | 35384 | 301 | 1.350877 | 4.06613977 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 135 | 2.03e-36 | NR | XOR12615.1 | 2832643 | g35153 | i0 | 61 | 0.996677740863787 | 100 | 39 | 99.7 | 0 | 2 | 301 | 35 | 134 | XOR12615.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 300 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27698661 | 27698661 | PRJNA1016321_P_NODE_49824_length_249_cov_0.875000_g49593_i0 | PRJNA1016321 | 49824 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 92 | 2.1500000000000003e-21 | NR | XOR12618.1 | 2832643 | g49593 | i0 | 56.1 | 0.987951807228916 | 82 | 36 | 98.8 | 0 | 248 | 3 | 10 | 91 | XOR12618.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 246 | 92 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29623813 | 29623813 | PRJNA1016321_P_NODE_51490_length_246_cov_3.942197_g51259_i0 | PRJNA1016321 | 51490 | 246 | 3.942197 | 9.69780462 | Brevibacillus phage Jenst | 1691954 | Viruses | Viruses | 105 | 2.32e-24 | NR | YP_009199142.1 | 1691954 | g51259 | i0 | 60.8 | 0.963414634146341 | 79 | 31 | 96.3 | 0 | 9 | 245 | 98 | 176 | YP_009199142.1 putative ribonucleotide-diphosphate reductase subunit alpha [Brevibacillus phage Jenst] | diamond | 237 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jenstvirus | Jenstvirus jenst | ||||
| 30729942 | 30729942 | PRJNA1016321_P_NODE_53194_length_244_cov_2.070175_g52963_i0 | PRJNA1016321 | 53194 | 244 | 2.070175 | 5.051227 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 123 | 1.94e-30 | NR | XOR12644.1 | 2832643 | g52963 | i0 | 79.7 | 0.909836065573771 | 74 | 15 | 91 | 0 | 243 | 22 | 281 | 354 | XOR12644.1 MAG: putative primase [Caudoviricetes sp.] | diamond | 222 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31267213 | 31267213 | PRJNA1016321_P_NODE_31875_length_320_cov_2.202429_g31644_i0 | PRJNA1016321 | 31875 | 320 | 2.202429 | 7.0477728 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 2.5199999999999997e-30 | NR | XOR12614.1 | 2832643 | g31644 | i0 | 63.2 | 0.815625 | 87 | 32 | 81.6 | 0 | 318 | 58 | 221 | 307 | XOR12614.1 MAG: structural phage protein [Caudoviricetes sp.] | diamond | 261 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31298752 | 31298752 | PRJNA1016321_P_NODE_32655_length_315_cov_3.508264_g32424_i0 | PRJNA1016321 | 32655 | 315 | 3.508264 | 11.0510316 | Bacillus phage Stills | 1610833 | Viruses | Viruses | 78.6 | 1.03e-14 | NR | YP_009196920.1 | 1610833 | g32424 | i0 | 77.8 | 0.866666666666667 | 45 | 10 | 42.9 | 0 | 8 | 142 | 267 | 311 | YP_009196920.1 hypothetical protein CPT_Stills35 [Bacillus phage Stills] | diamond | 273 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Slashvirus | Slashvirus stills | ||||
| 32089623 | 32089623 | PRJNA1016321_P_NODE_46498_length_255_cov_1.362637_g46267_i0 | PRJNA1016321 | 46498 | 255 | 1.362637 | 3.47472435 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 92.4 | 2.77e-20 | NR | XOR12615.1 | 2832643 | g46267 | i0 | 60 | 0.882352941176471 | 75 | 29 | 88.2 | 1 | 248 | 24 | 230 | 303 | XOR12615.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 225 | 92.4 | 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);;