contig_metadata
6 rows where bioproject = "PRJEB81463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2690451 | 2690451 | PRJEB81463_P_NODE_16443_length_269_cov_5.989796_g16171_i0 | PRJEB81463 | 16443 | 269 | 5.989796 | 16.11255124 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.4e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g16171 | i0 | 90.909 | 0.327137546468401 | 88 | 8 | 33 | 0 | 17 | 104 | 24 | 111 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 88 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 5243013 | 5243013 | PRJEB81463_P_NODE_18265_length_261_cov_1.659574_g17993_i0 | PRJEB81463 | 18265 | 261 | 1.659574 | 4.33148814 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 483 | 7.12e-132 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g17993 | i0 | 100 | 100 | 261 | 0 | 100 | 0 | 1 | 261 | 2753 | 2493 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 26100 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12476276 | 12476276 | PRJEB81463_P_NODE_17870_length_263_cov_1.347368_g17598_i0 | PRJEB81463 | 17870 | 263 | 1.347368 | 3.54357784 | Tobamovirus | 12234 | Viruses | Viruses | 481 | 2.58e-131 | NTclustered | gi|2647550519|gb|OR843964.1| | 12242 | g17598 | i0 | 99.62 | 100 | 263 | 1 | 100 | 0 | 1 | 263 | 2220 | 2482 | Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds | blastn | 26300 | 481 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12893957 | 12893957 | PRJEB81463_P_NODE_18831_length_258_cov_2.232432_g18559_i0 | PRJEB81463 | 18831 | 258 | 2.232432 | 5.75967456 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 477 | 3.2699999999999985e-130 | NTclustered | gi|2578840253|gb|OR564664.1| | 2697049 | g18559 | i0 | 100 | 100 | 258 | 0 | 100 | 0 | 1 | 258 | 22012 | 21755 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/NY-CDC-QDX84542173/2023 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds | blastn | 25800 | 477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17992040 | 17992040 | PRJEB81463_P_NODE_24095_length_247_cov_1.781609_g23823_i0 | PRJEB81463 | 24095 | 247 | 1.781609 | 4.40057423 | Orthoflavivirus zikaense | 3048459 | Viruses | Viruses | 455 | 1.4600000000000002e-123 | NTclustered | gi|1920873795|gb|MW122411.1| | 64320 | g23823 | i0 | 100 | 99.5951417004049 | 246 | 0 | 99 | 0 | 1 | 246 | 7600 | 7845 | Zika virus isolate PR/DB-ZIKV556/2016 polyprotein (POLY) gene, complete cds | blastn | 24600 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus zikaense | ||
| 32808213 | 32808213 | PRJEB81463_P_NODE_7740_length_361_cov_1.885417_g7468_i0 | PRJEB81463 | 7740 | 361 | 1.885417 | 6.80635537 | Chuvivirus | 2842604 | Viruses | Viruses | 162 | 9.56e-45 | NR | UVF58769.1 | 2842604 | g7468 | i0 | 61.3 | 2.96675900277008 | 119 | 46 | 98.9 | 0 | 4 | 360 | 288 | 406 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 1071 | 162 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | 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);;