contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA316313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1067751 | 1067751 | PRJNA316313_P_NODE_261121_length_187_cov_2.713333_g259735_i0 | PRJNA316313 | 261121 | 187 | 2.713333 | 5.07393271 | root | 1 | Root_unresolved | Root_unresolved | 141 | 3.32e-29 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g259735 | i0 | 100 | 80.8770053475936 | 76 | 0 | 81 | 0 | 112 | 187 | 12762 | 12837 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 15124 | 141 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7445137 | 7445137 | PRJNA316313_P_NODE_105066_length_201_cov_20.176829_g103680_i0 | PRJNA316313 | 105066 | 201 | 20.176829 | 40.55542629 | root | 1 | Root_unresolved | Root_unresolved | 357 | 3.31e-94 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g103680 | i0 | 99.49 | 97.5124378109453 | 196 | 1 | 98 | 0 | 1 | 196 | 15028 | 15223 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 19600 | 357 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 12546035 | 12546035 | PRJNA316313_P_NODE_19830_length_378_cov_9.310850_g18464_i0 | PRJNA316313 | 19830 | 378 | 9.31085 | 35.195013 | root | 1 | Root_unresolved | Root_unresolved | 185 | 3.4e-42 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g18464 | i0 | 100 | 91.1243386243386 | 100 | 0 | 92 | 0 | 191 | 290 | 18402 | 18303 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 34445 | 185 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16964775 | 16964775 | PRJNA316313_P_NODE_35494_length_294_cov_15.178988_g34113_i0 | PRJNA316313 | 35494 | 294 | 15.178988 | 44.62622472 | Mastadenovirus caesari | 3241411 | Viruses | Viruses | 436 | 6.439999999999999e-118 | NTclustered | gi|1967465804|gb|MT950711.1| | 129951 | g34113 | i0 | 92.359 | 102.380952380952 | 301 | 12 | 99 | 3 | 1 | 291 | 638 | 339 | Human mastadenovirus C isolate HAdV C1 GZ20190527/650 penton base protein gene, partial cds | blastn | 30100 | 436 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20193522 | 20193522 | PRJNA316313_P_NODE_16576_length_412_cov_11.074667_g15223_i0 | PRJNA316313 | 16576 | 412 | 11.074667 | 45.62762804 | root | 1 | Root_unresolved | Root_unresolved | 676 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g15223 | i0 | 97.059 | 99.0291262135922 | 408 | 1 | 99 | 2 | 6 | 412 | 11153 | 11550 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 40800 | 682 | 0.991202346041056 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;