contig_metadata
8 rows where bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8486030 | 8486030 | PRJNA846486_P_NODE_14067_length_333_cov_4.658451_g13971_i0 | PRJNA846486 | 14067 | 333 | 4.658451 | 15.51264183 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 115 | 3.95e-21 | NTclustered | gi|2754691654|gb|PP872616.1| | 3003959 | g13971 | i0 | 80.124 | 0.966966966966967 | 161 | 27 | 47 | 5 | 7 | 164 | 6420 | 6262 | MAG: Picornavirales sp. isolate TC-PLV-60 MR233-17E/328 genomic sequence | blastn | 322 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 18684610 | 18684610 | PRJNA846486_P_NODE_64015_length_180_cov_1.885496_g63919_i0 | PRJNA846486 | 64015 | 180 | 1.885496 | 3.3938928 | Tolivirales sp. | 2809914 | Viruses | Viruses | 300 | 4.94e-77 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g63919 | i0 | 96.667 | 1 | 180 | 6 | 100 | 0 | 1 | 180 | 2980 | 2801 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 180 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 18684633 | 18684633 | PRJNA846486_P_NODE_73075_length_171_cov_2.278689_g72979_i0 | PRJNA846486 | 73075 | 171 | 2.278689 | 3.89655819 | Canine astrovirus | 1157338 | Viruses | Viruses | 311 | 2.14e-80 | NTclustered | gi|1355917460|gb|MF973500.1| | 1157338 | g72979 | i0 | 99.415 | 72.8830409356725 | 171 | 1 | 100 | 0 | 1 | 171 | 6422 | 6592 | Canine astrovirus strain CHN/2017/44, complete genome | blastn | 12463 | 311 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Mamastrovirus | Canine astrovirus | ||
| 21235370 | 21235370 | PRJNA846486_P_NODE_63257_length_181_cov_1.575758_g63161_i0 | PRJNA846486 | 63257 | 181 | 1.575758 | 2.85212198 | Orthoreovirus piscis | 3431498 | Viruses | Viruses | 235 | 1.42e-57 | NTclustered | gi|2634039173|gb|OR872662.1| | 1157337 | g63161 | i0 | 90.164 | 19.8729281767956 | 183 | 14 | 99 | 3 | 1 | 180 | 1920 | 2101 | Piscine orthoreovirus isolate WADDL:2021-1143 mu1 protein gene, partial cds | blastn | 3597 | 235 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Orthoreovirus | Orthoreovirus piscis | ||
| 28539324 | 28539324 | PRJNA846486_P_NODE_23087_length_269_cov_2.090909_g22991_i0 | PRJNA846486 | 23087 | 269 | 2.090909 | 5.62454521 | Qianjiang tombus-like virus 56 | 3348124 | Viruses | Viruses | 51.2 | 4.89e-5 | NR | XHA86470.1 | 3348124 | g22991 | i0 | 40.3 | 0.858736059479554 | 77 | 43 | 82.5 | 1 | 263 | 42 | 253 | 329 | XHA86470.1 MAG: hypothetical protein [Qianjiang tombus-like virus 56] | diamond | 231 | 51.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 56 | |||
| 29422952 | 29422952 | PRJNA846486_P_NODE_42049_length_211_cov_1.925926_g41953_i0 | PRJNA846486 | 42049 | 211 | 1.925926 | 4.06370386 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 50.1 | 6.62e-5 | NR | XCM68141.1 | 3003959 | g41953 | i0 | 64.9 | 0.5260663507109 | 37 | 13 | 52.6 | 0 | 207 | 97 | 1875 | 1911 | XCM68141.1 MAG: polyprotein, partial [Picornavirales sp.] | diamond | 111 | 50.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32521143 | 32521143 | PRJNA846486_P_NODE_16559_length_310_cov_1.624521_g16463_i0 | PRJNA846486 | 16559 | 310 | 1.624521 | 5.0360151 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 156 | 1.19e-41 | NR | UNY42121.1 | 3003959 | g16463 | i0 | 67.6 | 0.987096774193548 | 102 | 33 | 98.7 | 0 | 308 | 3 | 990 | 1091 | UNY42121.1 MAG: polyprotein 1 [Picornavirales sp.] | diamond | 306 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32615557 | 32615557 | PRJNA846486_P_NODE_7680_length_441_cov_2.928571_g7586_i0 | PRJNA846486 | 7680 | 441 | 2.928571 | 12.91499811 | Ripoglor virus | 3130730 | Viruses | Viruses | 50.4 | 6.19e-4 | NR | WZH60210.1 | 3130730 | g7586 | i0 | 44.6 | 0.380952380952381 | 56 | 31 | 38.1 | 0 | 436 | 269 | 956 | 1011 | WZH60210.1 MAG: RNA-dependent RNA polymerase [Ripoglor virus] | diamond | 168 | 50.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripoglor virus |
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);;