contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA382357" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27233183 | 27233183 | PRJNA382357_P_NODE_84463_length_261_cov_0.960000_g83724_i0 | PRJNA382357 | 84463 | 261 | 0.96 | 2.5056 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 127 | 5.909999999999999e-32 | NR | QHA94750.1 | 1774276 | g83724 | i0 | 73.3 | 0.988505747126437 | 86 | 23 | 98.9 | 0 | 3 | 260 | 4197 | 4282 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 258 | 127 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 27517468 | 27517468 | PRJNA382357_P_NODE_23043_length_463_cov_12.500000_g22307_i0 | PRJNA382357 | 23043 | 463 | 12.5 | 57.875 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 80.1 | 4.15e-14 | NR | QHA94750.1 | 1774276 | g22307 | i0 | 34.1 | 0.816414686825054 | 126 | 81 | 81 | 2 | 89 | 463 | 3584 | 3708 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 378 | 80.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 28338406 | 28338406 | PRJNA382357_P_NODE_157526_length_200_cov_2.021583_g156787_i0 | PRJNA382357 | 157526 | 200 | 2.021583 | 4.043166 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 67.4 | 4.33e-11 | NR | QHA94750.1 | 1774276 | g156787 | i0 | 49.2 | 0.975 | 65 | 31 | 96 | 2 | 1 | 192 | 3570 | 3633 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 195 | 67.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 28338432 | 28338432 | PRJNA382357_P_NODE_41766_length_355_cov_27.700680_g41027_i0 | PRJNA382357 | 41766 | 355 | 27.70068 | 98.337414 | Garlic virus E | 150285 | Viruses | Viruses | 149 | 4.45e-39 | NR | NP_659010.1 | 150285 | g41027 | i0 | 81.9 | 0.794366197183099 | 94 | 17 | 79.4 | 0 | 283 | 2 | 550 | 643 | NP_659010.1 hypothetical protein GvEgp1 [Garlic virus E] | diamond | 282 | 149 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus epsalii | ||
| 28938430 | 28938430 | PRJNA382357_P_NODE_6008_length_815_cov_2.192308_g5368_i0 | PRJNA382357 | 6008 | 815 | 2.192308 | 17.8673102 | Grapevine wood holobiome associated deltaflexivirus 2 | 3384488 | Viruses | Viruses | 48.9 | 0.00569 | NR | XLE34830.1 | 3384488 | g5368 | i0 | 31.8 | 0.323926380368098 | 88 | 60 | 32.4 | 0 | 438 | 701 | 110 | 197 | XLE34830.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] | diamond | 264 | 48.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Grapevine wood holobiome associated deltaflexivirus 2 | ||
| 29001833 | 29001833 | PRJNA382357_P_NODE_169508_length_173_cov_4.383929_g168769_i0 | PRJNA382357 | 169508 | 173 | 4.383929 | 7.58419717 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 45.4 | 0.00166 | NR | QHA94750.1 | 1774276 | g168769 | i0 | 62.1 | 0.502890173410405 | 29 | 11 | 50.3 | 0 | 3 | 89 | 350 | 378 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 87 | 45.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 30548979 | 30548979 | PRJNA382357_P_NODE_3433_length_1024_cov_4.011423_g2887_i0 | PRJNA382357 | 3433 | 1024 | 4.011423 | 41.07697152 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 51.2 | 0.00708 | NR | QHA94750.1 | 1774276 | g2887 | i0 | 52.5 | 0.1171875 | 40 | 19 | 11.7 | 0 | 496 | 615 | 3513 | 3552 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 120 | 51.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 30959849 | 30959849 | PRJNA382357_P_NODE_59174_length_305_cov_1.024590_g58435_i0 | PRJNA382357 | 59174 | 305 | 1.02459 | 3.1249995 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 152 | 2.58e-40 | NR | QHA94750.1 | 1774276 | g58435 | i0 | 74.7 | 0.895081967213115 | 91 | 23 | 89.5 | 0 | 32 | 304 | 2655 | 2745 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 273 | 152 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei | ||
| 31623669 | 31623669 | PRJNA382357_P_NODE_42956_length_351_cov_3.527586_g42217_i0 | PRJNA382357 | 42956 | 351 | 3.527586 | 12.38182686 | Hordeum vulgare alphaendornavirus | 1774276 | Viruses | Viruses | 99.4 | 1.95e-21 | NR | QHA94750.1 | 1774276 | g42217 | i0 | 71.7 | 0.512820512820513 | 60 | 17 | 51.3 | 0 | 2 | 181 | 2673 | 2732 | QHA94750.1 polyprotein [Hordeum vulgare alphaendornavirus] | diamond | 180 | 99.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus hordei |
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);;