contig_metadata
6 rows where bioproject = "PRJNA1011844", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19282441 | 19282441 | PRJNA1011844_P_NODE_27936_length_1010_cov_5.524013_g21535_i0 | PRJNA1011844 | 27936 | 1010 | 5.524013 | 55.7925313 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 236 | 1.08e-65 | NR | WAY16469.1 | 2809460 | g21535 | i0 | 44.6 | 0.873267326732673 | 294 | 139 | 86.7 | 6 | 917 | 42 | 33 | 304 | WAY16469.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 882 | 236 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 26749471 | 26749471 | PRJNA1011844_P_NODE_25401_length_1080_cov_5.810328_g19391_i0 | PRJNA1011844 | 25401 | 1080 | 5.810328 | 62.7515424 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 149 | 1.77e-35 | NR | WAY16437.1 | 2809460 | g19391 | i0 | 27.8 | 1.08888888888889 | 392 | 235 | 97.8 | 10 | 1064 | 9 | 320 | 703 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 1176 | 149 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27477163 | 27477163 | PRJNA1011844_P_NODE_2543_length_3041_cov_28.172170_g1684_i0 | PRJNA1011844 | 2543 | 3041 | 28.17217 | 856.7156897 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 355 | 4.95e-108 | NR | WAY16471.1 | 2809460 | g1684 | i0 | 43.3 | 0.965800723446235 | 494 | 251 | 47.1 | 8 | 1606 | 176 | 1 | 482 | WAY16471.1 hypothetical protein [Hepelivirales sp.] | diamond | 2937 | 355 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27635183 | 27635183 | PRJNA1011844_P_NODE_23064_length_1149_cov_7.630112_g17442_i0 | PRJNA1011844 | 23064 | 1149 | 7.630112 | 87.66998688 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 142 | 7.180000000000001e-33 | NR | WAY16510.1 | 2809460 | g17442 | i0 | 29.1 | 3.06266318537859 | 385 | 238 | 94.8 | 14 | 60 | 1148 | 728 | 1099 | WAY16510.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 3519 | 142 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 29119221 | 29119221 | PRJNA1011844_P_NODE_106569_length_310_cov_2.869198_g97996_i0 | PRJNA1011844 | 106569 | 310 | 2.869198 | 8.8945138 | Qianjiang hepeli-like virus 11 | 3348973 | Viruses | Viruses | 65.1 | 1.23e-9 | NR | XHA85823.1 | 3348973 | g97996 | i0 | 62.2 | 0.435483870967742 | 45 | 17 | 43.5 | 0 | 13 | 147 | 1497 | 1541 | XHA85823.1 MAG: polyprotein [Qianjiang hepeli-like virus 11] | diamond | 135 | 65.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Qianjiang hepeli-like virus 11 | ||||
| 30066324 | 30066324 | PRJNA1011844_P_NODE_5972_length_2218_cov_13.802797_g4095_i0 | PRJNA1011844 | 5972 | 2218 | 13.802797 | 306.14603746 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 209 | 2.44e-52 | NR | WAY16437.1 | 2809460 | g4095 | i0 | 27.7 | 2.08701532912534 | 763 | 472 | 97.5 | 22 | 53 | 2215 | 1153 | 1877 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 4629 | 209 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales 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);;