contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA715461" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981147 | 1981147 | PRJNA715461_S_NODE_782_length_286_cov_22141.882629_g708_i0 | PRJNA715461 | 782 | 286 | 22141.882629 | 63325.78431894 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.52e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g708 | i0 | 98.571 | 28.7972027972028 | 70 | 1 | 24 | 0 | 217 | 286 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8236 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 3256506 | 3256506 | PRJNA715461_S_NODE_743_length_297_cov_22036.727679_g669_i0 | PRJNA715461 | 743 | 297 | 22036.727679 | 65449.08120663 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.76e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g669 | i0 | 98.571 | 27.7845117845118 | 70 | 1 | 24 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8252 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5808768 | 5808768 | PRJNA715461_S_NODE_1045_length_245_cov_3.715116_g971_i0 | PRJNA715461 | 1045 | 245 | 3.715116 | 9.1020342 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 75 | 4.72e-9 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g971 | i0 | 97.674 | 16.8857142857143 | 43 | 1 | 18 | 0 | 1 | 43 | 77 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4137 | 75 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5808782 | 5808782 | PRJNA715461_S_NODE_525_length_373_cov_16431.050000_g451_i0 | PRJNA715461 | 525 | 373 | 16431.05 | 61287.8165 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 7.41e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g451 | i0 | 98.571 | 22.0804289544236 | 70 | 1 | 19 | 0 | 304 | 373 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8236 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8358457 | 8358457 | PRJNA715461_S_NODE_167_length_636_cov_8630.875666_g118_i0 | PRJNA715461 | 167 | 636 | 8630.875666 | 54892.36923576 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 1.32e-23 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g118 | i0 | 98.571 | 14.1839622641509 | 70 | 1 | 11 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 9021 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8358460 | 8358460 | PRJNA715461_S_NODE_347_length_461_cov_12436.592784_g277_i0 | PRJNA715461 | 347 | 461 | 12436.592784 | 57332.69273424 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 9.35e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g277 | i0 | 98.571 | 18.3882863340564 | 70 | 1 | 15 | 0 | 392 | 461 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8477 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9633672 | 9633672 | PRJNA715461_S_NODE_368_length_449_cov_12712.401596_g295_i0 | PRJNA715461 | 368 | 449 | 12712.401596 | 57078.68316604 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 9.09e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g295 | i0 | 98.571 | 18.3429844097996 | 70 | 1 | 16 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8236 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10909217 | 10909217 | PRJNA715461_S_NODE_329_length_480_cov_11914.341523_g262_i0 | PRJNA715461 | 329 | 480 | 11914.341523 | 57188.8393104 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 9.769999999999999e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g262 | i0 | 98.571 | 18.6354166666667 | 70 | 1 | 15 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8945 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10909218 | 10909218 | PRJNA715461_S_NODE_349_length_460_cov_12481.067183_g279_i0 | PRJNA715461 | 349 | 460 | 12481.067183 | 57412.9090418 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 9.329999999999999e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g279 | i0 | 98.571 | 18.4282608695652 | 70 | 1 | 15 | 0 | 391 | 460 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8477 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10909220 | 10909220 | PRJNA715461_S_NODE_409_length_426_cov_13523.603399_g335_i0 | PRJNA715461 | 409 | 426 | 13523.603399 | 57610.55047974 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 8.58e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g335 | i0 | 98.571 | 19.8990610328638 | 70 | 1 | 16 | 0 | 357 | 426 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8477 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12184456 | 12184456 | PRJNA715461_S_NODE_330_length_479_cov_11772.460591_g263_i0 | PRJNA715461 | 330 | 479 | 11772.460591 | 56390.08623089 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 9.75e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g263 | i0 | 98.571 | 18.5720250521921 | 70 | 1 | 15 | 0 | 410 | 479 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8896 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14734111 | 14734111 | PRJNA715461_S_NODE_412_length_425_cov_13451.394886_g338_i0 | PRJNA715461 | 412 | 425 | 13451.394886 | 57168.4282655 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 8.56e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g338 | i0 | 98.571 | 19.9458823529412 | 70 | 1 | 16 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8477 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14734118 | 14734118 | PRJNA715461_S_NODE_812_length_280_cov_23023.502415_g738_i0 | PRJNA715461 | 812 | 280 | 23023.502415 | 64465.806762 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.39e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g738 | i0 | 98.571 | 29.4142857142857 | 70 | 1 | 25 | 0 | 211 | 280 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8236 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21107567 | 21107567 | PRJNA715461_S_NODE_1317_length_221_cov_31699.891892_g1243_i0 | PRJNA715461 | 1317 | 221 | 31699.891892 | 70056.76108132 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 4.09e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g1243 | i0 | 98.571 | 36.2533936651584 | 70 | 1 | 32 | 0 | 152 | 221 | 119 | 50 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8012 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22382706 | 22382706 | PRJNA715461_S_NODE_858_length_271_cov_24040.954545_g784_i0 | PRJNA715461 | 858 | 271 | 24040.954545 | 65150.98681695 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.1899999999999996e-24 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g784 | i0 | 98.571 | 30.3911439114391 | 70 | 1 | 26 | 0 | 1 | 70 | 50 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8236 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23658181 | 23658181 | PRJNA715461_S_NODE_1019_length_247_cov_1.465517_g945_i0 | PRJNA715461 | 1019 | 247 | 1.465517 | 3.61982699 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 3.68e-10 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g945 | i0 | 97.778 | 16.7570850202429 | 45 | 1 | 18 | 0 | 203 | 247 | 119 | 75 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4139 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum |
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);;