contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8017764 | 8017764 | PRJNA168635_P_NODE_19127_length_185_cov_2.808824_g18711_i0 | PRJNA168635 | 19127 | 185 | 2.808824 | 5.1963244 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 339 | 1.08e-88 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g18711 | i0 | 100 | 0.989189189189189 | 183 | 0 | 99 | 0 | 3 | 185 | 1475 | 1293 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 183 | 339 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 17631936 | 17631936 | PRJNA168635_P_NODE_30454_length_163_cov_2.728070_g30038_i0 | PRJNA168635 | 30454 | 163 | 2.72807 | 4.4467541 | Viruses | 10239 | Viruses | Viruses | 283 | 4.43e-72 | NTclustered | gi|1397590996|gb|MH425513.1| | 2217875 | g30038 | i0 | 100 | 4.68711656441718 | 153 | 0 | 94 | 0 | 11 | 163 | 319 | 167 | MAG: Humpback whale blow-associated circo-like virus 2 replication initiation protein gene, complete cds | blastn | 764 | 283 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Humpback whale blow-associated circo-like virus 2 | |||
| 18215992 | 18215992 | PRJNA168635_P_NODE_11695_length_239_cov_5.110526_g11279_i0 | PRJNA168635 | 11695 | 239 | 5.110526 | 12.21415714 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 403 | 5.15e-108 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11279 | i0 | 98.261 | 0.96234309623431 | 230 | 4 | 96 | 0 | 1 | 230 | 1375 | 1604 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 230 | 403 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 19490222 | 19490222 | PRJNA168635_P_NODE_11636_length_240_cov_1.931937_g11220_i0 | PRJNA168635 | 11636 | 240 | 1.931937 | 4.6366488 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 351 | 1.9e-92 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11220 | i0 | 93.991 | 0.970833333333333 | 233 | 13 | 97 | 1 | 8 | 239 | 2107 | 1875 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 233 | 351 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 20180268 | 20180268 | PRJNA168635_P_NODE_19976_length_182_cov_2.872180_g19560_i0 | PRJNA168635 | 19976 | 182 | 2.87218 | 5.2273676 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 337 | 3.82e-88 | NTclustered | gi|530787446|ref|NC_022089.1| | 3003968 | g19560 | i0 | 100 | 15.9175824175824 | 182 | 0 | 100 | 0 | 1 | 182 | 230 | 411 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | blastn | 2897 | 337 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 20180282 | 20180282 | PRJNA168635_P_NODE_20976_length_179_cov_1.784615_g20560_i0 | PRJNA168635 | 20976 | 179 | 1.784615 | 3.19446085 | Nicoomyvirus | 3425078 | Viruses | Viruses | 267 | 4.9699999999999996e-67 | NTclustered | gi|530787446|ref|NC_022089.1| | 1341019 | g20560 | i0 | 98.667 | 12.5698324022346 | 150 | 2 | 84 | 0 | 10 | 159 | 3067 | 2918 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | blastn | 2250 | 267 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 20765830 | 20765830 | PRJNA168635_P_NODE_11797_length_238_cov_2.894180_g11381_i0 | PRJNA168635 | 11797 | 238 | 2.89418 | 6.8881484 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 281 | 2.5e-71 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11381 | i0 | 90.952 | 0.882352941176471 | 210 | 17 | 87 | 2 | 1 | 208 | 882 | 673 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 210 | 281 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 24591025 | 24591025 | PRJNA168635_P_NODE_7600_length_306_cov_8.023346_g7188_i0 | PRJNA168635 | 7600 | 306 | 8.023346 | 24.55143876 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 407 | 5.29e-109 | NTclustered | gi|2015373198|gb|MW046538.1| | 2794515 | g7188 | i0 | 91.03 | 1.3202614379085 | 301 | 27 | 98 | 0 | 1 | 301 | 1069 | 1369 | MAG: Luscinia sibilans parvo-like hybrid virus isolate rtr167par08 genomic sequence, sequence | blastn | 404 | 407 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid 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);;