contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2994367 | 2994367 | PRJNA473201_P_NODE_33623_length_342_cov_1.211896_g32881_i0 | PRJNA473201 | 33623 | 342 | 1.211896 | 4.14468432 | Crogonang virus 66 | 3063073 | Viruses | Viruses | 189 | 3.23e-53 | NR | WPR18337.1 | 3063073 | g32881 | i0 | 87.6 | 2.97368421052632 | 113 | 12 | 99.1 | 1 | 340 | 2 | 517 | 627 | WPR18337.1 MAG: capsid protein, partial [Crogonang virus 66] | diamond | 1017 | 189 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 66 | ||||
| 2994587 | 2994587 | PRJNA473201_P_NODE_4623_length_942_cov_3.852704_g4069_i0 | PRJNA473201 | 4623 | 942 | 3.852704 | 36.29247168 | Carlavirus | 12163 | Viruses | Viruses | 481 | 1.4299999999999995e-152 | NR | WVI61735.1 | 2982810 | g4069 | i0 | 77.2 | 7.92356687898089 | 311 | 71 | 99 | 0 | 941 | 9 | 1491 | 1801 | WVI61735.1 replicase [Pseudostellaria heterophylla carlavirus 1] | diamond | 7464 | 484 | 0.993801652892562 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae | ||
| 10647550 | 10647550 | PRJNA473201_P_NODE_349_length_2422_cov_4.818646_g281_i0 | PRJNA473201 | 349 | 2422 | 4.818646 | 116.70760612 | Carlavirus | 12163 | Viruses | Viruses | 416 | 3e-136 | NR | QQG34557.1 | 2794422 | g281 | i0 | 75.4 | 0.636663914120562 | 256 | 63 | 31.7 | 0 | 1123 | 356 | 40 | 295 | QQG34557.1 CP [Tagetes carlavirus 1] | diamond | 1542 | 419 | 0.992840095465394 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Tagetes carlavirus 1 | ||
| 10648494 | 10648494 | PRJNA473201_P_NODE_8589_length_692_cov_4.555735_g7881_i0 | PRJNA473201 | 8589 | 692 | 4.555735 | 31.5256862 | Carlavirus | 12163 | Viruses | Viruses | 408 | 1.54e-138 | NR | QQX32722.1 | 12171 | g7881 | i0 | 87.4 | 11.6054913294798 | 222 | 28 | 96.2 | 0 | 692 | 27 | 293 | 514 | QQX32722.1 replicase, partial [Helenium virus S] | diamond | 8031 | 408 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmahelenii | ||
| 20845021 | 20845021 | PRJNA473201_P_NODE_1537_length_1507_cov_2.529986_g1274_i0 | PRJNA473201 | 1537 | 1507 | 2.529986 | 38.12688902 | Gaillardia latent virus | 1468172 | Viruses | Viruses | 438 | 6.54e-134 | NR | YP_009022064.1 | 1468172 | g1274 | i0 | 46.9 | 5.91838088918381 | 501 | 251 | 99.7 | 3 | 5 | 1507 | 967 | 1452 | YP_009022064.1 replicase [Gaillardia latent virus] | diamond | 8919 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensgaillardiae | ||
| 26696200 | 26696200 | PRJNA473201_P_NODE_16441_length_491_cov_2.050239_g15700_i0 | PRJNA473201 | 16441 | 491 | 2.050239 | 10.06667349 | Phage DSL-LC | 3058958 | Viruses | Viruses | 48.9 | 8.18e-4 | NR | WJZ48090.1 | 3058958 | g15700 | i0 | 32.1 | 0.476578411405295 | 78 | 49 | 47.7 | 1 | 420 | 187 | 7 | 80 | WJZ48090.1 hypothetical protein [Phage DSL-LC04] | diamond | 234 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phage DSL-LC04 | |||||
| 26981188 | 26981188 | PRJNA473201_P_NODE_40202_length_315_cov_34.024793_g39460_i0 | PRJNA473201 | 40202 | 315 | 34.024793 | 107.17809795 | Escherichia phage D2 | 2915331 | Viruses | Viruses | 79.7 | 4.26e-17 | NR | ULG00791.1 | 2915331 | g39460 | i0 | 53.3 | 0.714285714285714 | 75 | 35 | 71.4 | 0 | 4 | 228 | 6 | 80 | ULG00791.1 hypothetical protein, partial [Escherichia phage D2] | diamond | 225 | 79.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bievrevirus | Escherichia phage D2 | ||||
| 27392393 | 27392393 | PRJNA473201_P_NODE_54583_length_280_cov_10.096618_g53841_i0 | PRJNA473201 | 54583 | 280 | 10.096618 | 28.2705304 | Escherichia Stx1 converting phage | 194948 | Viruses | Viruses | 55.1 | 1.77e-7 | NR | NP_859240.1 | 194948 | g53841 | i0 | 71.1 | 0.407142857142857 | 38 | 11 | 40.7 | 0 | 150 | 263 | 9 | 46 | NP_859240.1 hypothetical protein Stx1_p161 [Escherichia Stx1 converting phage] | diamond | 114 | 55.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Traversvirus | Escherichia Stx1 converting phage | ||||
| 27613412 | 27613412 | PRJNA473201_P_NODE_6824_length_781_cov_3.644068_g6171_i0 | PRJNA473201 | 6824 | 781 | 3.644068 | 28.46017108 | Helenium virus S | 12171 | Viruses | Viruses | 202 | 3.489999999999999e-55 | NR | QQX32705.1 | 12171 | g6171 | i0 | 46.2 | 0.814340588988476 | 212 | 106 | 81.4 | 3 | 642 | 7 | 595 | 798 | QQX32705.1 replicase, partial [Helenium virus S] | diamond | 636 | 202 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmahelenii | ||
| 29223727 | 29223727 | PRJNA473201_P_NODE_70229_length_249_cov_0.875000_g69487_i0 | PRJNA473201 | 70229 | 249 | 0.875 | 2.17875 | Solumvirus sp. | 2487773 | Viruses | Viruses | 44.7 | 0.00688 | NR | AYV86227.1 | 2487773 | g69487 | i0 | 52.4 | 0.506024096385542 | 42 | 20 | 50.6 | 0 | 121 | 246 | 42 | 83 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 126 | 44.7 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 29349911 | 29349911 | PRJNA473201_P_NODE_47789_length_297_cov_1.165179_g47047_i0 | PRJNA473201 | 47789 | 297 | 1.165179 | 3.46058163 | Peony yellowing associated citrivirus | 2800955 | Viruses | Viruses | 172 | 2.989999999999999e-47 | NR | QNN26219.1 | 2800955 | g47047 | i0 | 88.5 | 0.96969696969697 | 96 | 11 | 97 | 0 | 289 | 2 | 1026 | 1121 | QNN26219.1 replicase [Peony yellowing associated citrivirus] | diamond | 288 | 172 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Peony yellowing associated citrivirus | ||
| 29381404 | 29381404 | PRJNA473201_P_NODE_10349_length_629_cov_1.309353_g9617_i0 | PRJNA473201 | 10349 | 629 | 1.309353 | 8.23583037 | Sacri virus | 2744404 | Viruses | Viruses | 132 | 1.2799999999999999e-31 | NR | BCG55387.1 | 2744404 | g9617 | i0 | 41.8 | 0.934817170111288 | 196 | 101 | 92.1 | 6 | 629 | 51 | 540 | 725 | BCG55387.1 capsid protein precursor, partial [Sacri virus] | diamond | 588 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sacri virus | |||
| 29507634 | 29507634 | PRJNA473201_P_NODE_76610_length_245_cov_34.837209_g75868_i0 | PRJNA473201 | 76610 | 245 | 34.837209 | 85.35116205 | Wheat rosette stunt virus | 75890 | Viruses | Viruses | 59.3 | 5.28e-8 | NR | AAF28467.1 | 75890 | g75868 | i0 | 71.9 | 0.391836734693878 | 32 | 9 | 39.2 | 0 | 157 | 62 | 370 | 401 | AAF28467.1 nucleocapsid protein, partial [Wheat rosette stunt virus] | diamond | 96 | 59.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Wheat rosette stunt virus | |||
| 29760126 | 29760126 | PRJNA473201_P_NODE_13611_length_543_cov_1.261702_g12872_i0 | PRJNA473201 | 13611 | 543 | 1.261702 | 6.85104186 | Pseudostellaria heterophylla carlavirus 1 | 2982810 | Viruses | Viruses | 256 | 2.75e-75 | NR | WVI61735.1 | 2982810 | g12872 | i0 | 73.9 | 1.8232044198895 | 165 | 43 | 91.2 | 0 | 497 | 3 | 1 | 165 | WVI61735.1 replicase [Pseudostellaria heterophylla carlavirus 1] | diamond | 990 | 256 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae | ||
| 29981407 | 29981407 | PRJNA473201_P_NODE_62031_length_261_cov_1.026596_g61289_i0 | PRJNA473201 | 62031 | 261 | 1.026596 | 2.67941556 | Microbacterium phage PauloDiaboli | 2704039 | Viruses | Viruses | 99 | 6.9899999999999995e-25 | NR | QIG57849.1 | 2704039 | g61289 | i0 | 60 | 2.4367816091954 | 70 | 28 | 80.5 | 0 | 257 | 48 | 20 | 89 | QIG57849.1 hypothetical protein SEA_PAULODIABOLI_115 [Microbacterium phage PauloDiaboli] | diamond | 636 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage PauloDiaboli | |||||
| 30266028 | 30266028 | PRJNA473201_P_NODE_21912_length_421_cov_23.112069_g21170_i0 | PRJNA473201 | 21912 | 421 | 23.112069 | 97.30181049 | Lambdavirus lambda | 10710 | Viruses | Viruses | 68.6 | 2.92e-12 | NR | 8DSB_A | 10710 | g21170 | i0 | 47.5 | 0.869358669833729 | 61 | 32 | 43.5 | 0 | 419 | 237 | 17 | 77 | 8DSB_A Chain A, Xis (Excision72) [Lambdavirus lambda] | diamond | 366 | 68.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 30282289 | 30282289 | PRJNA473201_P_NODE_16392_length_492_cov_1.451074_g15651_i0 | PRJNA473201 | 16392 | 492 | 1.451074 | 7.13928408 | Citrivirus | 699166 | Viruses | Viruses | 335 | 2.61e-103 | NR | QAT18645.1 | 2507947 | g15651 | i0 | 97.5 | 2.98170731707317 | 163 | 4 | 99.4 | 0 | 3 | 491 | 1726 | 1888 | QAT18645.1 replicase polyprotein [Citrus leaf blotch virus Ac] | diamond | 1467 | 335 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrus leaf blotch virus Ac | |||
| 30518493 | 30518493 | PRJNA473201_P_NODE_50753_length_290_cov_1.322581_g50011_i0 | PRJNA473201 | 50753 | 290 | 1.322581 | 3.8354849 | Pseudostellaria heterophylla carlavirus 1 | 2982810 | Viruses | Viruses | 171 | 6.98e-47 | NR | WVI61735.1 | 2982810 | g50011 | i0 | 84.4 | 3.97241379310345 | 96 | 15 | 99.3 | 0 | 2 | 289 | 268 | 363 | WVI61735.1 replicase [Pseudostellaria heterophylla carlavirus 1] | diamond | 1152 | 171 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae | ||
| 30565946 | 30565946 | PRJNA473201_P_NODE_73993_length_247_cov_0.885057_g73251_i0 | PRJNA473201 | 73993 | 247 | 0.885057 | 2.18609079 | Viruses | 10239 | Viruses | Viruses | 95.9 | 8.02e-21 | NR | QRI44262.1 | 2715102 | g73251 | i0 | 61.3 | 2.73279352226721 | 75 | 29 | 91.1 | 0 | 225 | 1 | 478 | 552 | QRI44262.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] | diamond | 675 | 96.7 | 0.991726990692865 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Marnaviridae sp. | |||
| 30629290 | 30629290 | PRJNA473201_P_NODE_32213_length_349_cov_1.097826_g31471_i0 | PRJNA473201 | 32213 | 349 | 1.097826 | 3.83141274 | Viruses | 10239 | Viruses | Viruses | 122 | 1.38e-29 | NR | URG14668.1 | 1530251 | g31471 | i0 | 71.3 | 2.82808022922636 | 80 | 23 | 68.8 | 0 | 3 | 242 | 675 | 754 | URG14668.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 987 | 123 | 0.991869918699187 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 30992517 | 30992517 | PRJNA473201_P_NODE_48634_length_295_cov_1.378378_g47892_i0 | PRJNA473201 | 48634 | 295 | 1.378378 | 4.0662151 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 94.4 | 5.4e-20 | NR | WLN26256.1 | 3065075 | g47892 | i0 | 45.8 | 0.976271186440678 | 96 | 52 | 97.6 | 0 | 7 | 294 | 129 | 224 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 288 | 94.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31245180 | 31245180 | PRJNA473201_P_NODE_48355_length_295_cov_24.067568_g47613_i0 | PRJNA473201 | 48355 | 295 | 24.067568 | 70.9993256 | Bacteriophage sp. | 38018 | Viruses | Viruses | 57 | 4.01e-8 | NR | DAT85990.1 | 38018 | g47613 | i0 | 57.1 | 1.07796610169492 | 56 | 22 | 54.9 | 1 | 2 | 163 | 3 | 58 | DAT85990.1 MAG TPA: hypothetical protein [Bacteriophage sp.] | diamond | 318 | 57 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 31308422 | 31308422 | PRJNA473201_P_NODE_72715_length_248_cov_0.880000_g71973_i0 | PRJNA473201 | 72715 | 248 | 0.88 | 2.1824 | Homavirus sp. | 2487769 | Viruses | Viruses | 118 | 6.54e-30 | NR | AYV82013.1 | 2487769 | g71973 | i0 | 58.8 | 0.967741935483871 | 80 | 32 | 96.8 | 1 | 8 | 247 | 11 | 89 | AYV82013.1 MAG: packaging ATPase [Homavirus sp.] | diamond | 240 | 118 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 31687991 | 31687991 | PRJNA473201_P_NODE_17337_length_478_cov_1.711111_g16595_i0 | PRJNA473201 | 17337 | 478 | 1.711111 | 8.17911058 | Crogonang virus 66 | 3063073 | Viruses | Viruses | 298 | 8.88e-92 | NR | WPR18337.1 | 3063073 | g16595 | i0 | 89.9 | 0.997907949790795 | 159 | 16 | 99.8 | 0 | 478 | 2 | 731 | 889 | WPR18337.1 MAG: capsid protein, partial [Crogonang virus 66] | diamond | 477 | 298 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 66 | ||||
| 31782785 | 31782785 | PRJNA473201_P_NODE_9837_length_644_cov_27.462347_g2062_i1 | PRJNA473201 | 9837 | 644 | 27.462347 | 176.85751468 | Campylobacter phage CJLB-4 | 2781358 | Viruses | Viruses | 92.4 | 1.66e-20 | NR | QPB10280.1 | 2781358 | g2062 | i1 | 64.4 | 0.340062111801242 | 73 | 26 | 34 | 0 | 478 | 260 | 17 | 89 | QPB10280.1 hypothetical protein [Campylobacter phage CJLB-4] | diamond | 219 | 92.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Campylobacter phage CJLB-4 | ||||
| 32289579 | 32289579 | PRJNA473201_P_NODE_9719_length_648_cov_1.826087_g8992_i0 | PRJNA473201 | 9719 | 648 | 1.826087 | 11.83304376 | Pseudostellaria heterophylla carlavirus 1 | 2982810 | Viruses | Viruses | 108 | 2.6499999999999996e-23 | NR | UXX34097.1 | 2982810 | g8992 | i0 | 32.8 | 1.89814814814815 | 201 | 132 | 92.1 | 3 | 1 | 597 | 394 | 593 | UXX34097.1 replicase [Pseudostellaria heterophylla carlavirus 1] | diamond | 1230 | 108 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae |
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);;