contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27184458 | 27184458 | PRJDB9741_P_NODE_11442_length_198_cov_2.536913_g11125_i0 | PRJDB9741 | 11442 | 198 | 2.536913 | 5.02308774 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0286 | NR | CAG7580904.1 | 707152 | g11125 | i0 | 78.9 | 0.590909090909091 | 19 | 4 | 28.8 | 0 | 2 | 58 | 1511 | 1529 | CAG7580904.1 MAG: putative hydrolase [uncultured marine phage] | diamond | 117 | 42.4 | 1 | Viruses | uncultured marine phage | ||||||||
| 27285390 | 27285390 | PRJDB9741_P_NODE_19183_length_179_cov_1.853846_g18866_i0 | PRJDB9741 | 19183 | 179 | 1.853846 | 3.31838434 | Porcellio scaber clopovirus | 2984285 | Viruses | Viruses | 80.5 | 1.15e-16 | NR | BDV50000.1 | 2984285 | g18866 | i0 | 69.5 | 0.988826815642458 | 59 | 18 | 98.9 | 0 | 1 | 177 | 113 | 171 | BDV50000.1 MAG: hypothetical protein [Porcellio scaber clopovirus] | diamond | 177 | 80.5 | 1 | Viruses | Naldaviricetes | Nimaviridae | Porcellio scaber clopovirus | ||||||
| 27380402 | 27380402 | PRJDB9741_P_NODE_15503_length_186_cov_1.160584_g15186_i0 | PRJDB9741 | 15503 | 186 | 1.160584 | 2.15868624 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 55.8 | 1.75e-7 | NR | YP_010780883.1 | 2126984 | g15186 | i0 | 51.2 | 0.693548387096774 | 43 | 21 | 69.4 | 0 | 2 | 130 | 23 | 65 | YP_010780883.1 rab family small GTPase [Tupanvirus deep ocean] | diamond | 129 | 55.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 28043296 | 28043296 | PRJDB9741_P_NODE_6985_length_237_cov_1.994681_g6668_i0 | PRJDB9741 | 6985 | 237 | 1.994681 | 4.72739397 | ssRNA phage Gerhypos.1_36 | 2786219 | Viruses | Viruses | 51.6 | 4.6e-6 | NR | YP_010770575.1 | 2786219 | g6668 | i0 | 43.9 | 1.67088607594937 | 66 | 36 | 83.5 | 1 | 13 | 210 | 1 | 65 | YP_010770575.1 coat protein [ssRNA phage Gerhypos.1_36] | diamond | 396 | 51.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neopedovicinum | ||
| 28864119 | 28864119 | PRJDB9741_P_NODE_1168_length_786_cov_1.875170_g909_i0 | PRJDB9741 | 1168 | 786 | 1.87517 | 14.7388362 | ssRNA phage SRR5467 | 2844986 | Viruses | Viruses | 69.3 | 2.27e-9 | NR | YP_010770771.1 | 2786460 | g909 | i0 | 28.1 | 1.1412213740458 | 299 | 165 | 98.5 | 10 | 6 | 779 | 89 | 378 | YP_010770771.1 maturation protein [ssRNA phage SRR5467091_10] | diamond | 897 | 69.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Huylevirus | Huylevirus limihabitans | ||
| 30190419 | 30190419 | PRJDB9741_P_NODE_32552_length_165_cov_0.879310_g32235_i0 | PRJDB9741 | 32552 | 165 | 0.87931 | 1.4508615 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 75.5 | 3.61e-14 | NR | YP_009595861.1 | 1837876 | g32235 | i0 | 66.7 | 0.927272727272727 | 51 | 17 | 92.7 | 0 | 12 | 164 | 401 | 451 | YP_009595861.1 tail sheath [Acinetobacter phage vB_AbaM_ME3] | diamond | 153 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 30222035 | 30222035 | PRJDB9741_P_NODE_37592_length_162_cov_0.902655_g37275_i0 | PRJDB9741 | 37592 | 162 | 0.902655 | 1.4623011 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 62.8 | 1.03e-9 | NR | YP_010804182.1 | 3060017 | g37275 | i0 | 60.8 | 1.92592592592593 | 51 | 13 | 94.4 | 1 | 5 | 157 | 278 | 321 | YP_010804182.1 putative D-alanine-D-alanine ligase [Fadolivirus algeromassiliense] | diamond | 312 | 62.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30695940 | 30695940 | PRJDB9741_P_NODE_10834_length_200_cov_2.655629_g10517_i0 | PRJDB9741 | 10834 | 200 | 2.655629 | 5.311258 | Riboviria sp. | 2585031 | Viruses | Viruses | 94.4 | 1.29e-20 | NR | WKV33779.1 | 2585031 | g10517 | i0 | 72.7 | 0.99 | 66 | 18 | 99 | 0 | 2 | 199 | 441 | 506 | WKV33779.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 198 | 94.4 | 1 | Viruses | Riboviria sp. | ||||||||
| 30980611 | 30980611 | PRJDB9741_P_NODE_8834_length_213_cov_1.292683_g8517_i0 | PRJDB9741 | 8834 | 213 | 1.292683 | 2.75341479 | Riboviria sp. | 2585031 | Viruses | Viruses | 90.5 | 3.53e-19 | NR | WKV33779.1 | 2585031 | g8517 | i0 | 62.9 | 0.985915492957746 | 70 | 26 | 98.6 | 0 | 3 | 212 | 109 | 178 | WKV33779.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 210 | 90.5 | 1 | Viruses | Riboviria sp. | ||||||||
| 31138074 | 31138074 | PRJDB9741_P_NODE_40935_length_160_cov_2.342342_g40618_i0 | PRJDB9741 | 40935 | 160 | 2.342342 | 3.7477472 | Bodo saltans virus | 2024608 | Viruses | Viruses | 51.2 | 1.14e-5 | NR | YP_010778322.1 | 2024608 | g40618 | i0 | 46.2 | 0.975 | 52 | 28 | 97.5 | 0 | 160 | 5 | 141 | 192 | YP_010778322.1 soluble N-ethylmaleimide-sensitive factor (NSF) attachment protein [Bodo saltans virus] | diamond | 156 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 31232995 | 31232995 | PRJDB9741_P_NODE_36115_length_163_cov_0.894737_g35798_i0 | PRJDB9741 | 36115 | 163 | 0.894737 | 1.45842131 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 39.3 | 0.0378 | NR | CAB4125468.1 | 2100421 | g35798 | i0 | 50 | 0.588957055214724 | 32 | 16 | 58.9 | 0 | 110 | 15 | 34 | 65 | CAB4125468.1 hypothetical protein UFOVP57_133 [uncultured Caudovirales phage] | diamond | 96 | 39.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31865572 | 31865572 | PRJDB9741_P_NODE_37917_length_162_cov_0.902655_g37600_i0 | PRJDB9741 | 37917 | 162 | 0.902655 | 1.4623011 | Arthrobacter phage MrSmee | 3400169 | Viruses | Viruses | 92.4 | 3.18e-21 | NR | XOT86638.1 | 3400169 | g37600 | i0 | 74.5 | 0.944444444444444 | 51 | 13 | 94.4 | 0 | 158 | 6 | 117 | 167 | XOT86638.1 hypothetical protein SEA_MRSMEE_4 [Arthrobacter phage MrSmee] | diamond | 153 | 92.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arthrobacter phage MrSmee |
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);;