contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1121648 | 1121648 | PRJNA550047_P_NODE_46181_length_351_cov_20.388489_g44223_i0 | PRJNA550047 | 46181 | 351 | 20.388489 | 71.56359639 | root | 1 | Root_unresolved | Root_unresolved | 514 | 3.5199999999999997e-141 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g44223 | i0 | 92.033 | 103.680911680912 | 364 | 11 | 99 | 2 | 6 | 351 | 12578 | 12215 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 36392 | 514 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 1122426 | 1122426 | PRJNA550047_P_NODE_8021_length_652_cov_62.601036_g6301_i0 | PRJNA550047 | 8021 | 652 | 62.601036 | 408.15875472 | root | 1 | Root_unresolved | Root_unresolved | 1199 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g6301 | i0 | 99.847 | 99.9907975460123 | 652 | 1 | 100 | 0 | 1 | 652 | 15377 | 14726 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 65194 | 1199 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 13875005 | 13875005 | PRJNA550047_P_NODE_3351_length_1049_cov_12.981557_g2020_i0 | PRJNA550047 | 3351 | 1049 | 12.981557 | 136.17653293 | root | 1 | Root_unresolved | Root_unresolved | 1628 | 0 | NTclustered | gi|2452971169|gb|OQ518290.1| | 10515 | g2020 | i0 | 99.333 | 100.123927550048 | 899 | 6 | 100 | 0 | 151 | 1049 | 16840 | 15942 | Human adenovirus 2 isolate HAdV-C2/USA/2E10/2009, complete genome | blastn | 105030 | 1628 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15148410 | 15148410 | PRJNA550047_P_NODE_1872_length_1565_cov_36.733244_g867_i0 | PRJNA550047 | 1872 | 1565 | 36.733244 | 574.8752686 | root | 1 | Root_unresolved | Root_unresolved | 2881 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g867 | i0 | 100 | 99.6830670926518 | 1560 | 0 | 99 | 0 | 6 | 1565 | 12593 | 14152 | Human adenovirus 2, complete genome | blastn | 156004 | 2881 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15150036 | 15150036 | PRJNA550047_P_NODE_5232_length_800_cov_57.665750_g3672_i0 | PRJNA550047 | 5232 | 800 | 57.66575 | 461.326 | root | 1 | Root_unresolved | Root_unresolved | 1454 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g3672 | i0 | 99.748 | 99.25 | 794 | 1 | 99 | 1 | 3 | 795 | 10861 | 11654 | Human adenovirus 2, complete genome | blastn | 79400 | 1454 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 17698098 | 17698098 | PRJNA550047_P_NODE_15214_length_526_cov_16.311258_g13343_i0 | PRJNA550047 | 15214 | 526 | 16.311258 | 85.79721708 | root | 1 | Root_unresolved | Root_unresolved | 972 | 0 | NTclustered | gi|2452972544|gb|OQ518325.1| | 10515 | g13343 | i0 | 100 | 100.001901140684 | 526 | 0 | 100 | 0 | 1 | 526 | 15913 | 15388 | Human adenovirus 2 isolate HAdV-C2/USA/4M8/2009, complete genome | blastn | 52601 | 972 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 21524282 | 21524282 | PRJNA550047_P_NODE_5737_length_766_cov_30.731602_g4157_i0 | PRJNA550047 | 5737 | 766 | 30.731602 | 235.40407132 | root | 1 | Root_unresolved | Root_unresolved | 1112 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g4157 | i0 | 99.835 | 89.4973890339426 | 605 | 1 | 89 | 0 | 162 | 766 | 11591 | 12195 | Human adenovirus 2, complete genome | blastn | 68555 | 1112 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22797137 | 22797137 | PRJNA550047_P_NODE_12698_length_554_cov_22.255717_g10867_i0 | PRJNA550047 | 12698 | 554 | 22.255717 | 123.29667218 | root | 1 | Root_unresolved | Root_unresolved | 1024 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g10867 | i0 | 100 | 100 | 554 | 0 | 100 | 0 | 1 | 554 | 14682 | 14129 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 55400 | 1024 | 1 | 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);;