contig_metadata
13 rows where bioproject = "PRJNA966993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1265524 | 1265524 | PRJNA966993_P_NODE_40901_length_337_cov_1.166667_g40449_i0 | PRJNA966993 | 40901 | 337 | 1.166667 | 3.93166779 | root | 1 | Root_unresolved | Root_unresolved | 610 | 4.18e-170 | NTclustered | gi|62011|emb|X17008.1| | 12730 | g40449 | i0 | 99.407 | 51.6824925816024 | 337 | 1 | 100 | 1 | 1 | 337 | 1314 | 979 | Sendai virus polymerase (P) gene (strain fushimi) | blastn | 17417 | 616 | 0.99025974025974 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 2217343 | 2217343 | PRJNA966993_P_NODE_2_length_8533_cov_92.980024_g1_i0 | PRJNA966993 | 2 | 8533 | 92.980024 | 7933.98544792 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 8564 | 0 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g1 | i0 | 86.569 | 0.916207664361889 | 7818 | 988 | 91 | 56 | 1 | 7789 | 7785 | 1 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 7818 | 8564 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 16245522 | 16245522 | PRJNA966993_P_NODE_98993_length_241_cov_0.916667_g98541_i0 | PRJNA966993 | 98993 | 241 | 0.916667 | 2.20916747 | Mitovirus sp. | 2587224 | Viruses | Viruses | 130 | 9.74e-26 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g98541 | i0 | 89.32 | 0.817427385892116 | 103 | 11 | 43 | 0 | 139 | 241 | 116 | 14 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 197 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 17520321 | 17520321 | PRJNA966993_P_NODE_57254_length_288_cov_3.786047_g56802_i0 | PRJNA966993 | 57254 | 288 | 3.786047 | 10.90381536 | Mitovirus sp. | 2587224 | Viruses | Viruses | 126 | 1.5499999999999998e-24 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g56802 | i0 | 95 | 0.277777777777778 | 80 | 4 | 28 | 0 | 185 | 264 | 112 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 80 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 26677382 | 26677382 | PRJNA966993_P_NODE_50461_length_305_cov_1.659483_g50009_i0 | PRJNA966993 | 50461 | 305 | 1.659483 | 5.06142315 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 46.6 | 0.00355 | NR | XCM67837.1 | 3003959 | g50009 | i0 | 30.2 | 1.04262295081967 | 106 | 63 | 95.4 | 2 | 299 | 9 | 27 | 130 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 318 | 46.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27531393 | 27531393 | PRJNA966993_P_NODE_10123_length_658_cov_2.058120_g9700_i0 | PRJNA966993 | 10123 | 658 | 2.05812 | 13.5424296 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 133 | 1.1e-31 | NR | XCM67837.1 | 3003959 | g9700 | i0 | 56.3 | 0.542553191489362 | 119 | 49 | 53.8 | 2 | 25 | 378 | 144 | 260 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 357 | 133 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28320755 | 28320755 | PRJNA966993_P_NODE_6026_length_843_cov_2.051948_g5656_i0 | PRJNA966993 | 6026 | 843 | 2.051948 | 17.29792164 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 200 | 4.3599999999999997e-54 | NR | XCM67837.1 | 3003959 | g5656 | i0 | 37.5 | 0.97864768683274 | 275 | 167 | 96.8 | 4 | 838 | 23 | 941 | 1213 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 825 | 200 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28478698 | 28478698 | PRJNA966993_P_NODE_46_length_4551_cov_5.438589_g38_i0 | PRJNA966993 | 46 | 4551 | 5.438589 | 247.51018539 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 628 | 2.49e-192 | NR | XCM67837.1 | 3003959 | g38 | i0 | 61.8 | 0.312458800263678 | 474 | 181 | 31.2 | 0 | 4549 | 3128 | 1287 | 1760 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 1422 | 628 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28984128 | 28984128 | PRJNA966993_P_NODE_22688_length_441_cov_2.048913_g22241_i0 | PRJNA966993 | 22688 | 441 | 2.048913 | 9.03570633 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 119 | 4.27e-28 | NR | XCM67837.1 | 3003959 | g22241 | i0 | 57.4 | 0.73469387755102 | 108 | 44 | 73.5 | 1 | 439 | 116 | 768 | 873 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 324 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29425638 | 29425638 | PRJNA966993_P_NODE_10809_length_638_cov_2.759292_g10381_i0 | PRJNA966993 | 10809 | 638 | 2.759292 | 17.60428296 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 257 | 3.76e-75 | NR | XCM67837.1 | 3003959 | g10381 | i0 | 56.6 | 0.996865203761755 | 212 | 92 | 99.7 | 0 | 638 | 3 | 467 | 678 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 636 | 257 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31194494 | 31194494 | PRJNA966993_P_NODE_10315_length_652_cov_2.126079_g9891_i0 | PRJNA966993 | 10315 | 652 | 2.126079 | 13.86203508 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 102 | 5e-21 | NR | XCM67837.1 | 3003959 | g9891 | i0 | 39 | 0.73159509202454 | 159 | 91 | 71.8 | 3 | 472 | 5 | 310 | 465 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 477 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31606149 | 31606149 | PRJNA966993_P_NODE_79776_length_254_cov_2.751381_g79324_i0 | PRJNA966993 | 79776 | 254 | 2.751381 | 6.98850774 | Durnavirales sp. | 2809355 | Viruses | Viruses | 61.6 | 9.28e-9 | NR | WRQ64726.1 | 2809355 | g79324 | i0 | 40.7 | 0.956692913385827 | 81 | 47 | 95.7 | 1 | 254 | 12 | 402 | 481 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 243 | 61.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 32618239 | 32618239 | PRJNA966993_P_NODE_59920_length_285_cov_1.301887_g59468_i0 | PRJNA966993 | 59920 | 285 | 1.301887 | 3.71037795 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 53.9 | 7.42e-6 | NR | YP_010840939.1 | 2951531 | g59468 | i0 | 47.8 | 2.09473684210526 | 69 | 35 | 71.6 | 1 | 206 | 3 | 1 | 69 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 597 | 53.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus |
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);;