contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 779355 | 779355 | PRJNA795663_S_NODE_1721_length_426_cov_2.802057_g1616_i0 | PRJNA795663 | 1721 | 426 | 2.802057 | 11.93676282 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 237 | 1.75e-71 | NR | NP_690817.1 | 134554 | g1616 | i0 | 82.4 | 1 | 142 | 25 | 100 | 0 | 426 | 1 | 142 | 283 | NP_690817.1 RNA-dependent RNA polymerase [Pseudomonas phage phi13] | diamond | 426 | 237 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 26841677 | 26841677 | PRJNA795663_S_NODE_1241_length_491_cov_2.799559_g1139_i0 | PRJNA795663 | 1241 | 491 | 2.799559 | 13.74583469 | Cystoviridae | 10877 | Viruses | Viruses | 152 | 2.319999999999999e-41 | NR | NP_690813.1 | 134554 | g1139 | i0 | 73.7 | 1.16089613034623 | 95 | 25 | 58 | 0 | 491 | 207 | 267 | 361 | NP_690813.1 P3a host attachment protein [Pseudomonas phage phi13] | diamond | 570 | 152 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 27022220 | 27022220 | PRJNA795663_S_NODE_18222_length_152_cov_1.991304_g18117_i0 | PRJNA795663 | 18222 | 152 | 1.991304 | 3.02678208 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 84.3 | 2.33e-17 | NR | NP_690823.1 | 161736 | g18117 | i0 | 76 | 0.986842105263158 | 50 | 12 | 98.7 | 0 | 151 | 2 | 134 | 183 | NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] | diamond | 150 | 84.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 27179982 | 27179982 | PRJNA795663_S_NODE_122_length_1271_cov_8.291734_g77_i0 | PRJNA795663 | 122 | 1271 | 8.291734 | 105.38793914 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 201 | 3.200000000000001e-59 | NR | NP_690808.1 | 134554 | g77 | i0 | 68.2 | 0.349331235247836 | 148 | 46 | 34.9 | 1 | 807 | 1250 | 1 | 147 | NP_690808.1 P12 morphogenetic protein [Pseudomonas phage phi13] | diamond | 444 | 201 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 28569647 | 28569647 | PRJNA795663_S_NODE_267_length_918_cov_3.575482_g209_i0 | PRJNA795663 | 267 | 918 | 3.575482 | 32.82292476 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 178 | 9.88e-53 | NR | NP_690820.1 | 161736 | g209 | i0 | 84.8 | 0.323529411764706 | 99 | 15 | 32.4 | 0 | 681 | 385 | 1 | 99 | NP_690820.1 P14 protein [Pseudomonas phage phi12] | diamond | 297 | 178 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 29422029 | 29422029 | PRJNA795663_S_NODE_18309_length_152_cov_1.513043_g18204_i0 | PRJNA795663 | 18309 | 152 | 1.513043 | 2.29982536 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 80.1 | 7.18e-16 | NR | NP_690819.1 | 134554 | g18204 | i0 | 72 | 0.986842105263158 | 50 | 14 | 98.7 | 0 | 150 | 1 | 110 | 159 | NP_690819.1 P1 procapsid protein [Pseudomonas phage phi13] | diamond | 150 | 80.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 29642889 | 29642889 | PRJNA795663_S_NODE_14370_length_167_cov_1.169231_g14265_i0 | PRJNA795663 | 14370 | 167 | 1.169231 | 1.95261577 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 108 | 1.4500000000000002e-26 | NR | NP_690813.1 | 134554 | g14265 | i0 | 94.5 | 0.988023952095808 | 55 | 3 | 98.8 | 0 | 2 | 166 | 28 | 82 | NP_690813.1 P3a host attachment protein [Pseudomonas phage phi13] | diamond | 165 | 108 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 30843810 | 30843810 | PRJNA795663_S_NODE_12974_length_174_cov_1.401460_g12869_i0 | PRJNA795663 | 12974 | 174 | 1.40146 | 2.4385404 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 92 | 6.21e-20 | NR | NP_690819.1 | 134554 | g12869 | i0 | 74.1 | 0.931034482758621 | 54 | 14 | 93.1 | 0 | 12 | 173 | 27 | 80 | NP_690819.1 P1 procapsid protein [Pseudomonas phage phi13] | diamond | 162 | 92 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 31855382 | 31855382 | PRJNA795663_S_NODE_5877_length_243_cov_1.315534_g5772_i0 | PRJNA795663 | 5877 | 243 | 1.315534 | 3.19674762 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 154 | 1.13e-43 | NR | NP_690813.1 | 134554 | g5772 | i0 | 95 | 0.987654320987654 | 80 | 4 | 98.8 | 0 | 241 | 2 | 228 | 307 | NP_690813.1 P3a host attachment protein [Pseudomonas phage phi13] | diamond | 240 | 154 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 32266994 | 32266994 | PRJNA795663_S_NODE_178_length_1091_cov_7.204934_g128_i0 | PRJNA795663 | 178 | 1091 | 7.204934 | 78.60582994 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 250 | 2.19e-79 | NR | NP_690816.1 | 134554 | g128 | i0 | 77.7 | 0.431714023831347 | 157 | 34 | 43.2 | 1 | 796 | 326 | 1 | 156 | NP_690816.1 P7 procapsid protein [Pseudomonas phage phi13] | diamond | 471 | 250 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 32298799 | 32298799 | PRJNA795663_S_NODE_3359_length_313_cov_2.623188_g3254_i0 | PRJNA795663 | 3359 | 313 | 2.623188 | 8.21057844 | Pseudomonas phage phi13 | 134554 | Viruses | Viruses | 195 | 2.3999999999999996e-56 | NR | NP_690817.1 | 134554 | g3254 | i0 | 86.4 | 1.97444089456869 | 103 | 14 | 98.7 | 0 | 309 | 1 | 293 | 395 | NP_690817.1 RNA-dependent RNA polymerase [Pseudomonas phage phi13] | diamond | 618 | 195 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Gammacystovirus | Gammacystovirus phi13 | ||
| 32866413 | 32866413 | PRJNA795663_S_NODE_6280_length_235_cov_1.914141_g6175_i0 | PRJNA795663 | 6280 | 235 | 1.914141 | 4.49823135 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 134 | 1.09e-34 | NR | NP_690823.1 | 161736 | g6175 | i0 | 79.5 | 0.995744680851064 | 78 | 16 | 99.6 | 0 | 1 | 234 | 11 | 88 | NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] | diamond | 234 | 134 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 32897819 | 32897819 | PRJNA795663_S_NODE_1440_length_462_cov_1.816471_g1335_i0 | PRJNA795663 | 1440 | 462 | 1.816471 | 8.39209602 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 127 | 1.2e-30 | NR | NP_690823.1 | 161736 | g1335 | i0 | 80.6 | 0.467532467532468 | 72 | 14 | 46.8 | 0 | 1 | 216 | 588 | 659 | NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] | diamond | 216 | 127 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 |
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);;