contig_metadata
13 rows where bioproject = "PRJEB75017" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2685431 | 2685431 | PRJEB75017_P_NODE_17863_length_243_cov_0.917647_g17734_i0 | PRJEB75017 | 17863 | 243 | 0.917647 | 2.22988221 | Alphavirus chikungunya | 3426298 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|1194463477|gb|KY435472.1| | 37124 | g17734 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 10850 | 10608 | Chikungunya virus isolate 14.02560 non-structural polypeptide and structural polypeptide genes, complete cds | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 8648713 | 8648713 | PRJEB75017_P_NODE_17787_length_243_cov_1.800000_g17658_i0 | PRJEB75017 | 17787 | 243 | 1.8 | 4.374 | root | 1 | Root_unresolved | Root_unresolved | 449 | 6.65e-122 | NTclustered | gi|27447413|gb|AY102920.1| | 11276 | g17658 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 1542 | 1300 | Vesicular stomatitis virus serotype Indiana panhandle-type defective interfering particle Ind-ST | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 11198881 | 11198881 | PRJEB75017_P_NODE_4329_length_421_cov_1.117816_g4200_i0 | PRJEB75017 | 4329 | 421 | 1.117816 | 4.70600536 | root | 1 | Root_unresolved | Root_unresolved | 778 | 0 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g4200 | i0 | 100 | 99.9857482185273 | 421 | 0 | 100 | 0 | 1 | 421 | 2566 | 2986 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 42094 | 778 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 11198890 | 11198890 | PRJEB75017_P_NODE_9309_length_297_cov_1.392857_g9180_i0 | PRJEB75017 | 9309 | 297 | 1.392857 | 4.13678529 | root | 1 | Root_unresolved | Root_unresolved | 549 | 8.029999999999997e-152 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g9180 | i0 | 100 | 100 | 297 | 0 | 100 | 0 | 1 | 297 | 8098 | 8394 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 29700 | 549 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 12888972 | 12888972 | PRJEB75017_P_NODE_7111_length_335_cov_0.839695_g6982_i0 | PRJEB75017 | 7111 | 335 | 0.839695 | 2.81297825 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 614 | 3.209999999999999e-171 | NTclustered | gi|2441312974|gb|OQ403814.1| | 2697049 | g6982 | i0 | 99.701 | 100 | 335 | 1 | 100 | 0 | 1 | 335 | 11441 | 11775 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/MD-CDC-LC1001502/2023, complete genome | blastn | 33500 | 614 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15023483 | 15023483 | PRJEB75017_P_NODE_18072_length_243_cov_0.917647_g17943_i0 | PRJEB75017 | 18072 | 243 | 0.917647 | 2.22988221 | root | 1 | Root_unresolved | Root_unresolved | 449 | 6.65e-122 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g17943 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 724 | 482 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 17986879 | 17986879 | PRJEB75017_P_NODE_10835_length_280_cov_10.033816_g10706_i0 | PRJEB75017 | 10835 | 280 | 10.033816 | 28.0946848 | Mitovirus sp. | 2587224 | Viruses | Viruses | 124 | 5.39e-24 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g10706 | i0 | 92.045 | 0.314285714285714 | 88 | 7 | 31 | 0 | 173 | 260 | 111 | 24 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 88 | 124 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 17986890 | 17986890 | PRJEB75017_P_NODE_12035_length_269_cov_1.321429_g11906_i0 | PRJEB75017 | 12035 | 269 | 1.321429 | 3.55464401 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 497 | 2.63e-136 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g11906 | i0 | 100 | 100 | 269 | 0 | 100 | 0 | 1 | 269 | 24586 | 24318 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 26900 | 497 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18847296 | 18847296 | PRJEB75017_P_NODE_9575_length_293_cov_1.854545_g9446_i0 | PRJEB75017 | 9575 | 293 | 1.854545 | 5.43381685 | root | 1 | Root_unresolved | Root_unresolved | 536 | 6.149999999999998e-148 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g9446 | i0 | 99.659 | 100 | 293 | 1 | 100 | 0 | 1 | 293 | 6685 | 6977 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 29300 | 536 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 20122073 | 20122073 | PRJEB75017_P_NODE_11496_length_274_cov_1.631841_g11367_i0 | PRJEB75017 | 11496 | 274 | 1.631841 | 4.47124434 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.08e-137 | NTclustered | gi|27447413|gb|AY102920.1| | 11276 | g11367 | i0 | 99.635 | 100 | 274 | 1 | 100 | 0 | 1 | 274 | 161 | 434 | Vesicular stomatitis virus serotype Indiana panhandle-type defective interfering particle Ind-ST | blastn | 27400 | 501 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 21812088 | 21812088 | PRJEB75017_P_NODE_12858_length_261_cov_1.260638_g12729_i0 | PRJEB75017 | 12858 | 261 | 1.260638 | 3.29026518 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 483 | 7.12e-132 | NTclustered | gi|2486544531|gb|OP232863.2| | 2697049 | g12729 | i0 | 100 | 100 | 261 | 0 | 100 | 0 | 1 | 261 | 1736 | 1476 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/UT-UPHL-220730839479/2022 ORF1ab polyprotein (ORF1ab) and ORF1a polyprotein (ORF1ab) genes, partial cds; and surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds | blastn | 26100 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 27097307 | 27097307 | PRJEB75017_P_NODE_562_length_1091_cov_1.584479_g485_i0 | PRJEB75017 | 562 | 1091 | 1.584479 | 17.28666589 | Inner Mongolia sediment arena-like virus | 2824520 | Viruses | Viruses | 135 | 6.1e-31 | NR | YP_010840782.1 | 2824520 | g485 | i0 | 26.9 | 0.98166819431714 | 357 | 244 | 97.3 | 8 | 25 | 1086 | 213 | 555 | YP_010840782.1 MAG: putative glycoprotein [Inner Mongolia sediment arena-like virus] | diamond | 1071 | 135 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Arenaviridae | Inner Mongolia sediment arena-like virus | |||
| 30280119 | 30280119 | PRJEB75017_P_NODE_12712_length_262_cov_1.650794_g12583_i0 | PRJEB75017 | 12712 | 262 | 1.650794 | 4.32508028 | Chuvivirus | 2842604 | Viruses | Viruses | 105 | 3.29e-24 | NR | WET19887.1 | 2842604 | g12583 | i0 | 61.6 | 1.96946564885496 | 86 | 33 | 98.5 | 0 | 260 | 3 | 261 | 346 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 516 | 105 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;