contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_kingdom = "Sangervirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13892643 | 13892643 | PRJNA591000_P_NODE_13731_length_398_cov_1.032520_g12139_i0 | PRJNA591000 | 13731 | 398 | 1.03252 | 4.1094296 | Apis mellifera associated microvirus 49 | 2494779 | Viruses | Viruses | 65.1 | 3e-9 | NR | AZL82871.1 | 2494779 | g12139 | i0 | 88.2 | 0.256281407035176 | 34 | 4 | 25.6 | 0 | 15 | 116 | 109 | 142 | AZL82871.1 major capsid protein [Apis mellifera associated microvirus 49] | diamond | 102 | 65.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Apis mellifera associated microvirus 49 | |||
| 15867598 | 15867598 | PRJNA591000_P_NODE_1533_length_990_cov_2.849116_g1098_i0 | PRJNA591000 | 1533 | 990 | 2.849116 | 28.2062484 | Microvirus sp. | 2202559 | Viruses | Viruses | 119 | 1.95e-29 | NR | WNK14253.1 | 2202559 | g1098 | i0 | 60.4 | 0.336363636363636 | 111 | 40 | 32.7 | 2 | 135 | 458 | 1 | 110 | WNK14253.1 MAG: hypothetical protein [Microvirus sp.] | diamond | 333 | 119 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 19691327 | 19691327 | PRJNA591000_P_NODE_6476_length_557_cov_18.948864_g5128_i0 | PRJNA591000 | 6476 | 557 | 18.948864 | 105.54517248 | Microviridae sp. | 2202644 | Viruses | Viruses | 147 | 2.31e-41 | NR | AXH75173.1 | 2202644 | g5128 | i0 | 56.6 | 0.694793536804309 | 129 | 55 | 68.9 | 1 | 438 | 55 | 22 | 150 | AXH75173.1 MAG: internal scaffolding protein [Microviridae sp.] | diamond | 387 | 147 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 27504141 | 27504141 | PRJNA591000_P_NODE_12823_length_408_cov_4.609499_g11235_i0 | PRJNA591000 | 12823 | 408 | 4.609499 | 18.80675592 | Viruses | 10239 | Viruses | Viruses | 52.4 | 4.96e-5 | NR | QJB20402.1 | 2202559 | g11235 | i0 | 45.1 | 1.26470588235294 | 82 | 43 | 58.8 | 1 | 1 | 240 | 56 | 137 | QJB20402.1 MAG: DNA pilot protein [Microvirus sp.] | diamond | 516 | 52.4 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 28027344 | 28027344 | PRJNA591000_P_NODE_8565_length_475_cov_2.441704_g7038_i0 | PRJNA591000 | 8565 | 475 | 2.441704 | 11.598094 | Arizlama microvirus | 2859450 | Viruses | Viruses | 127 | 4.48e-34 | NR | QXP08616.1 | 2859450 | g7038 | i0 | 68.7 | 0.524210526315789 | 83 | 26 | 52.4 | 0 | 469 | 221 | 17 | 99 | QXP08616.1 MAG: internal scaffolding protein [Arizlama microvirus] | diamond | 249 | 127 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 29808724 | 29808724 | PRJNA591000_P_NODE_14231_length_392_cov_0.975207_g12633_i0 | PRJNA591000 | 14231 | 392 | 0.975207 | 3.82281144 | Viruses | 10239 | Viruses | Viruses | 61.6 | 4.64e-8 | NR | UXQ88017.1 | 2202559 | g12633 | i0 | 92.9 | 1.69132653061224 | 28 | 2 | 21.4 | 0 | 307 | 390 | 406 | 433 | UXQ88017.1 MAG: major capsid protein [Microvirus sp.] | diamond | 663 | 62 | 0.993548387096774 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 30237677 | 30237677 | PRJNA591000_P_NODE_5832_length_598_cov_1.977153_g4598_i0 | PRJNA591000 | 5832 | 598 | 1.977153 | 11.82337494 | Microviridae sp. | 2202644 | Viruses | Viruses | 63.5 | 6.01e-8 | NR | DAZ92347.1 | 2202644 | g4598 | i0 | 59.1 | 0.220735785953177 | 44 | 18 | 22.1 | 0 | 390 | 521 | 224 | 267 | DAZ92347.1 TPA_asm: major capsid protein [Microviridae sp.] | diamond | 132 | 63.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae 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);;