contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19581309 | 19581309 | PRJNA493244_P_NODE_134116_length_1383_cov_27.645234_g125387_i0 | PRJNA493244 | 134116 | 1383 | 27.645234 | 382.33358622 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 432 | 4.31e-143 | NR | UJQ91996.1 | 2808997 | g125387 | i0 | 54 | 0.991323210412148 | 457 | 154 | 88.3 | 10 | 1221 | 1 | 2 | 452 | UJQ91996.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] | diamond | 1371 | 432 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 27377210 | 27377210 | PRJNA493244_P_NODE_345543_length_910_cov_1.992933_g328708_i0 | PRJNA493244 | 345543 | 910 | 1.992933 | 18.1356903 | Viruses | 10239 | Viruses | Viruses | 108 | 4.4e-22 | NR | WAK73589.1 | 2976296 | g328708 | i0 | 32.6 | 1.11098901098901 | 218 | 132 | 70.5 | 6 | 822 | 181 | 559 | 765 | WAK73589.1 RNA-dependent RNA polymerase [Phytophthora palustris narna-like virus 4] | diamond | 1011 | 109 | 0.990825688073395 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Phytophthora palustris narna-like virus 4 | |||
| 28087074 | 28087074 | PRJNA493244_P_NODE_855365_length_476_cov_7.419277_g832510_i0 | PRJNA493244 | 855365 | 476 | 7.419277 | 35.31575852 | Sanya botourmia-like virus 15 | 2970187 | Viruses | Viruses | 151 | 2.3099999999999998e-39 | NR | UUW21046.1 | 2970187 | g832510 | i0 | 53.3 | 0.863445378151261 | 137 | 63 | 85.7 | 1 | 442 | 35 | 423 | 559 | UUW21046.1 MAG: putative RNA-dependent RNA polymerase [Sanya botourmia-like virus 15] | diamond | 411 | 151 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sanya botourmia-like virus 15 | |||
| 28466208 | 28466208 | PRJNA493244_P_NODE_1474166_length_249_cov_1.585106_g1451041_i0 | PRJNA493244 | 1474166 | 249 | 1.585106 | 3.94691394 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 127 | 3.869999999999999e-32 | NR | UJQ91947.1 | 2808997 | g1451041 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 2 | 247 | 160 | 241 | UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 246 | 127 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 28971293 | 28971293 | PRJNA493244_P_NODE_894088_length_456_cov_17.840506_g871136_i0 | PRJNA493244 | 894088 | 456 | 17.840506 | 81.35270736 | ssRNA phage SRR696 | 2845865 | Viruses | Viruses | 162 | 5.1499999999999993e-48 | NR | YP_010769763.1 | 2786514 | g871136 | i0 | 57.8 | 2.48026315789474 | 128 | 54 | 84.2 | 0 | 64 | 447 | 1 | 128 | YP_010769763.1 coat protein [ssRNA phage SRR6960507_4] | diamond | 1131 | 162 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Pohlevirus | Pohlevirus caenicola | ||
| 30076332 | 30076332 | PRJNA493244_P_NODE_1368052_length_277_cov_1.893519_g1344927_i0 | PRJNA493244 | 1368052 | 277 | 1.893519 | 5.24504763 | Leviviridae sp. | 2027243 | Viruses | Viruses | 53.5 | 8.42e-6 | NR | DAH09204.1 | 2027243 | g1344927 | i0 | 50 | 0.51985559566787 | 48 | 24 | 52 | 0 | 253 | 110 | 239 | 286 | DAH09204.1 MAG TPA: capsid protein [Leviviridae sp.] | diamond | 144 | 53.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31340413 | 31340413 | PRJNA493244_P_NODE_1579216_length_225_cov_1.493902_g1556091_i0 | PRJNA493244 | 1579216 | 225 | 1.493902 | 3.3612795 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 99.8 | 2.6e-22 | NR | UJQ91947.1 | 2808997 | g1556091 | i0 | 69.7 | 0.88 | 66 | 19 | 88 | 1 | 25 | 222 | 65 | 129 | UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 198 | 99.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 31530372 | 31530372 | PRJNA493244_P_NODE_1089116_length_369_cov_10.240260_g1065995_i0 | PRJNA493244 | 1089116 | 369 | 10.24026 | 37.7865594 | Magnaporthe oryzae botourmiavirus 7 | 2755484 | Viruses | Viruses | 84 | 5.58e-16 | NR | QVU39995.1 | 2755484 | g1065995 | i0 | 51 | 1.5609756097561 | 96 | 45 | 76.4 | 1 | 35 | 316 | 380 | 475 | QVU39995.1 RNA-dependent RNA polymerase [Magnaporthe oryzae botourmiavirus 7] | diamond | 576 | 84 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Epsilonscleroulivirus | Epsilonscleroulivirus alphaoryzae | ||
| 31751480 | 31751480 | PRJNA493244_P_NODE_1523637_length_237_cov_2.903409_g1500512_i0 | PRJNA493244 | 1523637 | 237 | 2.903409 | 6.88107933 | Diplodia seriata botourmiavirus 1 | 2932871 | Viruses | Viruses | 43.9 | 0.0133 | NR | UOK20173.1 | 2932871 | g1500512 | i0 | 41.5 | 0.670886075949367 | 53 | 31 | 67.1 | 0 | 208 | 50 | 503 | 555 | UOK20173.1 RNA dependent RNA polymerase [Diplodia seriata botourmiavirus 1] | diamond | 159 | 43.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Diplodia seriata botourmiavirus 1 |
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);;