contig_metadata
11 rows where bioproject = "PRJNA638724" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5713213 | 5713213 | PRJNA638724_P_NODE_3065_length_350_cov_3.043321_g2979_i0 | PRJNA638724 | 3065 | 350 | 3.043321 | 10.6516235 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 298 | 3.85e-76 | NTclustered | gi|2701272534|gb|OR640980.1| | 3003959 | g2979 | i0 | 82.883 | 0.951428571428571 | 333 | 55 | 95 | 2 | 1 | 332 | 2981 | 2650 | Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds | blastn | 333 | 298 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 5713217 | 5713217 | PRJNA638724_P_NODE_5325_length_277_cov_1.955882_g5239_i0 | PRJNA638724 | 5325 | 277 | 1.955882 | 5.41779314 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 255 | 1.81e-63 | NTclustered | gi|2701272534|gb|OR640980.1| | 3003959 | g5239 | i0 | 83.895 | 0.963898916967509 | 267 | 43 | 96 | 0 | 1 | 267 | 2116 | 1850 | Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds | blastn | 267 | 255 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 8262829 | 8262829 | PRJNA638724_P_NODE_3627_length_326_cov_2.399209_g3541_i0 | PRJNA638724 | 3627 | 326 | 2.399209 | 7.82142134 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 580 | 3.1599999999999993e-161 | NTclustered | gi|2209094893|gb|OL472518.1| | 2900391 | g3541 | i0 | 99.685 | 12.659509202454 | 317 | 1 | 97 | 0 | 1 | 317 | 485 | 169 | MAG: Brine shrimp partiti-like virus 4 isolate GSL/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 4127 | 580 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 12088992 | 12088992 | PRJNA638724_P_NODE_6090_length_260_cov_1.957219_g6004_i0 | PRJNA638724 | 6090 | 260 | 1.957219 | 5.0887694 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 311 | 3.54e-80 | NTclustered | gi|2701272534|gb|OR640980.1| | 3003959 | g6004 | i0 | 89.157 | 0.957692307692308 | 249 | 27 | 96 | 0 | 11 | 259 | 1142 | 1390 | Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds | blastn | 249 | 311 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 19736323 | 19736323 | PRJNA638724_P_NODE_5996_length_262_cov_1.227513_g5910_i0 | PRJNA638724 | 5996 | 262 | 1.227513 | 3.21608406 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 226 | 1.3299999999999994e-54 | NTclustered | gi|2701272534|gb|OR640980.1| | 3003959 | g5910 | i0 | 83.004 | 0.965648854961832 | 253 | 39 | 96 | 3 | 2 | 253 | 5041 | 4792 | Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds | blastn | 253 | 226 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 26922846 | 26922846 | PRJNA638724_P_NODE_6682_length_250_cov_2.062147_g6596_i0 | PRJNA638724 | 6682 | 250 | 2.062147 | 5.1553675 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 156 | 5.329999999999998e-42 | NR | WXH59494.1 | 3003959 | g6596 | i0 | 93.7 | 0.948 | 79 | 5 | 94.8 | 0 | 238 | 2 | 847 | 925 | WXH59494.1 RdRp [Picornavirales sp.] | diamond | 237 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28880942 | 28880942 | PRJNA638724_P_NODE_7488_length_241_cov_1.732143_g7402_i0 | PRJNA638724 | 7488 | 241 | 1.732143 | 4.17446463 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 135 | 6.28e-35 | NR | WXH59495.1 | 3003959 | g7402 | i0 | 88.2 | 1.86721991701245 | 76 | 9 | 94.6 | 0 | 230 | 3 | 130 | 205 | WXH59495.1 capsid protein [Picornavirales sp.] | diamond | 450 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29606885 | 29606885 | PRJNA638724_P_NODE_1790_length_441_cov_2.195652_g1704_i0 | PRJNA638724 | 1790 | 441 | 2.195652 | 9.68282532 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 269 | 3.24e-82 | NR | WXH59495.1 | 3003959 | g1704 | i0 | 96.5 | 0.972789115646258 | 143 | 5 | 97.3 | 0 | 12 | 440 | 548 | 690 | WXH59495.1 capsid protein [Picornavirales sp.] | diamond | 429 | 269 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29638466 | 29638466 | PRJNA638724_P_NODE_5330_length_277_cov_1.553922_g5244_i0 | PRJNA638724 | 5330 | 277 | 1.553922 | 4.30436394 | Solemoviridae sp. | 2715208 | Viruses | Viruses | 79 | 1.01e-14 | NR | QYV43073.1 | 2715208 | g5244 | i0 | 52.9 | 1.50541516245487 | 70 | 32 | 75.8 | 1 | 10 | 219 | 223 | 291 | QYV43073.1 MAG: capsid protein [Solemoviridae sp.] | diamond | 417 | 79 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Solemoviridae sp. | |||
| 29859819 | 29859819 | PRJNA638724_P_NODE_6051_length_261_cov_1.372340_g5965_i0 | PRJNA638724 | 6051 | 261 | 1.37234 | 3.5818074 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 111 | 3.93e-26 | NR | WWZ85593.1 | 3132542 | g5965 | i0 | 61.7 | 0.931034482758621 | 81 | 31 | 93.1 | 0 | 249 | 7 | 2741 | 2821 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 243 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 30997345 | 30997345 | PRJNA638724_P_NODE_954_length_572_cov_1.635271_g870_i0 | PRJNA638724 | 954 | 572 | 1.635271 | 9.35375012 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 358 | 2.55e-115 | NR | WXH59495.1 | 3003959 | g870 | i0 | 92 | 0.980769230769231 | 187 | 15 | 98.1 | 0 | 12 | 572 | 693 | 879 | WXH59495.1 capsid protein [Picornavirales sp.] | diamond | 561 | 358 | 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);;