contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_phylum = "Phixviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4445691 | 4445691 | PRJNA642647_P_NODE_4884_length_166_cov_3.527132_g4834_i0 | PRJNA642647 | 4884 | 166 | 3.527132 | 5.85503912 | Viruses | 10239 | Viruses | Viruses | 77.8 | 5.76e-15 | NR | XOF05518.1 | 2202644 | g4834 | i0 | 82.4 | 3.6144578313253 | 51 | 9 | 92.2 | 0 | 154 | 2 | 248 | 298 | XOF05518.1 MAG: major head protein [Microviridae sp.] | diamond | 600 | 78.2 | 0.994884910485933 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5721502 | 5721502 | PRJNA642647_P_NODE_1785_length_259_cov_4.671171_g1735_i0 | PRJNA642647 | 1785 | 259 | 4.671171 | 12.09833289 | Microvirus sp. | 2202559 | Viruses | Viruses | 177 | 5.56e-51 | NR | QJB19464.1 | 2202559 | g1735 | i0 | 91.8 | 1.96911196911197 | 85 | 7 | 98.5 | 0 | 257 | 3 | 47 | 131 | QJB19464.1 MAG: major capsid protein [Microvirus sp.] | diamond | 510 | 177 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 10822250 | 10822250 | PRJNA642647_P_NODE_889_length_375_cov_3.869822_g839_i0 | PRJNA642647 | 889 | 375 | 3.869822 | 14.5118325 | Microviridae sp. | 2202644 | Viruses | Viruses | 105 | 4.46e-25 | NR | AXH76778.1 | 2202644 | g839 | i0 | 76.5 | 1.016 | 68 | 16 | 54.4 | 0 | 207 | 4 | 1 | 68 | AXH76778.1 MAG: DNA pilot protein [Microviridae sp.] | diamond | 381 | 105 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 13372012 | 13372012 | PRJNA642647_P_NODE_2991_length_202_cov_2.933333_g2941_i0 | PRJNA642647 | 2991 | 202 | 2.933333 | 5.92533266 | Microviridae sp. | 2202644 | Viruses | Viruses | 135 | 4.26e-37 | NR | AXH76776.1 | 2202644 | g2941 | i0 | 89.4 | 0.98019801980198 | 66 | 7 | 98 | 0 | 200 | 3 | 88 | 153 | AXH76776.1 MAG: replication initiator protein [Microviridae sp.] | diamond | 198 | 135 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 27808012 | 27808012 | PRJNA642647_P_NODE_4924_length_166_cov_3.279070_g4874_i0 | PRJNA642647 | 4924 | 166 | 3.27907 | 5.4432562 | Microvirus sp. | 2202559 | Viruses | Viruses | 73.6 | 1.71e-13 | NR | QJB18954.1 | 2202559 | g4874 | i0 | 55.6 | 1.30120481927711 | 72 | 14 | 97.6 | 1 | 164 | 3 | 268 | 339 | QJB18954.1 MAG: major capsid protein [Microvirus sp.] | diamond | 216 | 73.6 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 27851510 | 27851510 | PRJNA642647_P_NODE_884_length_376_cov_12.035398_g834_i0 | PRJNA642647 | 884 | 376 | 12.035398 | 45.25309648 | Viruses | 10239 | Viruses | Viruses | 124 | 2.06e-30 | NR | QJB19464.1 | 2202559 | g834 | i0 | 84.1 | 1.10106382978723 | 69 | 11 | 55.1 | 0 | 375 | 169 | 467 | 535 | QJB19464.1 MAG: major capsid protein [Microvirus sp.] | diamond | 414 | 124 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 28849549 | 28849549 | PRJNA642647_P_NODE_3988_length_180_cov_2.580420_g3938_i0 | PRJNA642647 | 3988 | 180 | 2.58042 | 4.644756 | Microviridae sp. | 2202644 | Viruses | Viruses | 62 | 1.71e-10 | NR | DAZ92351.1 | 2202644 | g3938 | i0 | 69.8 | 0.883333333333333 | 53 | 16 | 88.3 | 0 | 176 | 18 | 3 | 55 | DAZ92351.1 TPA_asm: hypothetical protein [Microviridae sp.] | diamond | 159 | 62 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 28912622 | 28912622 | PRJNA642647_P_NODE_3768_length_184_cov_2.190476_g3718_i0 | PRJNA642647 | 3768 | 184 | 2.190476 | 4.03047584 | Microvirus sp. | 2202559 | Viruses | Viruses | 75.1 | 6.64e-14 | NR | QJB21554.1 | 2202559 | g3718 | i0 | 74.5 | 0.766304347826087 | 47 | 12 | 76.6 | 0 | 142 | 2 | 1 | 47 | QJB21554.1 MAG: major capsid protein [Microvirus sp.] | diamond | 141 | 75.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 29039427 | 29039427 | PRJNA642647_P_NODE_2468_length_220_cov_1.240437_g2418_i0 | PRJNA642647 | 2468 | 220 | 1.240437 | 2.7289614 | Microviridae sp. | 2202644 | Viruses | Viruses | 115 | 2.06e-29 | NR | XOF05523.1 | 2202644 | g2418 | i0 | 81.9 | 0.981818181818182 | 72 | 13 | 98.2 | 0 | 219 | 4 | 10 | 81 | XOF05523.1 MAG: minor tail protein, partial [Microviridae sp.] | diamond | 216 | 115 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29607120 | 29607120 | PRJNA642647_P_NODE_1650_length_270_cov_2.339056_g1600_i0 | PRJNA642647 | 1650 | 270 | 2.339056 | 6.3154512 | Microviridae sp. | 2202644 | Viruses | Viruses | 112 | 8.39e-27 | NR | DAZ92347.1 | 2202644 | g1600 | i0 | 75.3 | 0.811111111111111 | 73 | 6 | 67.8 | 1 | 86 | 268 | 1 | 73 | DAZ92347.1 TPA_asm: major capsid protein [Microviridae sp.] | diamond | 219 | 112 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29891883 | 29891883 | PRJNA642647_P_NODE_5891_length_157_cov_1.650000_g5841_i0 | PRJNA642647 | 5891 | 157 | 1.65 | 2.5905 | Microviridae sp. | 2202644 | Viruses | Viruses | 49.7 | 4.14e-5 | NR | QRQ90102.1 | 2202644 | g5841 | i0 | 52.2 | 0.878980891719745 | 46 | 22 | 87.9 | 0 | 154 | 17 | 208 | 253 | QRQ90102.1 MAG: major capsid protein [Microviridae sp.] | diamond | 138 | 49.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 30124934 | 30124934 | PRJNA642647_P_NODE_2892_length_205_cov_3.315476_g2842_i0 | PRJNA642647 | 2892 | 205 | 3.315476 | 6.7967258 | Viruses | 10239 | Viruses | Viruses | 122 | 1.08e-30 | NR | QJB19548.1 | 2202559 | g2842 | i0 | 88.1 | 1.9609756097561 | 67 | 8 | 98 | 0 | 201 | 1 | 100 | 166 | QJB19548.1 MAG: major capsid protein [Microvirus sp.] | diamond | 402 | 122 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 30871132 | 30871132 | PRJNA642647_P_NODE_3634_length_186_cov_3.583893_g3584_i0 | PRJNA642647 | 3634 | 186 | 3.583893 | 6.66604098 | Microviridae sp. | 2202644 | Viruses | Viruses | 62 | 2.11e-9 | NR | XOF05520.1 | 2202644 | g3584 | i0 | 90.6 | 1.03225806451613 | 32 | 3 | 51.6 | 0 | 184 | 89 | 153 | 184 | XOF05520.1 MAG: replication initiation protein [Microviridae sp.] | diamond | 192 | 62 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 32072806 | 32072806 | PRJNA642647_P_NODE_3058_length_200_cov_4.889571_g3008_i0 | PRJNA642647 | 3058 | 200 | 4.889571 | 9.779142 | Microvirus sp. | 2202559 | Viruses | Viruses | 55.1 | 9.32e-7 | NR | QJB19381.1 | 2202559 | g3008 | i0 | 83.3 | 0.45 | 30 | 5 | 45 | 0 | 3 | 92 | 203 | 232 | QJB19381.1 MAG: major capsid protein [Microvirus sp.] | diamond | 90 | 55.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 32262902 | 32262902 | PRJNA642647_P_NODE_3478_length_190_cov_1.013072_g3428_i0 | PRJNA642647 | 3478 | 190 | 1.013072 | 1.9248368 | Arizlama microvirus | 2859450 | Viruses | Viruses | 127 | 2.18e-32 | NR | QXP08673.1 | 2859450 | g3428 | i0 | 90.3 | 0.978947368421053 | 62 | 6 | 97.9 | 0 | 4 | 189 | 413 | 474 | QXP08673.1 MAG: major capsid protein [Arizlama microvirus] | diamond | 186 | 127 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus |
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);;