contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2922691 | 2922691 | PRJNA285816_S_NODE_23563_length_170_cov_1.165289_g23461_i0 | PRJNA285816 | 23563 | 170 | 1.165289 | 1.9809913 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 291 | 2.77e-74 | NTclustered | gi|2058128472|tpg|BK034062.1| | 2832643 | g23461 | i0 | 97.633 | 425.482352941176 | 169 | 4 | 99 | 0 | 1 | 169 | 39871 | 39703 | MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome | blastn | 72332 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4199017 | 4199017 | PRJNA285816_S_NODE_13424_length_208_cov_0.981132_g13322_i0 | PRJNA285816 | 13424 | 208 | 0.981132 | 2.04075456 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 76.8 | 1.08e-9 | NTclustered | gi|2565365187|emb|OY637518.1| | 2697049 | g13322 | i0 | 100 | 21.0913461538462 | 41 | 0 | 20 | 0 | 1 | 41 | 11672 | 11632 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4387 | 76.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8025231 | 8025231 | PRJNA285816_S_NODE_18207_length_186_cov_5.532847_g18105_i0 | PRJNA285816 | 18207 | 186 | 5.532847 | 10.29109542 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 9.5e-5 | NTclustered | gi|2560517252|emb|OY702345.1| | 2697049 | g18105 | i0 | 100 | 4.98924731182796 | 32 | 0 | 17 | 0 | 155 | 186 | 26488 | 26519 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 928 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9300249 | 9300249 | PRJNA285816_S_NODE_9888_length_232_cov_1.098361_g9786_i0 | PRJNA285816 | 9888 | 232 | 1.098361 | 2.54819752 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 65.8 | 2.66e-6 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g9786 | i0 | 93.333 | 17.3706896551724 | 45 | 2 | 19 | 1 | 1 | 45 | 121051 | 121094 | Orf virus isolate FX17, partial genome | blastn | 4030 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 10576081 | 10576081 | PRJNA285816_S_NODE_6089_length_282_cov_1.562232_g5987_i0 | PRJNA285816 | 6089 | 282 | 1.562232 | 4.40549424 | Paenibacillus phage Pahemo | 2835998 | Viruses | Viruses | 84.2 | 9.22e-12 | NTclustered | gi|2044627981|gb|MW927522.1| | 2835998 | g5987 | i0 | 96.154 | 15.3794326241135 | 52 | 1 | 18 | 1 | 1 | 51 | 41888 | 41939 | Paenibacillus phage Pahemo, complete genome | blastn | 4337 | 84.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fernvirus | Paenibacillus phage Pahemo | ||||
| 12537624 | 12537624 | PRJNA285816_S_NODE_17610_length_189_cov_1.042857_g17508_i0 | PRJNA285816 | 17610 | 189 | 1.042857 | 1.97099973 | Viruses | 10239 | Viruses | Viruses | 71.3 | 4.48e-8 | NTclustered | gi|2167415105|tpg|BK059322.1| | 12271 | g17508 | i0 | 100 | 23.2380952380952 | 38 | 0 | 20 | 0 | 152 | 189 | 39 | 2 | TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence | blastn | 4392 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus arabis | ||
| 13125698 | 13125698 | PRJNA285816_S_NODE_12151_length_215_cov_1.566265_g12049_i0 | PRJNA285816 | 12151 | 215 | 1.566265 | 3.36746975 | Sopawol virus | 3131668 | Viruses | Viruses | 274 | 3.72e-69 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g12049 | i0 | 90.431 | 44.0837209302326 | 209 | 18 | 97 | 2 | 1 | 208 | 325 | 118 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 9478 | 274 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 13125708 | 13125708 | PRJNA285816_S_NODE_12911_length_211_cov_0.962963_g12809_i0 | PRJNA285816 | 12911 | 211 | 0.962963 | 2.03185193 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 8.56e-6 | NTclustered | gi|2557389902|emb|OY653400.1| | 2697049 | g12809 | i0 | 97.368 | 17.0758293838863 | 38 | 0 | 18 | 1 | 175 | 211 | 19642 | 19679 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3603 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16949512 | 16949512 | PRJNA285816_S_NODE_4914_length_309_cov_23.915385_g4812_i0 | PRJNA285816 | 4914 | 309 | 23.915385 | 73.89853965 | Chrocagost virus | 3129398 | Viruses | Viruses | 296 | 1.21e-75 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g4812 | i0 | 88.525 | 202.236245954693 | 244 | 28 | 79 | 0 | 5 | 248 | 5619 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 62491 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 19497843 | 19497843 | PRJNA285816_S_NODE_14416_length_202_cov_36.084967_g14314_i0 | PRJNA285816 | 14416 | 202 | 36.084967 | 72.89163334 | Nepovirus arabis | 3047374 | Viruses | Viruses | 75 | 3.75e-9 | NTclustered | gi|2167415105|tpg|BK059322.1| | 12271 | g14314 | i0 | 97.674 | 19.4207920792079 | 43 | 1 | 21 | 0 | 1 | 43 | 2 | 44 | TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence | blastn | 3923 | 75 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus arabis | ||
| 20773351 | 20773351 | PRJNA285816_S_NODE_10477_length_227_cov_1.191011_g10375_i0 | PRJNA285816 | 10477 | 227 | 1.191011 | 2.70359497 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g10375 | i0 | 100 | 1.36123348017621 | 29 | 0 | 13 | 0 | 199 | 227 | 67828 | 67800 | Orf virus isolate FX10, partial genome | blastn | 309 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 20773655 | 20773655 | PRJNA285816_S_NODE_8097_length_251_cov_1.514851_g7995_i0 | PRJNA285816 | 8097 | 251 | 1.514851 | 3.80227601 | Coguvirus henanense | 3059897 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2058277675|dbj|LC636074.1| | 2034157 | g7995 | i0 | 100 | 0.231075697211155 | 30 | 0 | 12 | 0 | 222 | 251 | 31 | 2 | Watermelon crinkle leaf-associated virus 2 Ju-01-WCLaV2 MP gene for putative movement protein, complete cds | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus henanense | ||
| 21460903 | 21460903 | PRJNA285816_S_NODE_30377_length_154_cov_10.133333_g30275_i0 | PRJNA285816 | 30377 | 154 | 10.133333 | 15.60533282 | root | 1 | Root_unresolved | Root_unresolved | 276 | 6.890000000000001e-70 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g30275 | i0 | 100 | 96.7532467532468 | 149 | 0 | 97 | 0 | 6 | 154 | 15173 | 15025 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 14900 | 276 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 23323897 | 23323897 | PRJNA285816_S_NODE_10839_length_224_cov_1.771429_g10737_i0 | PRJNA285816 | 10839 | 224 | 1.771429 | 3.96800096 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2557646044|emb|OY675404.1| | 2697049 | g10737 | i0 | 100 | 9.12053571428571 | 30 | 0 | 13 | 0 | 195 | 224 | 18438 | 18467 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 2043 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum |
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);;