contig_metadata
10 rows where bioproject = "PRJEB28062", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25557 | 25557 | PRJEB28062_P_NODE_8281_length_1364_cov_6.658404_g6818_i0 | PRJEB28062 | 8281 | 1364 | 6.658404 | 90.82063056 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 2401 | 0 | NTclustered | gi|383276899|gb|CY113186.1| | RQ01 | g6818 | i0 | 100 | 95.3079178885631 | 1300 | 0 | 95 | 0 | 1 | 1300 | 1962 | 663 | Influenza A virus (A/Victoria/3/1975(H3N2)) polymerase PA (PA) gene, complete cds | blastn | 130000 | 2401 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 988011 | 988011 | PRJEB28062_S_NODE_1_length_666_cov_4.175207_g0_i0 | PRJEB28062 | 1 | 666 | 4.175207 | 27.80687862 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 966 | 0 | NTclustered | gi|75181074|gb|CY002744.1| | 332746 | g0 | i0 | 99.622 | 79.1351351351351 | 529 | 2 | 79 | 0 | 47 | 575 | 1748 | 1220 | Influenza A virus (A/Memphis/109/1972(H3N2)) hemagglutinin (HA) gene, complete cds | blastn | 52704 | 974 | 0.991786447638604 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 3538614 | 3538614 | PRJEB28062_S_NODE_3_length_326_cov_0.988679_g2_i0 | PRJEB28062 | 3 | 326 | 0.988679 | 3.22309354 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 473 | 5.519999999999999e-129 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g2 | i0 | 99.237 | 80.3466257668712 | 262 | 2 | 80 | 0 | 1 | 262 | 528 | 789 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 26193 | 473 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 4814802 | 4814802 | PRJEB28062_P_NODE_112904_length_278_cov_12.082927_g110541_i0 | PRJEB28062 | 112904 | 278 | 12.082927 | 33.59053706 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 261 | 3.91e-65 | NTclustered | gi|315076809|gb|CY077791.1| | 936107 | g110541 | i0 | 100 | 50.4460431654676 | 141 | 0 | 51 | 0 | 88 | 228 | 142 | 2 | Influenza A virus (A/Bilthoven/1761/1976(H3N2)) polymerase PB2 (PB2) gene, complete cds | blastn | 14024 | 261 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 4815526 | 4815526 | PRJEB28062_P_NODE_62024_length_443_cov_5.694595_g59664_i0 | PRJEB28062 | 62024 | 443 | 5.694595 | 25.22705585 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 520 | 9.769999999999999e-143 | NTclustered | gi|2905074022|gb|PV081923.1| | 11320 | g59664 | i0 | 98.635 | 66.0474040632054 | 293 | 4 | 66 | 0 | 101 | 393 | 122 | 414 | Influenza A virus (A/MDCK serial passage/San Diego/Serial passage/2021(H3N2)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 29259 | 520 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 6090328 | 6090328 | PRJEB28062_P_NODE_18025_length_889_cov_3808.025735_g16047_i0 | PRJEB28062 | 18025 | 889 | 3808.025735 | 33853.34878415 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1386 | 0 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g16047 | i0 | 99.735 | 89.7412823397075 | 756 | 2 | 89 | 0 | 47 | 802 | 1 | 756 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 79780 | 1399 | 0.990707648320229 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 21390038 | 21390038 | PRJEB28062_P_NODE_84117_length_364_cov_0.982818_g81755_i0 | PRJEB28062 | 84117 | 364 | 0.982818 | 3.57745752 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 673 | 0 | NTclustered | gi|13274643|gb|AF258842.1| | 153970 | g81755 | i0 | 100 | 100 | 364 | 0 | 100 | 0 | 1 | 364 | 1203 | 1566 | Influenza A virus (A/Hong Kong/498/97(H3N2)) RNA polymerase (PB2) gene, complete cds | blastn | 36400 | 673 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25213014 | 25213014 | PRJEB28062_P_NODE_10540_length_1191_cov_2824.963327_g8904_i0 | PRJEB28062 | 10540 | 1191 | 2824.963327 | 33645.31322457 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1851 | 0 | NTclustered | gi|392342083|gb|CY121181.1| | 385624 | g8904 | i0 | 99.412 | 90.3610411418976 | 1020 | 6 | 90 | 0 | 99 | 1118 | 1740 | 721 | Influenza A virus (A/Port Chalmers/1/1973(H3N2)) hemagglutinin (HA) gene, complete cds | blastn | 107620 | 1868 | 0.990899357601713 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 27917535 | 27917535 | PRJEB28062_P_NODE_40925_length_567_cov_21.338057_g38591_i0 | PRJEB28062 | 40925 | 567 | 21.338057 | 120.98678319 | Rhizoctonia cerealis bunyavirus | 3068840 | Viruses | Viruses | 56.6 | 6.96e-6 | NR | WMI40170.1 | 3068840 | g38591 | i0 | 26.3 | 0.804232804232804 | 152 | 105 | 79.9 | 2 | 45 | 497 | 84 | 229 | WMI40170.1 MAG: hypothetical protein [Rhizoctonia cerealis bunyavirus] | diamond | 456 | 56.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Rhizoctonia cerealis bunyavirus | ||||
| 29401635 | 29401635 | PRJEB28062_P_NODE_38369_length_589_cov_2.815891_g36042_i0 | PRJEB28062 | 38369 | 589 | 2.815891 | 16.58559799 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 277 | 2.72e-82 | NR | BDR95913.1 | 2979708 | g36042 | i0 | 67.5 | 0.98811544991511 | 194 | 63 | 98.8 | 0 | 584 | 3 | 1112 | 1305 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 582 | 277 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 |
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);;