contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJDB9741" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2560695 | 2560695 | PRJDB9741_P_NODE_16743_length_183_cov_2.619403_g16426_i0 | PRJDB9741 | 16743 | 183 | 2.619403 | 4.79350749 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 316 | 5.009999999999999e-82 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g16426 | i0 | 97.814 | 1.98907103825137 | 183 | 4 | 100 | 0 | 1 | 183 | 4366 | 4548 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 364 | 316 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 11488871 | 11488871 | PRJDB9741_P_NODE_2570_length_457_cov_1.186275_g2256_i0 | PRJDB9741 | 2570 | 457 | 1.186275 | 5.42127675 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 828 | 0 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g2256 | i0 | 99.344 | 1.99124726477024 | 457 | 3 | 100 | 0 | 1 | 457 | 4656 | 5112 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 910 | 828 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 11489034 | 11489034 | PRJDB9741_P_NODE_7530_length_229_cov_1.133333_g7213_i0 | PRJDB9741 | 7530 | 229 | 1.133333 | 2.59533257 | Sopamon virus | 3131721 | Viruses | Viruses | 246 | 8.73e-61 | NTclustered | gi|2717323235|gb|PP174022.1| | 3131721 | g7213 | i0 | 86.667 | 233.161572052402 | 225 | 26 | 97 | 4 | 7 | 229 | 420 | 198 | MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence | blastn | 53394 | 246 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopamon virus | |||||
| 12461106 | 12461106 | PRJDB9741_P_NODE_9710_length_210_cov_2.354037_g9393_i0 | PRJDB9741 | 9710 | 210 | 2.354037 | 4.9434777 | Viruses | 10239 | Viruses | Viruses | 158 | 3.8e-34 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g9393 | i0 | 96.809 | 4.06190476190476 | 94 | 3 | 92 | 0 | 111 | 204 | 1931 | 1838 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 853 | 158 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 14039125 | 14039125 | PRJDB9741_P_NODE_5312_length_274_cov_1.395556_g4996_i0 | PRJDB9741 | 5312 | 274 | 1.395556 | 3.82382344 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 479 | 9.74e-131 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g4996 | i0 | 98.175 | 2 | 274 | 5 | 100 | 0 | 1 | 274 | 4313 | 4040 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 548 | 479 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 21687510 | 21687510 | PRJDB9741_P_NODE_28538_length_167_cov_0.864407_g28221_i0 | PRJDB9741 | 28538 | 167 | 0.864407 | 1.44355969 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g28221 | i0 | 100 | 0.982035928143713 | 164 | 0 | 98 | 0 | 4 | 167 | 3947 | 3784 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 164 | 303 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 21687631 | 21687631 | PRJDB9741_P_NODE_42618_length_154_cov_2.342857_g42301_i0 | PRJDB9741 | 42618 | 154 | 2.342857 | 3.60799978 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 279 | 5.33e-71 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g42301 | i0 | 99.351 | 2 | 154 | 1 | 100 | 0 | 1 | 154 | 1212 | 1365 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 308 | 279 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 22962701 | 22962701 | PRJDB9741_P_NODE_11239_length_199_cov_1.906667_g10922_i0 | PRJDB9741 | 11239 | 199 | 1.906667 | 3.79426733 | Tolivirales sp. | 2809914 | Viruses | Viruses | 324 | 3.31e-84 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g10922 | i0 | 95.98 | 1.22110552763819 | 199 | 8 | 100 | 0 | 1 | 199 | 1892 | 2090 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 243 | 324 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales 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);;