contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26010051 | 26010051 | PRJNA816047d_S_NODE_136388_length_225_cov_1085.500000_g134553_i0 | PRJNA816047 | 136388 | 225 | 1085.5 | 2442.375 | Monkeypox virus | 10244 | Viruses | Viruses | 78.7 | 3.3e-10 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g134553 | i0 | 97.778 | 190.862222222222 | 45 | 1 | 20 | 0 | 156 | 200 | 197035 | 197079 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 42944 | 78.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26010226 | 26010226 | PRJNA816047d_S_NODE_144628_length_218_cov_11464.630303_g142793_i0 | PRJNA816047 | 144628 | 218 | 11464.630303 | 24992.89406054 | Monkeypox virus | 10244 | Viruses | Viruses | 80.5 | 8.84e-11 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g142793 | i0 | 86.667 | 189.059633027523 | 75 | 6 | 33 | 3 | 23 | 94 | 197079 | 197006 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 41215 | 80.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26010620 | 26010620 | PRJNA816047d_S_NODE_167772_length_208_cov_6.935484_g165937_i0 | PRJNA816047 | 167772 | 208 | 6.935484 | 14.42580672 | Monkeypox virus | 10244 | Viruses | Viruses | 63.9 | 8.42e-6 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g165937 | i0 | 97.222 | 0.668269230769231 | 36 | 1 | 17 | 0 | 164 | 199 | 20363 | 20328 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 139 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26010734 | 26010734 | PRJNA816047d_S_NODE_176604_length_205_cov_7563.019737_g174769_i0 | PRJNA816047 | 176604 | 205 | 7563.019737 | 15504.19046085 | Monkeypox virus | 10244 | Viruses | Viruses | 78.7 | 2.95e-10 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g174769 | i0 | 97.778 | 205.746341463415 | 45 | 1 | 22 | 0 | 21 | 65 | 197080 | 197036 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 42178 | 78.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26014285 | 26014285 | PRJNA816047d_S_NODE_74620_length_267_cov_23.915888_g72785_i0 | PRJNA816047 | 74620 | 267 | 23.915888 | 63.85542096 | Monkeypox virus | 10244 | Viruses | Viruses | 58.4 | 5.25e-4 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g72785 | i0 | 94.286 | 0.370786516853933 | 35 | 2 | 13 | 0 | 205 | 239 | 20332 | 20366 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 99 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26043433 | 26043433 | PRJNA816047d_S_NODE_121740_length_240_cov_8979.112299_g119905_i0 | PRJNA816047 | 121740 | 240 | 8979.112299 | 21549.8695176 | Viruses | 10239 | Viruses | Viruses | 75 | 4.61e-9 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g119905 | i0 | 100 | 178.004166666667 | 40 | 0 | 17 | 0 | 22 | 61 | 197079 | 197040 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 42721 | 75 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26149357 | 26149357 | PRJNA816047d_S_NODE_54765_length_301_cov_318.161290_g52930_i0 | PRJNA816047 | 54765 | 301 | 318.16129 | 957.6654829 | Monkeypox virus | 10244 | Viruses | Viruses | 63.9 | 1.29e-5 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g52930 | i0 | 97.222 | 0.3421926910299 | 36 | 1 | 12 | 0 | 41 | 76 | 20328 | 20363 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 103 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26179500 | 26179500 | PRJNA816047d_S_NODE_112341_length_244_cov_1406.727749_g110506_i0 | PRJNA816047 | 112341 | 244 | 1406.727749 | 3432.41570756 | root | 1 | Root_unresolved | Root_unresolved | 76.8 | 1.31e-9 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g110506 | i0 | 100 | 173.987704918033 | 41 | 0 | 17 | 0 | 20 | 60 | 197079 | 197039 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 42453 | 76.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26285526 | 26285526 | PRJNA816047d_S_NODE_58126_length_294_cov_9621.556017_g56291_i0 | PRJNA816047 | 58126 | 294 | 9621.556017 | 28287.37468998 | Monkeypox virus | 10244 | Viruses | Viruses | 62.1 | 4.53e-5 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g56291 | i0 | 94.595 | 2.28571428571429 | 37 | 2 | 13 | 0 | 216 | 252 | 20366 | 20330 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 672 | 62.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26418668 | 26418668 | PRJNA816047d_S_NODE_17175_length_542_cov_3.341513_g15435_i0 | PRJNA816047 | 17175 | 542 | 3.341513 | 18.11100046 | Trichoplusia ni ascovirus 6b | 2077183 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|1334372357|gb|KY434117.1| | 2077183 | g15435 | i0 | 100 | 0.0553505535055351 | 30 | 0 | 6 | 0 | 460 | 489 | 12221 | 12250 | Trichoplusia ni ascovirus 6b isolate TnAV-6b | blastn | 30 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Ascovirus | Trichoplusia ni ascovirus 6b | ||
| 26545309 | 26545309 | PRJNA816047a_S_NODE_35672_length_347_cov_17.375912_g33012_i0 | PRJNA816047 | 35672 | 347 | 17.375912 | 60.29441464 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g33012 | i0 | 94.286 | 0.100864553314121 | 35 | 1 | 10 | 1 | 209 | 242 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei |
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);;