contig_metadata
11 rows where bioproject = "PRJNA1065838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4840801 | 4840801 | PRJNA1065838_S_NODE_6104_length_301_cov_1.230159_g6002_i0 | PRJNA1065838 | 6104 | 301 | 1.230159 | 3.70277859 | root | 1 | Root_unresolved | Root_unresolved | 556 | 4.87e-154 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g6002 | i0 | 100 | 100 | 301 | 0 | 100 | 0 | 1 | 301 | 16934 | 17234 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 30100 | 556 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7390090 | 7390090 | PRJNA1065838_S_NODE_186_length_1034_cov_4.521827_g130_i0 | PRJNA1065838 | 186 | 1034 | 4.521827 | 46.75569118 | root | 1 | Root_unresolved | Root_unresolved | 1788 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g130 | i0 | 99.897 | 93.9071566731141 | 971 | 1 | 94 | 0 | 1 | 971 | 12131 | 11161 | Human adenovirus 2, complete genome | blastn | 97100 | 1788 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7390435 | 7390435 | PRJNA1065838_S_NODE_4966_length_327_cov_1.672662_g4864_i0 | PRJNA1065838 | 4966 | 327 | 1.672662 | 5.46960474 | root | 1 | Root_unresolved | Root_unresolved | 599 | 8.759999999999997e-167 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g4864 | i0 | 100 | 99.085626911315 | 324 | 0 | 99 | 0 | 1 | 324 | 16066 | 15743 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 32401 | 599 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15040040 | 15040040 | PRJNA1065838_S_NODE_172_length_1071_cov_3.283757_g118_i0 | PRJNA1065838 | 172 | 1071 | 3.283757 | 35.16903747 | root | 1 | Root_unresolved | Root_unresolved | 1853 | 0 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g118 | i0 | 100 | 97.6545284780579 | 1003 | 0 | 94 | 0 | 69 | 1071 | 18376 | 17374 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 104588 | 1853 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15040230 | 15040230 | PRJNA1065838_S_NODE_292_length_881_cov_4.865385_g227_i0 | PRJNA1065838 | 292 | 881 | 4.865385 | 42.86404185 | root | 1 | Root_unresolved | Root_unresolved | 1611 | 0 | NTclustered | gi|15485519|emb|AJ293907.1| | 10515 | g227 | i0 | 99.66 | 100.11350737798 | 882 | 1 | 100 | 2 | 1 | 881 | 562 | 1442 | Human adenovirus type 2 penton gene, isolate Prei | blastn | 88200 | 1611 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 17590135 | 17590135 | PRJNA1065838_S_NODE_15714_length_215_cov_1.716867_g15612_i0 | PRJNA1065838 | 15714 | 215 | 1.716867 | 3.69126405 | root | 1 | Root_unresolved | Root_unresolved | 398 | 2.1099999999999997e-106 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g15612 | i0 | 100 | 100 | 215 | 0 | 100 | 0 | 1 | 215 | 14602 | 14388 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 21500 | 398 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20138697 | 20138697 | PRJNA1065838_S_NODE_11496_length_234_cov_1.659459_g11394_i0 | PRJNA1065838 | 11496 | 234 | 1.659459 | 3.88313406 | root | 1 | Root_unresolved | Root_unresolved | 427 | 2.9799999999999993e-115 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g11394 | i0 | 99.573 | 100 | 234 | 1 | 100 | 0 | 1 | 234 | 12757 | 12524 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 23400 | 427 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20139100 | 20139100 | PRJNA1065838_S_NODE_37676_length_153_cov_2.596154_g37574_i0 | PRJNA1065838 | 37676 | 153 | 2.596154 | 3.97211562 | root | 1 | Root_unresolved | Root_unresolved | 283 | 4.0799999999999995e-72 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g37574 | i0 | 100 | 100 | 153 | 0 | 100 | 0 | 1 | 153 | 14381 | 14229 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 15300 | 283 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22689414 | 22689414 | PRJNA1065838_S_NODE_31018_length_170_cov_2.256198_g30916_i0 | PRJNA1065838 | 31018 | 170 | 2.256198 | 3.8355366 | root | 1 | Root_unresolved | Root_unresolved | 254 | 3.63e-63 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g30916 | i0 | 100 | 80.5882352941177 | 137 | 0 | 81 | 0 | 25 | 161 | 28490 | 28626 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 13700 | 254 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 23964883 | 23964883 | PRJNA1065838_S_NODE_239_length_944_cov_4.068156_g180_i0 | PRJNA1065838 | 239 | 944 | 4.068156 | 38.40339264 | root | 1 | Root_unresolved | Root_unresolved | 1744 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g180 | i0 | 100 | 100.001059322034 | 944 | 0 | 100 | 0 | 1 | 944 | 13712 | 12769 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 94401 | 1744 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25238559 | 25238559 | PRJNA1065838_S_NODE_13000_length_226_cov_1.519774_g12898_i0 | PRJNA1065838 | 13000 | 226 | 1.519774 | 3.43468924 | root | 1 | Root_unresolved | Root_unresolved | 418 | 1.7199999999999998e-112 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g12898 | i0 | 100 | 100 | 226 | 0 | 100 | 0 | 1 | 226 | 11096 | 10871 | Human adenovirus 2, complete genome | blastn | 22600 | 418 | 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);;