contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3697757 | 3697757 | PRJNA606583_P_NODE_15383_length_323_cov_1.772727_g14954_i0 | PRJNA606583 | 15383 | 323 | 1.772727 | 5.72590821 | root | 1 | Root_unresolved | Root_unresolved | 597 | 3.11e-166 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g14954 | i0 | 100 | 100 | 323 | 0 | 100 | 0 | 1 | 323 | 13072 | 13394 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 32300 | 597 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 6250276 | 6250276 | PRJNA606583_P_NODE_45_length_3029_cov_12.221591_g32_i0 | PRJNA606583 | 45 | 3029 | 12.221591 | 370.19199139 | root | 1 | Root_unresolved | Root_unresolved | 3273 | 0 | NTclustered | gi|2452971169|gb|OQ518290.1| | 10515 | g32 | i0 | 99.888 | 96.8256850445692 | 1779 | 1 | 97 | 1 | 257 | 2035 | 16197 | 14420 | Human adenovirus 2 isolate HAdV-C2/USA/2E10/2009, complete genome | blastn | 293285 | 3273 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7524145 | 7524145 | PRJNA606583_P_NODE_25506_length_220_cov_1.546448_g25077_i0 | PRJNA606583 | 25506 | 220 | 1.546448 | 3.4021856 | root | 1 | Root_unresolved | Root_unresolved | 403 | 4.67e-108 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g25077 | i0 | 100 | 99.0909090909091 | 218 | 0 | 99 | 0 | 1 | 218 | 11986 | 12203 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 21800 | 403 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7524486 | 7524486 | PRJNA606583_P_NODE_9646_length_433_cov_1.277778_g9221_i0 | PRJNA606583 | 9646 | 433 | 1.277778 | 5.53277874 | root | 1 | Root_unresolved | Root_unresolved | 789 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g9221 | i0 | 99.538 | 100 | 433 | 2 | 100 | 0 | 1 | 433 | 12678 | 12246 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 43300 | 789 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8799201 | 8799201 | PRJNA606583_P_NODE_24567_length_227_cov_2.147368_g24138_i0 | PRJNA606583 | 24567 | 227 | 2.147368 | 4.87452536 | root | 1 | Root_unresolved | Root_unresolved | 412 | 8.05e-111 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g24138 | i0 | 100 | 98.2378854625551 | 223 | 0 | 98 | 0 | 1 | 223 | 13415 | 13637 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 22300 | 412 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 10074873 | 10074873 | PRJNA606583_P_NODE_25868_length_217_cov_3.127778_g25439_i0 | PRJNA606583 | 25868 | 217 | 3.127778 | 6.78727826 | root | 1 | Root_unresolved | Root_unresolved | 193 | 1.0800000000000001e-44 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g25439 | i0 | 99.074 | 94.3870967741936 | 108 | 0 | 94 | 1 | 1 | 107 | 11550 | 11443 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 20482 | 193 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22823626 | 22823626 | PRJNA606583_P_NODE_24218_length_230_cov_1.212435_g23789_i0 | PRJNA606583 | 24218 | 230 | 1.212435 | 2.7886005 | root | 1 | Root_unresolved | Root_unresolved | 414 | 2.27e-111 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g23789 | i0 | 99.13 | 100 | 230 | 2 | 100 | 0 | 1 | 230 | 12886 | 13115 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 23000 | 414 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22823630 | 22823630 | PRJNA606583_P_NODE_24798_length_225_cov_2.585106_g24369_i0 | PRJNA606583 | 24798 | 225 | 2.585106 | 5.8164885 | root | 1 | Root_unresolved | Root_unresolved | 416 | 6.159999999999998e-112 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g24369 | i0 | 100 | 100 | 225 | 0 | 100 | 0 | 1 | 225 | 12005 | 11781 | Human adenovirus 2, complete genome | blastn | 22500 | 416 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22823773 | 22823773 | PRJNA606583_P_NODE_33018_length_179_cov_15.964789_g32589_i0 | PRJNA606583 | 33018 | 179 | 15.964789 | 28.57697231 | root | 1 | Root_unresolved | Root_unresolved | 206 | 1.0999999999999999e-48 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g32589 | i0 | 87.437 | 111.173184357542 | 199 | 0 | 97 | 3 | 1 | 174 | 18302 | 18500 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 19900 | 206 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 24098413 | 24098413 | PRJNA606583_P_NODE_42899_length_150_cov_1.575221_g42470_i0 | PRJNA606583 | 42899 | 150 | 1.575221 | 2.3628315 | root | 1 | Root_unresolved | Root_unresolved | 272 | 8.609999999999998e-69 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g42470 | i0 | 99.338 | 100.666666666667 | 151 | 0 | 100 | 1 | 1 | 150 | 12759 | 12909 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 15100 | 272 | 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);;