contig_metadata
9 rows where bioproject = "PRJEB12982", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985709 | 985709 | PRJEB12982_P_NODE_641_length_1001_cov_19.754202_g546_i0 | PRJEB12982 | 641 | 1001 | 19.754202 | 197.73956202 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1836 | 0 | NTclustered | gi|2164748429|gb|OL831185.1| | 11320 | g546 | i0 | 99.8 | 99.2997002997003 | 1000 | 2 | 99 | 0 | 2 | 1001 | 5 | 1004 | Influenza A virus (A/India/H1N1-P2/2020(H1N1)) segment 7 matrix protein 2 (M2) and matrix protein 1 (M1) genes, complete cds | blastn | 99399 | 1836 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 6088820 | 6088820 | PRJEB12982_P_NODE_825_length_871_cov_60.521898_g712_i0 | PRJEB12982 | 825 | 871 | 60.521898 | 527.14573158 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1605 | 0 | NTclustered | gi|324878|gb|M12597.1|FLANSW | 382835 | g712 | i0 | 100 | 98.7336394948335 | 869 | 0 | 99 | 0 | 1 | 869 | 869 | 1 | Influenza A virus (A/WSN/1933(H1N1)) nonstructural protein 1 gene, complete cds | blastn | 85997 | 1605 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 9913859 | 9913859 | PRJEB12982_P_NODE_228_length_1548_cov_61.446298_g189_i0 | PRJEB12982 | 228 | 1548 | 61.446298 | 951.18869304 | root | 1 | Root_unresolved | Root_unresolved | 2846 | 0 | NTclustered | gi|2164728774|gb|OL831136.1| | 11320 | g189 | i0 | 99.935 | 99.1395348837209 | 1544 | 1 | 99 | 0 | 5 | 1548 | 1 | 1544 | Influenza A virus (A/India/H1N1p2/2020(H1N1)) segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 153468 | 2848 | 0.999297752808989 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 12464834 | 12464834 | PRJEB12982_P_NODE_3690_length_398_cov_11.593123_g3527_i0 | PRJEB12982 | 3690 | 398 | 11.593123 | 46.14062954 | root | 1 | Root_unresolved | Root_unresolved | 462 | 1.4899999999999998e-125 | NTclustered | gi|94960382|gb|CY010793.1| | 370129 | g3527 | i0 | 100 | 96.2211055276382 | 250 | 0 | 96 | 0 | 149 | 398 | 1946 | 2195 | Influenza A virus (A/WSN/1933 TS61(H1N1)) segment 3, complete sequence | blastn | 38296 | 462 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 13739138 | 13739138 | PRJEB12982_P_NODE_71_length_2209_cov_5.237963_g59_i0 | PRJEB12982 | 71 | 2209 | 5.237963 | 115.70660267 | root | 1 | Root_unresolved | Root_unresolved | 4052 | 0 | NTclustered | gi|2164728769|gb|OL831134.1| | 11320 | g59 | i0 | 99.819 | 99.4889090086012 | 2206 | 4 | 99 | 0 | 4 | 2209 | 1 | 2206 | Influenza A virus (A/India/H1N1p2/2020(H1N1)) segment 3 polymerase PA (PA) and PA-X protein (PA-X) genes, complete cds | blastn | 219771 | 4074 | 0.994599901816397 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 18837497 | 18837497 | PRJEB12982_P_NODE_315_length_1371_cov_15.780635_g258_i0 | PRJEB12982 | 315 | 1371 | 15.780635 | 216.35250585 | root | 1 | Root_unresolved | Root_unresolved | 2483 | 0 | NTclustered | gi|2164728776|gb|OL831137.1| | 11320 | g258 | i0 | 99.559 | 96.054704595186 | 1362 | 6 | 99 | 0 | 1 | 1362 | 1363 | 2 | Influenza A virus (A/India/H1N1p2/2020(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 131691 | 2494 | 0.995589414595028 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 22662615 | 22662615 | PRJEB12982_P_NODE_158_length_1758_cov_30.121123_g127_i0 | PRJEB12982 | 158 | 1758 | 30.121123 | 529.52934234 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 3197 | 0 | NTclustered | gi|94960370|gb|CY010788.1| | 370129 | g127 | i0 | 99.828 | 98.773606370876 | 1741 | 2 | 99 | 1 | 1 | 1741 | 1740 | 1 | Influenza A virus (A/WSN/1933 TS61(H1N1)) segment 4, complete sequence | blastn | 173644 | 3208 | 0.996571072319202 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 22662643 | 22662643 | PRJEB12982_P_NODE_58_length_2325_cov_6.749121_g48_i0 | PRJEB12982 | 58 | 2325 | 6.749121 | 156.91706325 | root | 1 | Root_unresolved | Root_unresolved | 4266 | 0 | NTclustered | gi|2164748415|gb|OL831179.1| | 11320 | g48 | i0 | 99.828 | 99.4756989247312 | 2322 | 4 | 99 | 0 | 4 | 2325 | 1 | 2322 | Influenza A virus (A/India/H1N1-P2/2020(H1N1)) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 231281 | 4285 | 0.995565927654609 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25211772 | 25211772 | PRJEB12982_P_NODE_60_length_2316_cov_8.075871_g50_i0 | PRJEB12982 | 60 | 2316 | 8.075871 | 187.03717236 | root | 1 | Root_unresolved | Root_unresolved | 4259 | 0 | NTclustered | gi|2164728766|gb|OL831133.1| | 11320 | g50 | i0 | 99.87 | 99.4365284974093 | 2315 | 3 | 99 | 0 | 1 | 2315 | 2315 | 1 | Influenza A virus (A/India/H1N1p2/2020(H1N1)) segment 2 polymerase PB1 (PB1) and PB1-F2 protein (PB1-F2) genes, complete cds | blastn | 230295 | 4277 | 0.995791442599953 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae |
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);;