contig_metadata
7 rows where bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283632 | 283632 | PRJNA1132896_P_NODE_4341_length_284_cov_1.421801_g4250_i0 | PRJNA1132896 | 4341 | 284 | 1.421801 | 4.03791484 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 294 | 3.95e-75 | NTclustered | gi|2754691800|gb|PP872668.1| | 3003959 | g4250 | i0 | 85.87 | 0.971830985915493 | 276 | 39 | 97 | 0 | 9 | 284 | 5384 | 5659 | MAG: Picornavirales sp. isolate TC-PLV-112 MR233-17E/429 genomic sequence | blastn | 276 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 2834258 | 2834258 | PRJNA1132896_P_NODE_1183_length_478_cov_2.545679_g1092_i0 | PRJNA1132896 | 1183 | 478 | 2.545679 | 12.16834562 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 92 | 3.3e-18 | NR | WLN26256.1 | 3065075 | g1092 | i0 | 50 | 0.577405857740586 | 92 | 46 | 57.7 | 0 | 176 | 451 | 229 | 320 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 276 | 92 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 20685022 | 20685022 | PRJNA1132896_P_NODE_5237_length_271_cov_1.888889_g5146_i0 | PRJNA1132896 | 5237 | 271 | 1.888889 | 5.11888919 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 135 | 2.4e-27 | NTclustered | gi|2754691800|gb|PP872668.1| | 3003959 | g5146 | i0 | 81.765 | 0.627306273062731 | 170 | 24 | 62 | 6 | 1 | 168 | 112 | 276 | MAG: Picornavirales sp. isolate TC-PLV-112 MR233-17E/429 genomic sequence | blastn | 170 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27470371 | 27470371 | PRJNA1132896_P_NODE_6263_length_257_cov_1.255435_g6172_i0 | PRJNA1132896 | 6263 | 257 | 1.255435 | 3.22646795 | Chuvivirus | 2842604 | Viruses | Viruses | 107 | 4.55e-25 | NR | WET19887.1 | 2842604 | g6172 | i0 | 63.5 | 1.98443579766537 | 85 | 31 | 99.2 | 0 | 1 | 255 | 256 | 340 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 510 | 107 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 28681120 | 28681120 | PRJNA1132896_P_NODE_7067_length_250_cov_1.129944_g6976_i0 | PRJNA1132896 | 7067 | 250 | 1.129944 | 2.82486 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 156 | 5.3499999999999997e-42 | NR | XCM67870.1 | 3003959 | g6976 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 1 | 249 | 204 | 286 | XCM67870.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 249 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29722601 | 29722601 | PRJNA1132896_P_NODE_2530_length_346_cov_1.380952_g2439_i0 | PRJNA1132896 | 2530 | 346 | 1.380952 | 4.77809392 | Chuvivirus | 2842604 | Viruses | Viruses | 49.3 | 5.69e-4 | NR | WET19891.1 | 2842604 | g2439 | i0 | 48.9 | 0.390173410404624 | 45 | 23 | 39 | 0 | 21 | 155 | 453 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 135 | 49.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 31524199 | 31524199 | PRJNA1132896_P_NODE_4436_length_283_cov_1.100000_g4345_i0 | PRJNA1132896 | 4436 | 283 | 1.1 | 3.113 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 177 | 4.27e-49 | NR | XCM67870.1 | 3003959 | g4345 | i0 | 88.2 | 0.985865724381625 | 93 | 11 | 98.6 | 0 | 3 | 281 | 933 | 1025 | XCM67870.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 279 | 177 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 |
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);;