contig_metadata
12 rows where bioproject = "PRJNA385073", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2351485 | 2351485 | PRJNA385073_P_NODE_26062_length_290_cov_2.281106_g25900_i0 | PRJNA385073 | 26062 | 290 | 2.281106 | 6.6152074 | root | 1 | Root_unresolved | Root_unresolved | 536 | 6.079999999999999e-148 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g25900 | i0 | 100 | 100 | 290 | 0 | 100 | 0 | 1 | 290 | 13379 | 13090 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 29000 | 536 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3627207 | 3627207 | PRJNA385073_P_NODE_65243_length_199_cov_12.746032_g65081_i0 | PRJNA385073 | 65243 | 199 | 12.746032 | 25.36460368 | root | 1 | Root_unresolved | Root_unresolved | 366 | 5.43e-97 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g65081 | i0 | 100 | 99.4974874371859 | 198 | 0 | 99 | 0 | 1 | 198 | 16191 | 16388 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 19800 | 366 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8728880 | 8728880 | PRJNA385073_P_NODE_34167_length_267_cov_6.278351_g34005_i0 | PRJNA385073 | 34167 | 267 | 6.278351 | 16.76319717 | root | 1 | Root_unresolved | Root_unresolved | 494 | 3.38e-135 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g34005 | i0 | 100 | 100 | 267 | 0 | 100 | 0 | 1 | 267 | 16187 | 15921 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 26700 | 494 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 10004632 | 10004632 | PRJNA385073_P_NODE_6928_length_471_cov_2.409548_g6768_i0 | PRJNA385073 | 6928 | 471 | 2.409548 | 11.34897108 | root | 1 | Root_unresolved | Root_unresolved | 870 | 0 | NTclustered | gi|15485521|emb|AJ293908.1| | 10515 | g6768 | i0 | 100 | 100 | 471 | 0 | 100 | 0 | 1 | 471 | 1182 | 1652 | Human adenovirus type 2 penton gene, isolate 352 | blastn | 47100 | 870 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 11279725 | 11279725 | PRJNA385073_P_NODE_9929_length_408_cov_1.979104_g9768_i0 | PRJNA385073 | 9929 | 408 | 1.979104 | 8.07474432 | root | 1 | Root_unresolved | Root_unresolved | 754 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g9768 | i0 | 100 | 100 | 408 | 0 | 100 | 0 | 1 | 408 | 12168 | 11761 | Human adenovirus 2, complete genome | blastn | 40800 | 754 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 12555139 | 12555139 | PRJNA385073_P_NODE_64790_length_204_cov_4.824427_g64628_i0 | PRJNA385073 | 64790 | 204 | 4.824427 | 9.84183108 | Mastadenovirus | 10509 | Viruses | Viruses | 377 | 2.59e-100 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g64628 | i0 | 100 | 100 | 204 | 0 | 100 | 0 | 1 | 204 | 16781 | 16578 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 20400 | 377 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 18927640 | 18927640 | PRJNA385073_P_NODE_28015_length_284_cov_3.075829_g27853_i0 | PRJNA385073 | 28015 | 284 | 3.075829 | 8.73535436 | root | 1 | Root_unresolved | Root_unresolved | 525 | 1.2899999999999994e-144 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g27853 | i0 | 100 | 100 | 284 | 0 | 100 | 0 | 1 | 284 | 15290 | 15007 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 28400 | 525 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25302435 | 25302435 | PRJNA385073_P_NODE_41080_length_251_cov_1.921348_g40918_i0 | PRJNA385073 | 41080 | 251 | 1.921348 | 4.82258348 | root | 1 | Root_unresolved | Root_unresolved | 464 | 2.47e-126 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g40918 | i0 | 100 | 100 | 251 | 0 | 100 | 0 | 1 | 251 | 12839 | 13089 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 25100 | 464 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 27675700 | 27675700 | PRJNA385073_P_NODE_44144_length_250_cov_0.870056_g43982_i0 | PRJNA385073 | 44144 | 250 | 0.870056 | 2.17514 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 86.3 | 3.66e-18 | NR | DAC81396.1 | 2609864 | g43982 | i0 | 54.9 | 0.984 | 82 | 37 | 98.4 | 0 | 247 | 2 | 7 | 88 | DAC81396.1 TPA_asm: acintoc2 [Pimephales minnow adintovirus] | diamond | 246 | 86.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29538213 | 29538213 | PRJNA385073_P_NODE_30890_length_276_cov_2.753695_g30728_i0 | PRJNA385073 | 30890 | 276 | 2.753695 | 7.6001982 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 54.7 | 3.39e-6 | NR | DAC81393.1 | 2609864 | g30728 | i0 | 54.5 | 2.30434782608696 | 55 | 17 | 54.3 | 2 | 173 | 24 | 250 | 301 | DAC81393.1 TPA_asm: PolB-C [Pimephales minnow adintovirus] | diamond | 636 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30580504 | 30580504 | PRJNA385073_P_NODE_50073_length_246_cov_0.890173_g49911_i0 | PRJNA385073 | 50073 | 246 | 0.890173 | 2.18982558 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 102 | 2.0899999999999994e-23 | NR | DBA48451.1 | 3115912 | g49911 | i0 | 58 | 0.98780487804878 | 81 | 34 | 98.8 | 0 | 2 | 244 | 15 | 95 | DBA48451.1 MAG TPA_asm: Hexon [Adintovirus homo3309] | diamond | 243 | 102 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 31086281 | 31086281 | PRJNA385073_P_NODE_43815_length_250_cov_0.870056_g43653_i0 | PRJNA385073 | 43815 | 250 | 0.870056 | 2.17514 | Mayetiola barley midge adintovirus | 2609858 | Viruses | Viruses | 68.6 | 3.12e-11 | NR | YP_010796966.1 | 2609858 | g43653 | i0 | 45.9 | 2.508 | 74 | 33 | 88.8 | 2 | 29 | 250 | 349 | 415 | YP_010796966.1 PLA2X-adenain [Mayetiola barley midge adintovirus] | diamond | 627 | 68.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Amphintovirales | Eupolintoviridae | Alphadintovirus | Alphadintovirus mayetiola |
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);;