contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3795198 | 3795198 | PRJNA893346_P_NODE_783_length_1670_cov_3.524734_g642_i0 | PRJNA893346 | 783 | 1670 | 3.524734 | 58.8630578 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 944 | 0 | NTclustered | gi|2733713083|gb|PP810550.1| | RQ01 | g642 | i0 | 78.334 | 88.4526946107784 | 1477 | 308 | 88 | 12 | 199 | 1670 | 199 | 1668 | Influenza B virus (B/Michigan/UM-10057023818/2024) segment 5 nucleoprotein (NP) gene, complete cds | blastn | 147716 | 950 | 0.993684210526316 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 8896139 | 8896139 | PRJNA893346_P_NODE_2447_length_1048_cov_6.811282_g2121_i0 | PRJNA893346 | 2447 | 1048 | 6.811282 | 71.38223536 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 438 | 6.9899999999999996e-118 | NTclustered | gi|2413738156|gb|OQ034364.1| | RQ01 | g2121 | i0 | 74.67 | 99.4522900763359 | 1062 | 233 | 100 | 32 | 1 | 1048 | 1053 | 14 | Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 104226 | 438 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11071807 | 11071807 | PRJNA893346_P_NODE_2869_length_973_cov_5.240000_g2509_i0 | PRJNA893346 | 2869 | 973 | 5.24 | 50.9852 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 579 | 3.6599999999999996e-160 | NTclustered | gi|2716343578|gb|PP647745.1| | RQ01 | g2509 | i0 | 80.92 | 82.8232271325796 | 739 | 136 | 76 | 5 | 237 | 973 | 809 | 74 | Influenza B virus (B/California/H20-358-8435_B_MP/2024) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 80587 | 579 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11071996 | 11071996 | PRJNA893346_P_NODE_36669_length_246_cov_0.890173_g36179_i0 | PRJNA893346 | 36669 | 246 | 0.890173 | 2.18982558 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 209 | 1.25e-49 | NTclustered | gi|2915735270|gb|PV141215.1| | RQ01 | g36179 | i0 | 82.427 | 9.66666666666667 | 239 | 42 | 97 | 0 | 8 | 246 | 239 | 1 | Influenza B virus (B/King County/WA-S27676/2019) segment 1 polymerase PB1 (PB1) gene, complete cds | blastn | 2378 | 209 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 15271180 | 15271180 | PRJNA893346_P_NODE_40072_length_241_cov_0.863095_g39582_i0 | PRJNA893346 | 40072 | 241 | 0.863095 | 2.08005895 | Paramyxoviridae | 11158 | Viruses | Viruses | 435 | 1.84e-117 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g39582 | i0 | 99.17 | 80.2448132780083 | 241 | 2 | 100 | 0 | 1 | 241 | 749 | 989 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 19339 | 435 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 18719495 | 18719495 | PRJNA893346_P_NODE_1995_length_1155_cov_4.365065_g1709_i0 | PRJNA893346 | 1995 | 1155 | 4.365065 | 50.41650075 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 625 | 5.529999999999999e-174 | NTclustered | gi|2413738133|gb|OQ034387.1| | RQ01 | g1709 | i0 | 80.143 | 72.8666666666667 | 841 | 163 | 73 | 4 | 317 | 1155 | 839 | 1 | Influenza B virus (B/Michigan/1/1971) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 84161 | 625 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 20369644 | 20369644 | PRJNA893346_P_NODE_716_length_1727_cov_3.243652_g589_i0 | PRJNA893346 | 716 | 1727 | 3.243652 | 56.01787004 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 904 | 0 | NTclustered | gi|4760940|gb|AF100359.1|AF100359 | RQ01 | g589 | i0 | 77.89 | 85.1215981470759 | 1479 | 309 | 85 | 15 | 9 | 1479 | 1661 | 193 | Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds | blastn | 147005 | 904 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus |
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);;