contig_metadata
8 rows where bioproject = "PRJNA773778" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 750810 | 750810 | PRJNA773778_S_NODE_17161_length_348_cov_8.970909_g17011_i0 | PRJNA773778 | 17161 | 348 | 8.970909 | 31.21876332 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g17011 | i0 | 94.286 | 0.100574712643678 | 35 | 1 | 10 | 1 | 208 | 241 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 3758959 | 3758959 | PRJNA773778_S_NODE_13763_length_380_cov_1.921824_g13613_i0 | PRJNA773778 | 13763 | 380 | 1.921824 | 7.3029312 | root | 1 | Root_unresolved | Root_unresolved | 702 | 0 | NTclustered | gi|2616465679|gb|OR735196.1| | 10515 | g13613 | i0 | 100 | 100 | 380 | 0 | 100 | 0 | 1 | 380 | 3942 | 3563 | Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome | blastn | 38000 | 702 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 6311313 | 6311313 | PRJNA773778_S_NODE_32225_length_275_cov_1.524752_g32075_i0 | PRJNA773778 | 32225 | 275 | 1.524752 | 4.193068 | root | 1 | Root_unresolved | Root_unresolved | 326 | 1.35e-84 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g32075 | i0 | 100 | 100.556363636364 | 176 | 0 | 100 | 0 | 100 | 275 | 1108 | 933 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 27653 | 326 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7585310 | 7585310 | PRJNA773778_S_NODE_23746_length_309_cov_1.118644_g23596_i0 | PRJNA773778 | 23746 | 309 | 1.118644 | 3.45660996 | root | 1 | Root_unresolved | Root_unresolved | 566 | 8.33e-157 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g23596 | i0 | 99.676 | 100 | 309 | 1 | 100 | 0 | 1 | 309 | 1307 | 1615 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 30900 | 571 | 0.991243432574431 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 10135990 | 10135990 | PRJNA773778_S_NODE_488_length_1261_cov_2.370370_g432_i0 | PRJNA773778 | 488 | 1261 | 2.37037 | 29.8903657 | root | 1 | Root_unresolved | Root_unresolved | 2152 | 0 | NTclustered | gi|2616465679|gb|OR735196.1| | 10515 | g432 | i0 | 99.744 | 95.8762886597938 | 1174 | 3 | 96 | 0 | 88 | 1261 | 3508 | 2335 | Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome | blastn | 120900 | 2158 | 0.997219647822057 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20333770 | 20333770 | PRJNA773778_S_NODE_3836_length_600_cov_3.402277_g3690_i0 | PRJNA773778 | 3836 | 600 | 3.402277 | 20.413662 | root | 1 | Root_unresolved | Root_unresolved | 1109 | 0 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g3690 | i0 | 100 | 100.57 | 600 | 0 | 100 | 0 | 1 | 600 | 1722 | 2321 | Unidentified adenovirus strain CHOP Ad5 | blastn | 60342 | 1109 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 22884914 | 22884914 | PRJNA773778_S_NODE_15998_length_358_cov_2.971930_g15848_i0 | PRJNA773778 | 15998 | 358 | 2.97193 | 10.6395094 | Viruses | 10239 | Viruses | Viruses | 62.1 | 5.63e-5 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g15848 | i0 | 100 | 9.91340782122905 | 33 | 0 | 9 | 0 | 1 | 33 | 67619 | 67587 | Orf virus isolate FX10, partial genome | blastn | 3549 | 62.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 25433962 | 25433962 | PRJNA773778_S_NODE_33860_length_270_cov_1.172589_g33710_i0 | PRJNA773778 | 33860 | 270 | 1.172589 | 3.1659903 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g33710 | i0 | 96.97 | 0.244444444444444 | 33 | 1 | 12 | 0 | 238 | 270 | 121085 | 121053 | Orf virus isolate FX17, partial genome | blastn | 66 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf |
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);;