contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1101876 | 1101876 | PRJNA493632_P_NODE_317201_length_290_cov_1.557604_g313762_i0 | PRJNA493632 | 317201 | 290 | 1.557604 | 4.5170516 | root | 1 | Root_unresolved | Root_unresolved | 503 | 6.17e-138 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g313762 | i0 | 97.931 | 100 | 290 | 6 | 100 | 0 | 1 | 290 | 16471 | 16182 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 29000 | 503 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 4932212 | 4932212 | PRJNA493632_P_NODE_689184_length_231_cov_3.202532_g685743_i0 | PRJNA493632 | 689184 | 231 | 3.202532 | 7.39784892 | root | 1 | Root_unresolved | Root_unresolved | 425 | 1.0599999999999999e-114 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g685743 | i0 | 100 | 99.5627705627706 | 230 | 0 | 99 | 0 | 1 | 230 | 4067 | 3838 | Unidentified adenovirus strain CHOP Ad5 | blastn | 22999 | 425 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 4932657 | 4932657 | PRJNA493632_P_NODE_98944_length_456_cov_4.791123_g95548_i0 | PRJNA493632 | 98944 | 456 | 4.791123 | 21.84752088 | root | 1 | Root_unresolved | Root_unresolved | 843 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g95548 | i0 | 100 | 100.008771929825 | 456 | 0 | 100 | 0 | 1 | 456 | 14419 | 13964 | Human adenovirus 2, complete genome | blastn | 45604 | 843 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 5568266 | 5568266 | PRJNA493632_P_NODE_483265_length_255_cov_2.159341_g479826_i0 | PRJNA493632 | 483265 | 255 | 2.159341 | 5.50631955 | Adintovirus anguilla10665 | 3115889 | Viruses | Viruses | 169 | 2.2e-37 | NTclustered | gi|1821957815|tpg|BK011011.1| | 3115889 | g479826 | i0 | 95.283 | 3.55294117647059 | 106 | 5 | 42 | 0 | 1 | 106 | 5911 | 5806 | TPA_asm: Strongylocentrotus sea urchin adintovirus strain 0195 genomic sequence | blastn | 906 | 169 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus anguilla10665 | |||
| 7481274 | 7481274 | PRJNA493632_P_NODE_53246_length_589_cov_4.531008_g49995_i0 | PRJNA493632 | 53246 | 589 | 4.531008 | 26.68763712 | root | 1 | Root_unresolved | Root_unresolved | 1077 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g49995 | i0 | 99.66 | 100 | 589 | 2 | 100 | 0 | 1 | 589 | 11753 | 12341 | Human adenovirus 2, complete genome | blastn | 58900 | 1077 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8756442 | 8756442 | PRJNA493632_P_NODE_587_length_3238_cov_9.303318_g319_i0 | PRJNA493632 | 587 | 3238 | 9.303318 | 301.24143684 | root | 1 | Root_unresolved | Root_unresolved | 3273 | 0 | NTclustered | gi|2452971169|gb|OQ518290.1| | 10515 | g319 | i0 | 99.888 | 97.3208770846201 | 1779 | 1 | 97 | 1 | 1215 | 2993 | 14420 | 16197 | Human adenovirus 2 isolate HAdV-C2/USA/2E10/2009, complete genome | blastn | 315125 | 3273 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 10031242 | 10031242 | PRJNA493632_P_NODE_47388_length_619_cov_2.430403_g44172_i0 | PRJNA493632 | 47388 | 619 | 2.430403 | 15.04419457 | root | 1 | Root_unresolved | Root_unresolved | 1101 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g44172 | i0 | 99.833 | 96.7689822294023 | 599 | 1 | 97 | 0 | 1 | 599 | 13035 | 13633 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 59900 | 1101 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 18953494 | 18953494 | PRJNA493632_P_NODE_31895_length_733_cov_2.633333_g28938_i0 | PRJNA493632 | 31895 | 733 | 2.633333 | 19.30233089 | root | 1 | Root_unresolved | Root_unresolved | 1332 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g28938 | i0 | 99.456 | 100.272851296044 | 735 | 0 | 100 | 3 | 1 | 733 | 13084 | 12352 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 73500 | 1332 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25328654 | 25328654 | PRJNA493632_P_NODE_381200_length_276_cov_1.694581_g377761_i0 | PRJNA493632 | 381200 | 276 | 1.694581 | 4.67704356 | root | 1 | Root_unresolved | Root_unresolved | 348 | 2.8900000000000004e-91 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g377761 | i0 | 99.476 | 85.8695652173913 | 191 | 1 | 83 | 0 | 86 | 276 | 11499 | 11689 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 23700 | 348 | 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);;