contig_metadata
13 rows where bioproject = "PRJNA1000943", tax_phylum = "Duplornaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19270729 | 19270729 | PRJNA1000943_P_NODE_4776_length_363_cov_1.613793_g4639_i0 | PRJNA1000943 | 4776 | 363 | 1.613793 | 5.85806859 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 250 | 9.66e-75 | NR | YP_009508104.1 | 607716 | g4639 | i0 | 96.7 | 1 | 121 | 4 | 100 | 0 | 1 | 363 | 352 | 472 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 363 | 250 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 26622749 | 26622749 | PRJNA1000943_P_NODE_1541_length_614_cov_1.360444_g1406_i0 | PRJNA1000943 | 1541 | 614 | 1.360444 | 8.35312616 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 292 | 1.4599999999999996e-89 | NR | YP_009508105.1 | 607716 | g1406 | i0 | 74.4 | 0.879478827361563 | 180 | 46 | 87.9 | 0 | 613 | 74 | 774 | 953 | YP_009508105.1 capsid protein [Alphachrysovirus aspergilli] | diamond | 540 | 292 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 27223812 | 27223812 | PRJNA1000943_P_NODE_15623_length_241_cov_2.452381_g15485_i0 | PRJNA1000943 | 15623 | 241 | 2.452381 | 5.91023821 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 146 | 1.5e-38 | NR | YP_009508104.1 | 607716 | g15485 | i0 | 90 | 0.995850622406639 | 80 | 8 | 99.6 | 0 | 2 | 241 | 912 | 991 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 240 | 146 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 27792646 | 27792646 | PRJNA1000943_P_NODE_2524_length_481_cov_1.786765_g2387_i0 | PRJNA1000943 | 2524 | 481 | 1.786765 | 8.59433965 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 179 | 4.96e-49 | NR | YP_009508103.1 | 607716 | g2387 | i0 | 71.3 | 0.804573804573805 | 129 | 37 | 80.5 | 0 | 94 | 480 | 1 | 129 | YP_009508103.1 hypothetical protein [Alphachrysovirus aspergilli] | diamond | 387 | 179 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 28739752 | 28739752 | PRJNA1000943_P_NODE_12107_length_250_cov_1.107345_g11969_i0 | PRJNA1000943 | 12107 | 250 | 1.107345 | 2.7683625 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 130 | 7.55e-33 | NR | YP_009508103.1 | 607716 | g11969 | i0 | 76.8 | 0.984 | 82 | 19 | 98.4 | 0 | 248 | 3 | 178 | 259 | YP_009508103.1 hypothetical protein [Alphachrysovirus aspergilli] | diamond | 246 | 130 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 29024290 | 29024290 | PRJNA1000943_P_NODE_4248_length_381_cov_4.146104_g4111_i0 | PRJNA1000943 | 4248 | 381 | 4.146104 | 15.79665624 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 158 | 4.79e-42 | NR | YP_009508104.1 | 607716 | g4111 | i0 | 88.9 | 0.708661417322835 | 90 | 9 | 70.9 | 1 | 111 | 380 | 1 | 89 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 270 | 158 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 29654974 | 29654974 | PRJNA1000943_P_NODE_1590_length_602_cov_2.897921_g1455_i0 | PRJNA1000943 | 1590 | 602 | 2.897921 | 17.44548442 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 376 | 4.21e-120 | NR | YP_009508104.1 | 607716 | g1455 | i0 | 87.5 | 0.996677740863787 | 200 | 25 | 99.7 | 0 | 1 | 600 | 160 | 359 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 600 | 376 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 30255850 | 30255850 | PRJNA1000943_P_NODE_2632_length_472_cov_1.563910_g2495_i0 | PRJNA1000943 | 2632 | 472 | 1.56391 | 7.3816552 | Henan cystovirus 4 | 2824306 | Viruses | Viruses | 69.3 | 2.25e-10 | NR | QYF49826.1 | 2824306 | g2495 | i0 | 36.4 | 0.819915254237288 | 129 | 78 | 80.1 | 3 | 8 | 385 | 120 | 247 | QYF49826.1 MAG: putative RNA-dependent RNA polymerase [Henan cystovirus 4] | diamond | 387 | 69.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Henan cystovirus 4 | ||
| 30666207 | 30666207 | PRJNA1000943_P_NODE_10173_length_262_cov_4.269841_g10035_i0 | PRJNA1000943 | 10173 | 262 | 4.269841 | 11.18698342 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 171 | 4.5099999999999985e-47 | NR | YP_009508104.1 | 607716 | g10035 | i0 | 94.2 | 0.984732824427481 | 86 | 5 | 98.5 | 0 | 3 | 260 | 94 | 179 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 258 | 171 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 30666217 | 30666217 | PRJNA1000943_P_NODE_4113_length_387_cov_1.824841_g3976_i0 | PRJNA1000943 | 4113 | 387 | 1.824841 | 7.06213467 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 196 | 3.0599999999999992e-55 | NR | YP_009508104.1 | 607716 | g3976 | i0 | 88.1 | 0.844961240310077 | 109 | 13 | 84.5 | 0 | 386 | 60 | 1006 | 1114 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 327 | 196 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 30855805 | 30855805 | PRJNA1000943_P_NODE_3754_length_403_cov_1.769697_g3617_i0 | PRJNA1000943 | 3754 | 403 | 1.769697 | 7.13187891 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 242 | 1.73e-72 | NR | YP_009508106.1 | 607716 | g3617 | i0 | 89.6 | 0.997518610421836 | 134 | 14 | 99.8 | 0 | 403 | 2 | 80 | 213 | YP_009508106.1 hypothetical protein [Alphachrysovirus aspergilli] | diamond | 402 | 242 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 31481010 | 31481010 | PRJNA1000943_P_NODE_14096_length_245_cov_0.906977_g13958_i0 | PRJNA1000943 | 14096 | 245 | 0.906977 | 2.22209365 | Cystovirus | 10878 | Viruses | Viruses | 89 | 6e-19 | NR | UNI73394.1 | 2917704 | g13958 | i0 | 52.5 | 1.95918367346939 | 80 | 38 | 98 | 0 | 245 | 6 | 94 | 173 | UNI73394.1 NTPase [Pseudomonas phage ER16] | diamond | 480 | 89 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 | |||
| 31835777 | 31835777 | PRJNA1000943_P_NODE_1017_length_740_cov_3.128936_g891_i0 | PRJNA1000943 | 1017 | 740 | 3.128936 | 23.1541264 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 470 | 1.91e-155 | NR | YP_009508104.1 | 607716 | g891 | i0 | 91.5 | 0.997297297297297 | 246 | 21 | 99.7 | 0 | 740 | 3 | 481 | 726 | YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli] | diamond | 738 | 470 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli |
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);;