contig_metadata
15 rows where 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 | ||
| 30961335 | 30961335 | PRJNA493632_P_NODE_314394_length_291_cov_1.059633_g310955_i0 | PRJNA493632 | 314394 | 291 | 1.059633 | 3.08353203 | Mayetiola barley midge adintovirus | 2609858 | Viruses | Viruses | 94.4 | 2.79e-20 | NR | YP_010796966.1 | 2609858 | g310955 | i0 | 47.4 | 0.979381443298969 | 95 | 47 | 94.8 | 3 | 12 | 287 | 301 | 395 | YP_010796966.1 PLA2X-adenain [Mayetiola barley midge adintovirus] | diamond | 285 | 94.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Amphintovirales | Eupolintoviridae | Alphadintovirus | Alphadintovirus mayetiola | ||
| 30961444 | 30961444 | PRJNA493632_P_NODE_632654_length_243_cov_0.864706_g629213_i0 | PRJNA493632 | 632654 | 243 | 0.864706 | 2.10123558 | Mayetiola barley midge adintovirus | 2609858 | Viruses | Viruses | 60.1 | 2.74e-8 | NR | YP_010796966.1 | 2609858 | g629213 | i0 | 46.9 | 0.790123456790123 | 64 | 27 | 79 | 2 | 229 | 38 | 360 | 416 | YP_010796966.1 PLA2X-adenain [Mayetiola barley midge adintovirus] | diamond | 192 | 60.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Amphintovirales | Eupolintoviridae | Alphadintovirus | Alphadintovirus mayetiola | ||
| 32384486 | 32384486 | PRJNA493632_P_NODE_336459_length_286_cov_1.211268_g333020_i0 | PRJNA493632 | 336459 | 286 | 1.211268 | 3.46422648 | Adintovirus macaca128 | 3115921 | Viruses | Viruses | 56.2 | 1.08e-6 | NR | DBA46384.1 | 3115921 | g333020 | i0 | 47.6 | 2.41258741258741 | 82 | 39 | 81.8 | 2 | 50 | 283 | 165 | 246 | DBA46384.1 MAG TPA_asm: PLA2X-Adenain [Adintovirus macaca12800] | diamond | 690 | 56.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus macaca12800 | |||
| 32416336 | 32416336 | PRJNA493632_P_NODE_553279_length_248_cov_0.880000_g549840_i0 | PRJNA493632 | 553279 | 248 | 0.88 | 2.1824 | Megastigmus wasp adintovirus | 2609859 | Viruses | Viruses | 56.2 | 6.07e-7 | NR | DAC81333.1 | 2609859 | g549840 | i0 | 54.9 | 0.616935483870968 | 51 | 22 | 61.7 | 1 | 94 | 246 | 230 | 279 | DAC81333.1 TPA_asm: integrase [Megastigmus wasp adintovirus] | diamond | 153 | 56.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Megastigmus wasp adintovirus | |||
| 32636980 | 32636980 | PRJNA493632_P_NODE_301120_length_295_cov_2.063063_g297682_i0 | PRJNA493632 | 301120 | 295 | 2.063063 | 6.08603585 | Adintovirus puccinia15 | 3115942 | Viruses | Viruses | 97.4 | 1.76e-22 | NR | DBA48638.1 | 3115942 | g297682 | i0 | 50 | 2.43050847457627 | 80 | 39 | 80.3 | 1 | 3 | 239 | 156 | 235 | DBA48638.1 MAG TPA_asm: PacK [Adintovirus puccinia15046] | diamond | 717 | 97.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus puccinia15046 | |||
| 32700126 | 32700126 | PRJNA493632_P_NODE_383660_length_275_cov_4.450495_g380221_i0 | PRJNA493632 | 383660 | 275 | 4.450495 | 12.23886125 | Mayetiola barley midge adintovirus | 2609858 | Viruses | Viruses | 74.3 | 2.27e-13 | NR | YP_010796970.1 | 2609858 | g380221 | i0 | 44.3 | 1.76727272727273 | 79 | 44 | 86.2 | 0 | 34 | 270 | 2 | 80 | YP_010796970.1 integrase [Mayetiola barley midge adintovirus] | diamond | 486 | 74.3 | 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);;