contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18044258 | 18044258 | PRJNA1078753_P_NODE_18595_length_284_cov_2.189573_g18399_i0 | PRJNA1078753 | 18595 | 284 | 2.189573 | 6.21838732 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 114 | 2.59e-28 | NR | QDH91349.1 | 1955170 | g18399 | i0 | 65.9 | 0.897887323943662 | 85 | 29 | 89.8 | 0 | 283 | 29 | 170 | 254 | QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.] | diamond | 255 | 114 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 26624260 | 26624260 | PRJNA1078753_P_NODE_81_length_2396_cov_5.068015_g56_i0 | PRJNA1078753 | 81 | 2396 | 5.068015 | 121.4296394 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 153 | 4.92e-34 | NR | WZI33259.1 | RQ13 | g56 | i0 | 25.7 | 1.01168614357262 | 808 | 508 | 97.2 | 28 | 2328 | 1 | 307 | 1054 | WZI33259.1 MAG: polyprotein [Crocidura lasiura picornavirus 2] | diamond | 2424 | 153 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 27983434 | 27983434 | PRJNA1078753_P_NODE_905_length_982_cov_3.667767_g763_i0 | PRJNA1078753 | 905 | 982 | 3.667767 | 36.01747194 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 289 | 2.72e-84 | NR | XBH24011.1 | RQ13 | g763 | i0 | 49.8 | 7.15478615071283 | 293 | 144 | 88.9 | 3 | 982 | 110 | 2094 | 2385 | XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] | diamond | 7026 | 289 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 28141544 | 28141544 | PRJNA1078753_P_NODE_1105_length_903_cov_3.660241_g955_i0 | PRJNA1078753 | 1105 | 903 | 3.660241 | 33.05197623 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 306 | 6.95e-91 | NR | XBH24011.1 | RQ13 | g955 | i0 | 53.4 | 3.9734219269103 | 296 | 130 | 97.7 | 6 | 3 | 884 | 1951 | 2240 | XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] | diamond | 3588 | 306 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 28457213 | 28457213 | PRJNA1078753_P_NODE_66_length_2497_cov_2.203795_g48_i0 | PRJNA1078753 | 66 | 2497 | 2.203795 | 55.02876115 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 58.2 | 2.33e-4 | NR | YP_010797608.1 | RQ13 | g48 | i0 | 25.7 | 0.331597917501001 | 276 | 169 | 29.7 | 10 | 766 | 26 | 274 | 542 | YP_010797608.1 polyprotein [rajidapivirus A1] | diamond | 828 | 58.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Rajidapivirus | Zebrafish jaw picornavirus | ||
| 29941291 | 29941291 | PRJNA1078753_P_NODE_4011_length_513_cov_2.588636_g3817_i0 | PRJNA1078753 | 4011 | 513 | 2.588636 | 13.27970268 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 91.7 | 6.69e-18 | NR | WLN26256.1 | 3065075 | g3817 | i0 | 51.7 | 0.508771929824561 | 87 | 42 | 50.9 | 0 | 250 | 510 | 229 | 315 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 261 | 91.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 30509804 | 30509804 | PRJNA1078753_P_NODE_93_length_2222_cov_3.143788_g66_i0 | PRJNA1078753 | 93 | 2222 | 3.143788 | 69.85496936 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 110 | 1.12e-20 | NR | ADG03747.2 | RQ13 | g66 | i0 | 23.9 | 1.01800180018002 | 754 | 408 | 88.3 | 25 | 22 | 1983 | 644 | 1331 | ADG03747.2 polyprotein [aichivirus B3] | diamond | 2262 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 30857302 | 30857302 | PRJNA1078753_P_NODE_4034_length_512_cov_6.168565_g3840_i0 | PRJNA1078753 | 4034 | 512 | 6.168565 | 31.5830528 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 60.1 | 5.84e-7 | NR | QJX58422.1 | RQ13 | g3840 | i0 | 41.9 | 2.16796875 | 74 | 42 | 42.8 | 1 | 3 | 221 | 2286 | 2359 | QJX58422.1 polyprotein [Salivirus A] | diamond | 1110 | 60.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Salivirus | Zebrafish jaw picornavirus | ||
| 31512813 | 31512813 | PRJNA1078753_P_NODE_13256_length_321_cov_1.495968_g13060_i0 | PRJNA1078753 | 13256 | 321 | 1.495968 | 4.80205728 | Chuvivirus | 2842604 | Viruses | Viruses | 131 | 1.17e-33 | NR | WET19887.1 | 2842604 | g13060 | i0 | 64.2 | 1.98130841121495 | 106 | 38 | 99.1 | 0 | 2 | 319 | 243 | 348 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 636 | 131 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;