contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1228956 | 1228956 | PRJNA833575_P_NODE_3361_length_753_cov_2.055556_g3246_i0 | PRJNA833575 | 3361 | 753 | 2.055556 | 15.47833668 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1339 | 0 | NTclustered | gi|1377224815|gb|MH201219.1| | 11320 | g3246 | i0 | 98.56 | 101.418326693227 | 764 | 0 | 100 | 1 | 1 | 753 | 2276 | 1513 | Influenza A virus (A/PR/8_RGCDC-4,6/34(H1N1)) segment 2 polymerase PB1 (PB1) and PB1-F2 protein (PB1-F2) genes, complete cds | blastn | 76368 | 1339 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 2504646 | 2504646 | PRJNA833575_P_NODE_5042_length_626_cov_2.001795_g4908_i0 | PRJNA833575 | 5042 | 626 | 2.001795 | 12.5312367 | root | 1 | Root_unresolved | Root_unresolved | 1149 | 0 | NTclustered | gi|1480163907|gb|MH785012.1| | 211044 | g4908 | i0 | 99.84 | 98.111821086262 | 625 | 1 | 99 | 0 | 2 | 626 | 2 | 626 | Influenza A virus (A/Puerto Rico/8/1934(H1N1)) segment 7 matrix protein 2 (M2) and matrix protein 1 (M1) genes, complete cds | blastn | 61418 | 1149 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 5056729 | 5056729 | PRJNA833575_P_NODE_12924_length_404_cov_1.758209_g12787_i0 | PRJNA833575 | 12924 | 404 | 1.758209 | 7.10316436 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 717 | 0 | NTclustered | gi|2922556329|gb|PV225275.1| | 11320 | g12787 | i0 | 98.759 | 91.7079207920792 | 403 | 5 | 99 | 0 | 2 | 404 | 404 | 2 | Influenza A virus (A/Black-faced bunting/Shandong/T167/2022(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 37050 | 723 | 0.991701244813278 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 9752290 | 9752290 | PRJNA833575_P_NODE_2588_length_845_cov_3.382732_g2486_i0 | PRJNA833575 | 2588 | 845 | 3.382732 | 28.5840854 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1555 | 0 | NTclustered | gi|323362934|gb|CY083002.1| | RQ01 | g2486 | i0 | 99.882 | 98.7195266272189 | 845 | 1 | 100 | 0 | 1 | 845 | 846 | 2 | Influenza A virus (A/swine/KU/8/2001(H1N1)) nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 83418 | 1555 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 10157329 | 10157329 | PRJNA833575_P_NODE_20088_length_329_cov_1.823077_g19951_i0 | PRJNA833575 | 20088 | 329 | 1.823077 | 5.99792333 | root | 1 | Root_unresolved | Root_unresolved | 608 | 1.4599999999999995e-169 | NTclustered | gi|2778013722|gb|PQ074142.1| | 11320 | g19951 | i0 | 100 | 100 | 329 | 0 | 100 | 0 | 1 | 329 | 736 | 408 | Influenza A virus (A/Israel/16/2023(H1N1)) segment 6 neuraminidase (NA) gene, partial cds | blastn | 32900 | 608 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 11027967 | 11027967 | PRJNA833575_P_NODE_23709_length_305_cov_1.461864_g23572_i0 | PRJNA833575 | 23709 | 305 | 1.461864 | 4.4586852 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|1480163920|gb|MH785017.1| | RQ01 | g23572 | i0 | 100 | 100 | 305 | 0 | 100 | 0 | 1 | 305 | 932 | 1236 | Influenza A virus (A/Puerto Rico/8/1934(H1N1)) segment 2 polymerase PB1 (PB1) and PB1-F2 protein (PB1-F2) genes, complete cds | blastn | 30500 | 564 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11028155 | 11028155 | PRJNA833575_P_NODE_34529_length_251_cov_1.500000_g34392_i0 | PRJNA833575 | 34529 | 251 | 1.5 | 3.765 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 390 | 4.239999999999999e-104 | NTclustered | gi|325026|gb|K00853.1|FLAS10M | RQ01 | g34392 | i0 | 94.007 | 100.227091633466 | 267 | 0 | 100 | 3 | 1 | 251 | 14 | 280 | Influenza A/Puerto Rico/8/34 (H1N1), subgenomic RNA 10 (from seg 1), in defective interfering virus | blastn | 25157 | 390 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11432907 | 11432907 | PRJNA833575_P_NODE_549_length_1550_cov_7.201891_g519_i0 | PRJNA833575 | 549 | 1550 | 7.201891 | 111.6293105 | Viruses | 10239 | Viruses | Viruses | 2830 | 0 | NTclustered | gi|1352367018|gb|MH006711.1| | 11320 | g519 | i0 | 99.741 | 98.8574193548387 | 1544 | 4 | 99 | 0 | 1 | 1544 | 1544 | 1 | Influenza A virus (A/swine/Michoacan/MichDMZC10/2015(H1N1)) segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 153229 | 2852 | 0.992286115007013 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 15256839 | 15256839 | PRJNA833575_P_NODE_20732_length_325_cov_0.746094_g20595_i0 | PRJNA833575 | 20732 | 325 | 0.746094 | 2.4248055 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 590 | 5.2299999999999986e-164 | NTclustered | gi|1352367010|gb|MH006708.1| | 11320 | g20595 | i0 | 99.385 | 100 | 325 | 2 | 100 | 0 | 1 | 325 | 798 | 474 | Influenza A virus (A/swine/Michoacan/MichDMZC10/2015(H1N1)) segment 2 polymerase PB1 (PB1) and PB1-F2 protein (PB1-F2) genes, complete cds | blastn | 32500 | 595 | 0.991596638655462 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 16531809 | 16531809 | PRJNA833575_P_NODE_9653_length_461_cov_2.543367_g9516_i0 | PRJNA833575 | 9653 | 461 | 2.543367 | 11.72492187 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 830 | 0 | NTclustered | gi|1377224815|gb|MH201219.1| | 11320 | g9516 | i0 | 99.56 | 98.0281995661605 | 455 | 2 | 99 | 0 | 6 | 460 | 455 | 1 | Influenza A virus (A/PR/8_RGCDC-4,6/34(H1N1)) segment 2 polymerase PB1 (PB1) and PB1-F2 protein (PB1-F2) genes, complete cds | blastn | 45191 | 837 | 0.991636798088411 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 18675942 | 18675942 | PRJNA833575_P_NODE_555_length_1545_cov_4.345528_g524_i0 | PRJNA833575 | 555 | 1545 | 4.345528 | 67.1384076 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 2854 | 0 | NTclustered | gi|1480163905|gb|MH785011.1| | RQ01 | g524 | i0 | 100 | 97.9870550161812 | 1545 | 0 | 100 | 0 | 1 | 1545 | 6 | 1550 | Influenza A virus (A/Puerto Rico/8/1934(H1N1)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 151390 | 2854 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 19080554 | 19080554 | PRJNA833575_P_NODE_32455_length_260_cov_2.513089_g32318_i0 | PRJNA833575 | 32455 | 260 | 2.513089 | 6.5340314 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 481 | 2.55e-131 | NTclustered | gi|2046376638|gb|MZ310488.1| | 11320 | g32318 | i0 | 100 | 99.4807692307692 | 260 | 0 | 100 | 0 | 1 | 260 | 271 | 12 | Influenza A virus (A/Puerto Rico/8/1934(H1N1)) segment 3 polymerase PA (PA) and PA-X protein (PA-X) genes, complete cds | blastn | 25865 | 481 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 22906246 | 22906246 | PRJNA833575_P_NODE_11598_length_424_cov_2.098592_g11461_i0 | PRJNA833575 | 11598 | 424 | 2.098592 | 8.89803008 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2194323927|gb|OM679435.1| | 11320 | g11461 | i0 | 99.292 | 99.9952830188679 | 424 | 3 | 100 | 0 | 1 | 424 | 1544 | 1121 | Influenza A virus (A/South Korea/MDCK/2021(H1N1)) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 42398 | 773 | 0.992238033635188 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25050739 | 25050739 | PRJNA833575_P_NODE_39840_length_233_cov_1.756098_g39703_i0 | PRJNA833575 | 39840 | 233 | 1.756098 | 4.09170834 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 398 | 2.32e-106 | NTclustered | gi|55139140|gb|AY768951.1| | RQ01 | g39703 | i0 | 99.541 | 93.3690987124464 | 218 | 1 | 94 | 0 | 16 | 233 | 1 | 218 | Influenza A virus (A/Puerto Rico/8/34/Mount Sinai/Wi(H1N1)) matrix protein 2 mRNA, partial cds | blastn | 21755 | 398 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | 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);;