contig_metadata
12 rows where bioproject = "PRJNA800053", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3347210 | 3347210 | PRJNA800053_P_NODE_16603_length_255_cov_1.637363_g16439_i0 | PRJNA800053 | 16603 | 255 | 1.637363 | 4.17527565 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 453 | 5.44e-123 | NTclustered | gi|2594385161|gb|OL695912.1| | 12305 | g16439 | i0 | 99.206 | 96.9372549019608 | 252 | 1 | 98 | 1 | 4 | 254 | 129 | 380 | Cucumber mosaic virus isolate ZARCu coat protein gene, complete cds | blastn | 24719 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 7174499 | 7174499 | PRJNA800053_P_NODE_15766_length_260_cov_2.326203_g15602_i0 | PRJNA800053 | 15766 | 260 | 2.326203 | 6.0481278 | Tolivirales sp. | 2809914 | Viruses | Viruses | 468 | 1.99e-127 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g15602 | i0 | 99.609 | 0.984615384615385 | 256 | 1 | 98 | 0 | 4 | 259 | 646 | 901 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 256 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 21198689 | 21198689 | PRJNA800053_P_NODE_3537_length_470_cov_3.866499_g3374_i0 | PRJNA800053 | 3537 | 470 | 3.866499 | 18.1725453 | Tolivirales sp. | 2809914 | Viruses | Viruses | 227 | 7.729999999999999e-66 | NR | WRQ65272.1 | 2809914 | g3374 | i0 | 66.5 | 0.98936170212766 | 155 | 52 | 98.9 | 0 | 467 | 3 | 98 | 252 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 465 | 227 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28412181 | 28412181 | PRJNA800053_P_NODE_4586_length_420_cov_3.293948_g4423_i0 | PRJNA800053 | 4586 | 420 | 3.293948 | 13.8345816 | Tolivirales sp. | 2809914 | Viruses | Viruses | 197 | 1.6199999999999995e-55 | NR | WRQ65272.1 | 2809914 | g4423 | i0 | 68.8 | 0.985714285714286 | 138 | 32 | 98.6 | 1 | 5 | 418 | 451 | 577 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 414 | 197 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28696460 | 28696460 | PRJNA800053_P_NODE_7827_length_339_cov_2.563910_g7663_i0 | PRJNA800053 | 7827 | 339 | 2.56391 | 8.6916549 | Skomarfal virus 4 | 3063437 | Viruses | Viruses | 53.1 | 2.51e-5 | NR | WPR18392.1 | 3063109 | g7663 | i0 | 34.5 | 0.743362831858407 | 84 | 54 | 73.5 | 1 | 250 | 2 | 546 | 629 | WPR18392.1 MAG: hypothetical protein, partial [Skomarfal virus 40] | diamond | 252 | 53.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skomarfal virus 40 | |||
| 29517049 | 29517049 | PRJNA800053_P_NODE_25230_length_204_cov_5.656489_g25066_i0 | PRJNA800053 | 25230 | 204 | 5.656489 | 11.53923756 | Tolivirales sp. | 2809914 | Viruses | Viruses | 105 | 1.07e-24 | NR | WRQ64995.1 | 2809914 | g25066 | i0 | 70.3 | 1.88235294117647 | 64 | 19 | 94.1 | 0 | 12 | 203 | 1 | 64 | WRQ64995.1 structural protein [Tolivirales sp.] | diamond | 384 | 105 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29737950 | 29737950 | PRJNA800053_P_NODE_16710_length_254_cov_2.817680_g16546_i0 | PRJNA800053 | 16710 | 254 | 2.81768 | 7.1569072 | Tolivirales sp. | 2809914 | Viruses | Viruses | 117 | 1.72e-28 | NR | WRQ65272.1 | 2809914 | g16546 | i0 | 66.3 | 0.980314960629921 | 83 | 24 | 98 | 1 | 5 | 253 | 249 | 327 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 249 | 117 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29864496 | 29864496 | PRJNA800053_P_NODE_12591_length_282_cov_4.110048_g12427_i0 | PRJNA800053 | 12591 | 282 | 4.110048 | 11.59033536 | Tolivirales sp. | 2809914 | Viruses | Viruses | 120 | 2.95e-29 | NR | WRQ65272.1 | 2809914 | g12427 | i0 | 59.1 | 0.98936170212766 | 93 | 38 | 98.9 | 0 | 4 | 282 | 702 | 794 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 279 | 120 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30527933 | 30527933 | PRJNA800053_P_NODE_10113_length_306_cov_2.841202_g9949_i0 | PRJNA800053 | 10113 | 306 | 2.841202 | 8.69407812 | Tolivirales sp. | 2809914 | Viruses | Viruses | 138 | 2.44e-35 | NR | WRQ65272.1 | 2809914 | g9949 | i0 | 65.3 | 0.990196078431373 | 101 | 35 | 99 | 0 | 304 | 2 | 902 | 1002 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 303 | 138 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 31065371 | 31065371 | PRJNA800053_P_NODE_11635_length_290_cov_1.783410_g11471_i0 | PRJNA800053 | 11635 | 290 | 1.78341 | 5.171889 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 68.2 | 7.6e-11 | NR | XKB76524.1 | 2809606 | g11471 | i0 | 41.9 | 0.76551724137931 | 74 | 43 | 76.6 | 0 | 4 | 225 | 850 | 923 | XKB76524.1 MAG: methyltransferase, partial [Nodamuvirales sp.] | diamond | 222 | 68.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 32330678 | 32330678 | PRJNA800053_P_NODE_9159_length_318_cov_2.693878_g8995_i0 | PRJNA800053 | 9159 | 318 | 2.693878 | 8.56653204 | Tolivirales sp. | 2809914 | Viruses | Viruses | 76.3 | 1.35e-13 | NR | WRQ65316.1 | 2809914 | g8995 | i0 | 40 | 0.990566037735849 | 105 | 63 | 99.1 | 0 | 316 | 2 | 48 | 152 | WRQ65316.1 structural protein [Tolivirales sp.] | diamond | 315 | 76.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 32362248 | 32362248 | PRJNA800053_P_NODE_24259_length_237_cov_3.408537_g24095_i0 | PRJNA800053 | 24259 | 237 | 3.408537 | 8.07823269 | Tolivirales sp. | 2809914 | Viruses | Viruses | 102 | 4.64e-23 | NR | WRQ65272.1 | 2809914 | g24095 | i0 | 64 | 0.949367088607595 | 75 | 27 | 94.9 | 0 | 5 | 229 | 565 | 639 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 225 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. |
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);;