contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26618346 | 26618346 | PRJNA596870_P_NODE_18201_length_311_cov_1.390756_g18068_i0 | PRJNA596870 | 18201 | 311 | 1.390756 | 4.32525116 | Ripduovirus | 2560215 | Viruses | Viruses | 101 | 1.1099999999999999e-23 | NR | YP_009598957.1 | 1923889 | g18068 | i0 | 53.8 | 2.0064308681672 | 104 | 47 | 99.4 | 1 | 310 | 2 | 97 | 200 | YP_009598957.1 hypothetical protein FDH28_gp157 [Ralstonia phage RP12] | diamond | 624 | 102 | 0.990196078431373 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 28279762 | 28279762 | PRJNA596870_P_NODE_29446_length_251_cov_0.865169_g29313_i0 | PRJNA596870 | 29446 | 251 | 0.865169 | 2.17157419 | Providencia phage PSTNGR1 | 2783542 | Viruses | Viruses | 130 | 5.62e-33 | NR | QPB11232.1 | 2783542 | g29313 | i0 | 75.6 | 0.9800796812749 | 82 | 20 | 98 | 0 | 249 | 4 | 32 | 113 | QPB11232.1 DNA-directed RNA polymerase [Providencia phage PSTNGR1] | diamond | 246 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 28829968 | 28829968 | PRJNA596870_P_NODE_39308_length_242_cov_0.911243_g39175_i0 | PRJNA596870 | 39308 | 242 | 0.911243 | 2.20520806 | Ripduovirus | 2560215 | Viruses | Viruses | 85.5 | 3.19e-17 | NR | YP_009598718.1 | 1923889 | g39175 | i0 | 50 | 1.97107438016529 | 80 | 39 | 99.2 | 1 | 241 | 2 | 475 | 553 | YP_009598718.1 virion structural protein [Ralstonia phage RP12] | diamond | 477 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 29037983 | 29037983 | PRJNA596870_P_NODE_29908_length_251_cov_0.865169_g29775_i0 | PRJNA596870 | 29908 | 251 | 0.865169 | 2.17157419 | Ralstonia phage RP12 | 1923889 | Viruses | Viruses | 133 | 3.7499999999999998e-34 | NR | YP_009598967.1 | 1923889 | g29775 | i0 | 73.8 | 1.93625498007968 | 80 | 21 | 95.6 | 0 | 3 | 242 | 592 | 671 | YP_009598967.1 RNA polymerase beta subunit [Ralstonia phage RP12] | diamond | 486 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 29195738 | 29195738 | PRJNA596870_P_NODE_34889_length_246_cov_0.890173_g34756_i0 | PRJNA596870 | 34889 | 246 | 0.890173 | 2.18982558 | Providencia phage PSTNGR1 | 2783542 | Viruses | Viruses | 158 | 7.26e-43 | NR | QPB11269.1 | 2783542 | g34756 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 2 | 244 | 590 | 670 | QPB11269.1 DNA-directed DNA polymerase [Providencia phage PSTNGR1] | diamond | 243 | 158 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 30048024 | 30048024 | PRJNA596870_P_NODE_14511_length_342_cov_1.144981_g14378_i0 | PRJNA596870 | 14511 | 342 | 1.144981 | 3.91583502 | Providencia phage PSTNGR1 | 2783542 | Viruses | Viruses | 187 | 3.67e-53 | NR | QPB11243.1 | 2783542 | g14378 | i0 | 80.7 | 1 | 114 | 22 | 100 | 0 | 342 | 1 | 45 | 158 | QPB11243.1 hypothetical protein [Providencia phage PSTNGR1] | diamond | 342 | 187 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 30711706 | 30711706 | PRJNA596870_P_NODE_9714_length_404_cov_2.075529_g9581_i0 | PRJNA596870 | 9714 | 404 | 2.075529 | 8.38513716 | Erwinia phage FBB1 | 2776772 | Viruses | Viruses | 60.8 | 8.42e-9 | NR | QOI66622.1 | 2776772 | g9581 | i0 | 33.3 | 0.913366336633663 | 123 | 60 | 89.9 | 5 | 1 | 363 | 2 | 104 | QOI66622.1 hypothetical protein [Erwinia phage FBB1] | diamond | 369 | 60.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Roskildevirus | Erwinia phage FBB1 | ||
| 31312097 | 31312097 | PRJNA596870_P_NODE_36735_length_244_cov_0.900585_g36602_i0 | PRJNA596870 | 36735 | 244 | 0.900585 | 2.1974274 | Ralstonia phage RP31 | 1923890 | Viruses | Viruses | 71.6 | 2.5e-12 | NR | BAW19303.1 | 1923890 | g36602 | i0 | 45.6 | 0.971311475409836 | 79 | 43 | 97.1 | 0 | 239 | 3 | 146 | 224 | BAW19303.1 hypothetical protein [Ralstonia phage RP31] | diamond | 237 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 31659900 | 31659900 | PRJNA596870_P_NODE_9877_length_402_cov_1.142857_g9744_i0 | PRJNA596870 | 9877 | 402 | 1.142857 | 4.59428514 | Pseudomonas phage phi-2 | 1450169 | Viruses | Viruses | 128 | 6.31e-33 | NR | YP_003345487.1 | 693582 | g9744 | i0 | 58 | 0.835820895522388 | 112 | 43 | 80.6 | 2 | 77 | 400 | 8 | 119 | YP_003345487.1 DNA polymerase exonuclease subunit [Pseudomonas phage phi-2] | diamond | 336 | 128 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Tunggulvirus | Tunggulvirus f2 | ||
| 32261460 | 32261460 | PRJNA596870_P_NODE_26718_length_262_cov_2.206349_g26585_i0 | PRJNA596870 | 26718 | 262 | 2.206349 | 5.78063438 | Aeromonas phage vB_AsaP_MQM1 | 3038230 | Viruses | Viruses | 53.1 | 5.24e-7 | NR | WFZ78521.1 | 3038230 | g26585 | i0 | 45 | 0.687022900763359 | 60 | 33 | 68.7 | 0 | 30 | 209 | 13 | 72 | WFZ78521.1 hypothetical protein MQM1_038 [Aeromonas phage vB_AsaP_MQM1] | diamond | 180 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage vB_AsaP_MQM1 | |||||
| 32609056 | 32609056 | PRJNA596870_P_NODE_33020_length_248_cov_0.880000_g32887_i0 | PRJNA596870 | 33020 | 248 | 0.88 | 2.1824 | Aeromonas phage vB_AsaP_MQM1 | 3038230 | Viruses | Viruses | 49.7 | 1.39e-4 | NR | WFZ78501.1 | 3038230 | g32887 | i0 | 38.8 | 0.967741935483871 | 80 | 49 | 96.8 | 0 | 2 | 241 | 44 | 123 | WFZ78501.1 hypothetical protein MQM1_018 [Aeromonas phage vB_AsaP_MQM1] | diamond | 240 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage vB_AsaP_MQM1 |
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);;