contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2266563 | 2266563 | PRJEB50332_P_NODE_6422_length_247_cov_2.236559_g6340_i0 | PRJEB50332 | 6422 | 247 | 2.236559 | 5.52430073 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.05e-124 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g6340 | i0 | 100 | 100.016194331984 | 247 | 0 | 100 | 0 | 1 | 247 | 14171 | 13925 | Human adenovirus 2, complete genome | blastn | 24704 | 457 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3541804 | 3541804 | PRJEB50332_P_NODE_4763_length_278_cov_1.497696_g4681_i0 | PRJEB50332 | 4763 | 278 | 1.497696 | 4.16359488 | root | 1 | Root_unresolved | Root_unresolved | 514 | 2.7199999999999996e-141 | NTclustered | gi|15485521|emb|AJ293908.1| | 10515 | g4681 | i0 | 100 | 100 | 278 | 0 | 100 | 0 | 1 | 278 | 1218 | 1495 | Human adenovirus type 2 penton gene, isolate 352 | blastn | 27800 | 514 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8644387 | 8644387 | PRJEB50332_P_NODE_1767_length_421_cov_2.075000_g1686_i0 | PRJEB50332 | 1767 | 421 | 2.075 | 8.73575 | root | 1 | Root_unresolved | Root_unresolved | 773 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g1686 | i0 | 99.762 | 100 | 421 | 1 | 100 | 0 | 1 | 421 | 16100 | 15680 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 42100 | 773 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16293980 | 16293980 | PRJEB50332_P_NODE_173_length_1188_cov_5.050577_g135_i0 | PRJEB50332 | 173 | 1188 | 5.050577 | 60.00085476 | root | 1 | Root_unresolved | Root_unresolved | 2194 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g135 | i0 | 100 | 100.000841750842 | 1188 | 0 | 100 | 0 | 1 | 1188 | 12693 | 13880 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 118801 | 2194 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16294028 | 16294028 | PRJEB50332_P_NODE_593_length_703_cov_12.825545_g523_i0 | PRJEB50332 | 593 | 703 | 12.825545 | 90.16358135 | root | 1 | Root_unresolved | Root_unresolved | 1279 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g523 | i0 | 99.714 | 99.4310099573257 | 699 | 1 | 99 | 1 | 1 | 698 | 11559 | 10861 | Human adenovirus 2, complete genome | blastn | 69900 | 1279 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22668192 | 22668192 | PRJEB50332_P_NODE_378_length_840_cov_12.636714_g325_i0 | PRJEB50332 | 378 | 840 | 12.636714 | 106.1483976 | root | 1 | Root_unresolved | Root_unresolved | 1543 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g325 | i0 | 100 | 99.4047619047619 | 835 | 0 | 99 | 0 | 1 | 835 | 14389 | 15223 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 83500 | 1543 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 23943530 | 23943530 | PRJEB50332_P_NODE_1319_length_477_cov_4.139423_g1238_i0 | PRJEB50332 | 1319 | 477 | 4.139423 | 19.74504771 | root | 1 | Root_unresolved | Root_unresolved | 881 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g1238 | i0 | 100 | 100 | 477 | 0 | 100 | 0 | 1 | 477 | 12730 | 12254 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 47700 | 881 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 23943545 | 23943545 | PRJEB50332_P_NODE_15639_length_206_cov_0.896552_g15557_i0 | PRJEB50332 | 15639 | 206 | 0.896552 | 1.84689712 | root | 1 | Root_unresolved | Root_unresolved | 374 | 3.3799999999999997e-99 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g15557 | i0 | 100 | 98.0582524271845 | 202 | 0 | 98 | 0 | 1 | 202 | 16617 | 16416 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 20200 | 374 | 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);;