contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746984 | 746984 | PRJNA770826_P_NODE_7861_length_291_cov_2.363636_g7690_i0 | PRJNA770826 | 7861 | 291 | 2.363636 | 6.87818076 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 392 | 1.4e-104 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g7690 | i0 | 91.034 | 0.996563573883162 | 290 | 26 | 99 | 0 | 2 | 291 | 6577 | 6288 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 290 | 392 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 3298041 | 3298041 | PRJNA770826_P_NODE_13663_length_218_cov_0.923077_g13492_i0 | PRJNA770826 | 13663 | 218 | 0.923077 | 2.01230786 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 392 | 1e-104 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g13492 | i0 | 99.083 | 1 | 218 | 2 | 100 | 0 | 1 | 218 | 4620 | 4403 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 218 | 392 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 4575168 | 4575168 | PRJNA770826_P_NODE_24184_length_169_cov_0.866667_g24013_i0 | PRJNA770826 | 24184 | 169 | 0.866667 | 1.46466723 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2509246065|gb|OQ596834.1| | 11676 | g24013 | i0 | 100 | 0.171597633136095 | 29 | 0 | 17 | 0 | 19 | 47 | 4328 | 4356 | HIV-1 isolate CIS06042-V1-CD4-13 from Belgium nonfunctional gag protein (gag) gene, complete sequence; and nonfunctional pol protein (pol) gene, partial sequence | blastn | 29 | 54.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 5850340 | 5850340 | PRJNA770826_P_NODE_11365_length_239_cov_1.368421_g11194_i0 | PRJNA770826 | 11365 | 239 | 1.368421 | 3.27052619 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 398 | 2.4e-106 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g11194 | i0 | 97.826 | 0.96234309623431 | 230 | 5 | 96 | 0 | 10 | 239 | 7406 | 7177 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 230 | 398 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 7125666 | 7125666 | PRJNA770826_P_NODE_4146_length_424_cov_1.282667_g3975_i0 | PRJNA770826 | 4146 | 424 | 1.282667 | 5.43850808 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 704 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g3975 | i0 | 96.69 | 401.514150943396 | 423 | 14 | 99 | 0 | 1 | 423 | 18277 | 17855 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 170242 | 704 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12226633 | 12226633 | PRJNA770826_P_NODE_3670_length_450_cov_1.748130_g3499_i0 | PRJNA770826 | 3670 | 450 | 1.74813 | 7.866585 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 749 | 0 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g3499 | i0 | 96.667 | 1 | 450 | 15 | 100 | 0 | 1 | 450 | 6716 | 7165 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 450 | 749 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 13500651 | 13500651 | PRJNA770826_P_NODE_28311_length_167_cov_0.881356_g28140_i0 | PRJNA770826 | 28311 | 167 | 0.881356 | 1.47186452 | Lentivirus simimdef | 3418654 | Viruses | Viruses | 71.3 | 3.87e-8 | NTclustered | gi|1378939259|gb|MG931190.1| | 11723 | g28140 | i0 | 95.455 | 16.0299401197605 | 44 | 2 | 26 | 0 | 67 | 110 | 324 | 281 | Simian immunodeficiency virus isolate 092N03Pc_109 envelope glycoprotein (env) gene, partial cds | blastn | 2677 | 71.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus simimdef | ||
| 13500654 | 13500654 | PRJNA770826_P_NODE_29971_length_167_cov_0.881356_g29800_i0 | PRJNA770826 | 29971 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g29800 | i0 | 99.401 | 3 | 167 | 1 | 100 | 0 | 1 | 167 | 25698 | 25864 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 501 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17325137 | 17325137 | PRJNA770826_P_NODE_10154_length_253_cov_1.529412_g9983_i0 | PRJNA770826 | 10154 | 253 | 1.529412 | 3.86941236 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 435 | 1.95e-117 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g9983 | i0 | 97.628 | 1 | 253 | 6 | 100 | 0 | 1 | 253 | 2228 | 2480 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 253 | 435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 17325195 | 17325195 | PRJNA770826_P_NODE_18034_length_191_cov_1.091549_g17863_i0 | PRJNA770826 | 18034 | 191 | 1.091549 | 2.08485859 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 326 | 8.77e-85 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g17863 | i0 | 97.382 | 1 | 191 | 5 | 100 | 0 | 1 | 191 | 1727 | 1917 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 191 | 326 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 17325233 | 17325233 | PRJNA770826_P_NODE_26674_length_168_cov_0.873950_g26503_i0 | PRJNA770826 | 26674 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 2.12e-75 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g26503 | i0 | 98.225 | 5.75595238095238 | 169 | 2 | 100 | 1 | 1 | 168 | 6400 | 6568 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 967 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18598566 | 18598566 | PRJNA770826_P_NODE_11915_length_233_cov_1.978261_g11744_i0 | PRJNA770826 | 11915 | 233 | 1.978261 | 4.60934813 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 392 | 1.08e-104 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g11744 | i0 | 96.996 | 1 | 233 | 7 | 100 | 0 | 1 | 233 | 7647 | 7415 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 233 | 392 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 18598676 | 18598676 | PRJNA770826_P_NODE_33095_length_166_cov_0.888889_g32924_i0 | PRJNA770826 | 33095 | 166 | 0.888889 | 1.47555574 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 267 | 4.559999999999999e-67 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g32924 | i0 | 96.319 | 1.15060240963855 | 163 | 5 | 98 | 1 | 1 | 163 | 609 | 770 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 191 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 20333148 | 20333148 | PRJNA770826_P_NODE_39236_length_163_cov_0.912281_g39065_i0 | PRJNA770826 | 39236 | 163 | 0.912281 | 1.48701803 | root | 1 | Root_unresolved | Root_unresolved | 302 | 1.22e-77 | NTclustered | gi|2057959827|tpg|BK046364.1| | 2832643 | g39065 | i0 | 100 | 12.8588957055215 | 163 | 0 | 100 | 0 | 1 | 163 | 31475 | 31313 | MAG TPA_asm: Caudoviricetes sp. isolate ctThn6, partial genome | blastn | 2096 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21149584 | 21149584 | PRJNA770826_P_NODE_8837_length_272_cov_1.632287_g8666_i0 | PRJNA770826 | 8837 | 272 | 1.632287 | 4.43982064 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 4.15e-5 | NTclustered | gi|2906149976|gb|PQ646492.1| | 2832643 | g8666 | i0 | 89.583 | 0.308823529411765 | 48 | 5 | 18 | 0 | 218 | 265 | 14529 | 14576 | MAG: Caudoviricetes sp. isolate k127_1042512 genomic sequence | blastn | 84 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23699847 | 23699847 | PRJNA770826_P_NODE_21379_length_175_cov_1.238095_g21208_i0 | PRJNA770826 | 21379 | 175 | 1.238095 | 2.16666625 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.3499999999999999e-62 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g21208 | i0 | 92.614 | 4.95428571428571 | 176 | 11 | 100 | 2 | 1 | 175 | 7566 | 7392 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 867 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24973578 | 24973578 | PRJNA770826_P_NODE_4420_length_410_cov_1.872576_g4249_i0 | PRJNA770826 | 4420 | 410 | 1.872576 | 7.6775616 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 497 | 4.21e-136 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g4249 | i0 | 88.537 | 1 | 410 | 47 | 100 | 0 | 1 | 410 | 5582 | 5991 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 410 | 497 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae 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);;