contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26605918 | 26605918 | PRJNA635397_P_NODE_41181_length_249_cov_1.494318_g40727_i0 | PRJNA635397 | 41181 | 249 | 1.494318 | 3.72085182 | Bacillus phage BeachBum | 1983461 | Viruses | Viruses | 76.3 | 1.61e-15 | NR | YP_009910182.1 | 1983461 | g40727 | i0 | 47.5 | 0.963855421686747 | 80 | 42 | 96.4 | 0 | 3 | 242 | 20 | 99 | YP_009910182.1 late transcriptional activator [Bacillus phage BeachBum] | diamond | 240 | 76.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Harambevirus | Harambevirus beachbum | |||
| 26618641 | 26618641 | PRJNA635397_P_NODE_41881_length_248_cov_1.491429_g41427_i0 | PRJNA635397 | 41881 | 248 | 1.491429 | 3.69874392 | Cinunavirus | 2560117 | Viruses | Viruses | 53.1 | 7.66e-6 | NR | ADW08988.1 | 686440 | g41427 | i0 | 35 | 3.65322580645161 | 80 | 49 | 96.8 | 2 | 246 | 7 | 193 | 269 | ADW08988.1 helicase-like protein, partial [Clavibacter phage CN77] | diamond | 906 | 53.5 | 0.992523364485981 | Viruses | Clavibacter phage CN77 | ||||||||
| 26891356 | 26891356 | PRJNA635397_P_NODE_4341_length_938_cov_2.366474_g3977_i0 | PRJNA635397 | 4341 | 938 | 2.366474 | 22.19752612 | Barns Ness dog whelk bunya/arena-like virus 1 | 2021931 | Viruses | Viruses | 115 | 1.94e-24 | NR | ASM94090.1 | 2021931 | g3977 | i0 | 33.9 | 0.812366737739872 | 254 | 146 | 79.6 | 6 | 51 | 797 | 85 | 321 | ASM94090.1 putative RNA-dependent RNA polymerase, partial [Barns Ness dog whelk bunya/arena-like virus 1] | diamond | 762 | 115 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Barns Ness dog whelk bunya/arena-like virus 1 | ||||
| 27428849 | 27428849 | PRJNA635397_P_NODE_41543_length_249_cov_0.880682_g41089_i0 | PRJNA635397 | 41543 | 249 | 0.880682 | 2.19289818 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 114 | 3.5700000000000005e-27 | NR | DAQ76521.1 | 2832643 | g41089 | i0 | 76.8 | 0.987951807228916 | 82 | 19 | 98.8 | 0 | 3 | 248 | 139 | 220 | DAQ76521.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 246 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28565257 | 28565257 | PRJNA635397_P_NODE_45287_length_244_cov_0.877193_g44833_i0 | PRJNA635397 | 45287 | 244 | 0.877193 | 2.14035092 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 48.9 | 2.48e-4 | NR | ARF12104.1 | 1977640 | g44833 | i0 | 46.9 | 0.602459016393443 | 49 | 21 | 60.2 | 2 | 17 | 163 | 34 | 77 | ARF12104.1 serpin [Klosneuvirus KNV1] | diamond | 147 | 48.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 30049151 | 30049151 | PRJNA635397_P_NODE_18551_length_377_cov_2.483553_g18097_i0 | PRJNA635397 | 18551 | 377 | 2.483553 | 9.36299481 | Changping bunya-like virus 1 | 1922825 | Viruses | Viruses | 47.8 | 0.00308 | NR | APG79246.1 | 1922825 | g18097 | i0 | 29 | 0.795755968169761 | 100 | 69 | 78.8 | 2 | 352 | 56 | 1391 | 1489 | APG79246.1 RNA-dependent RNA polymerase, partial [Changping bunya-like virus 1] | diamond | 300 | 47.8 | 1 | Viruses | Changping bunya-like virus 1 | ||||||||
| 30397376 | 30397376 | PRJNA635397_P_NODE_25993_length_313_cov_1.566667_g25539_i0 | PRJNA635397 | 25993 | 313 | 1.566667 | 4.90366771 | Changping bunya-like virus 1 | 1922825 | Viruses | Viruses | 69.7 | 3.07e-11 | NR | APG79246.1 | 1922825 | g25539 | i0 | 37.2 | 0.900958466453674 | 94 | 55 | 90.1 | 2 | 25 | 306 | 1505 | 1594 | APG79246.1 RNA-dependent RNA polymerase, partial [Changping bunya-like virus 1] | diamond | 282 | 69.7 | 1 | Viruses | Changping bunya-like virus 1 | ||||||||
| 32325953 | 32325953 | PRJNA635397_P_NODE_1099_length_1860_cov_3.543928_g968_i0 | PRJNA635397 | 1099 | 1860 | 3.543928 | 65.9170608 | Lothians earthworm bunya/orthobunya-like virus 1 | 2021934 | Viruses | Viruses | 145 | 2.9499999999999992e-34 | NR | ASM94074.1 | 2021934 | g968 | i0 | 27.6 | 0.641935483870968 | 398 | 254 | 62.9 | 13 | 1365 | 196 | 6 | 377 | ASM94074.1 putative glycoprotein, partial [Lothians earthworm bunya/orthobunya-like virus 1] | diamond | 1194 | 145 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Lothians earthworm bunya/orthobunya-like virus 1 | ||||
| 32685460 | 32685460 | PRJNA635397_P_NODE_9780_length_563_cov_2.412245_g9331_i0 | PRJNA635397 | 9780 | 563 | 2.412245 | 13.58093935 | Viruses | 10239 | Viruses | Viruses | 116 | 3.06e-26 | NR | APG79342.1 | 1923749 | g9331 | i0 | 40.5 | 1.80106571936057 | 158 | 93 | 83.7 | 1 | 529 | 59 | 1819 | 1976 | APG79342.1 RNA-dependent RNA polymerase [Wuhan snail virus 2] | diamond | 1014 | 116 | 1 | Viruses | Wuhan snail virus 2 |
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);;