contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA721440" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9638626 | 9638626 | PRJNA721440_S_NODE_19308_length_163_cov_1.824561_g19182_i0 | PRJNA721440 | 19308 | 163 | 1.824561 | 2.97403443 | Aparavirus sp. | 1955142 | Viruses | Viruses | 109 | 3.15e-26 | NR | ULF99835.1 | 1955142 | g19182 | i0 | 92.5 | 0.975460122699387 | 53 | 4 | 97.5 | 0 | 161 | 3 | 1164 | 1216 | ULF99835.1 MAG: hypothetical protein 1 [Aparavirus sp.] | diamond | 159 | 109 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 13463901 | 13463901 | PRJNA721440_S_NODE_1771_length_408_cov_6.448468_g1645_i0 | PRJNA721440 | 1771 | 408 | 6.448468 | 26.30974944 | Aparavirus sp. | 1955142 | Viruses | Viruses | 212 | 1.9e-61 | NR | ULF99836.1 | 1955142 | g1645 | i0 | 72 | 1.05147058823529 | 143 | 32 | 99.3 | 1 | 3 | 407 | 475 | 617 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 429 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 27241634 | 27241634 | PRJNA721440_S_NODE_9363_length_209_cov_5.337500_g9237_i0 | PRJNA721440 | 9363 | 209 | 5.3375 | 11.155375 | Aparavirus sp. | 1955142 | Viruses | Viruses | 122 | 2.18e-30 | NR | ULF99836.1 | 1955142 | g9237 | i0 | 82.4 | 0.976076555023923 | 68 | 12 | 97.6 | 0 | 206 | 3 | 199 | 266 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 204 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 27652488 | 27652488 | PRJNA721440_S_NODE_3024_length_327_cov_2.118705_g2898_i0 | PRJNA721440 | 3024 | 327 | 2.118705 | 6.9281653499999996 | Aparavirus sp. | 1955142 | Viruses | Viruses | 167 | 1.17e-45 | NR | ULF99826.1 | 1955142 | g2898 | i0 | 76.4 | 1.95412844036697 | 106 | 25 | 97.2 | 0 | 5 | 322 | 58 | 163 | ULF99826.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 639 | 167 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 28062698 | 28062698 | PRJNA721440_S_NODE_14105_length_180_cov_4.206107_g13979_i0 | PRJNA721440 | 14105 | 180 | 4.206107 | 7.5709926 | Aparavirus sp. | 1955142 | Viruses | Viruses | 98.6 | 3.41e-22 | NR | ULF99835.1 | 1955142 | g13979 | i0 | 83.1 | 0.983333333333333 | 59 | 9 | 98.3 | 1 | 179 | 3 | 600 | 657 | ULF99835.1 MAG: hypothetical protein 1 [Aparavirus sp.] | diamond | 177 | 98.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 30241714 | 30241714 | PRJNA721440_S_NODE_4192_length_285_cov_5.245763_g4066_i0 | PRJNA721440 | 4192 | 285 | 5.245763 | 14.95042455 | Aparavirus sp. | 1955142 | Viruses | Viruses | 147 | 6.94e-39 | NR | ULF99836.1 | 1955142 | g4066 | i0 | 77.4 | 0.978947368421053 | 93 | 21 | 97.9 | 0 | 6 | 284 | 311 | 403 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 279 | 147 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 30273528 | 30273528 | PRJNA721440_S_NODE_17172_length_168_cov_3.050420_g17046_i0 | PRJNA721440 | 17172 | 168 | 3.05042 | 5.1247056 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 64.3 | 3.26e-10 | NR | WLN26256.1 | 3065075 | g17046 | i0 | 57.7 | 0.928571428571429 | 52 | 22 | 92.9 | 0 | 5 | 160 | 260 | 311 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 156 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31063341 | 31063341 | PRJNA721440_S_NODE_17115_length_168_cov_5.806723_g16989_i0 | PRJNA721440 | 17115 | 168 | 5.806723 | 9.75529464 | Aparavirus sp. | 1955142 | Viruses | Viruses | 48.9 | 9.29e-5 | NR | ULF99836.1 | 1955142 | g16989 | i0 | 90.5 | 0.375 | 21 | 2 | 37.5 | 0 | 1 | 63 | 791 | 811 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 63 | 48.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 32297047 | 32297047 | PRJNA721440_S_NODE_11439_length_195_cov_2.130137_g11313_i0 | PRJNA721440 | 11439 | 195 | 2.130137 | 4.15376715 | Aparavirus sp. | 1955142 | Viruses | Viruses | 102 | 2.67e-23 | NR | ULF99836.1 | 1955142 | g11313 | i0 | 67.7 | 1 | 65 | 21 | 100 | 0 | 1 | 195 | 418 | 482 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 195 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus 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);;