contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax_clade = "Pithoviruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25947075 | 25947075 | PRJNA1233465b_S_NODE_291932_length_177_cov_1.593750_g290247_i0 | PRJNA1233465 | 291932 | 177 | 1.59375 | 2.8209375 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 165 | 1.84e-36 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g290247 | i0 | 87.261 | 0.88700564971751406 | 157 | 5 | 89 | 5 | 14 | 170 | 86675 | 86534 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 157 | 165 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 25948873 | 25948873 | PRJNA1233465b_S_NODE_82876_length_295_cov_1.028455_g81191_i0 | PRJNA1233465 | 82876 | 295 | 1.028455 | 3.03394225 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 416 | 8.429999999999998e-112 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g81191 | i0 | 92.44 | 0.986440677966102 | 291 | 22 | 99 | 0 | 3 | 293 | 69360 | 69650 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 291 | 416 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 26081637 | 26081637 | PRJNA1233465b_S_NODE_185133_length_216_cov_1.832335_g183448_i0 | PRJNA1233465 | 185133 | 216 | 1.832335 | 3.9578436 | Brazilian cedratvirus IHUMI | 2126980 | Viruses | Viruses | 137 | 5.119999999999999e-28 | NTclustered | gi|1379008795|emb|LT994651.1| | 2126980 | g183448 | i0 | 91.089 | 2.7037037037037 | 101 | 9 | 47 | 0 | 115 | 215 | 137743 | 137843 | Brazilian cedratvirus IHUMI strain IHUMI-27.7 genome assembly, chromosome: scaffold_1 | blastn | 584 | 137 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus brasiliense | ||||||
| 26352928 | 26352928 | PRJNA1233465b_S_NODE_127895_length_251_cov_1.514851_g126210_i0 | PRJNA1233465 | 127895 | 251 | 1.514851 | 3.80227601 | Cedratvirus A11 | 1903266 | Viruses | Viruses | 268 | 2.07e-67 | NTclustered | gi|1115260653|ref|NC_032108.1| | 1903266 | g126210 | i0 | 88.053 | 4.37848605577689 | 226 | 27 | 90 | 0 | 1 | 226 | 148478 | 148703 | Cedratvirus A11 genome assembly, complete genome: monopartite | blastn | 1099 | 268 | 1 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus aljazairmassiliense | ||||||
| 26493381 | 26493381 | PRJNA1233465b_S_NODE_91616_length_284_cov_2.378723_g89931_i0 | PRJNA1233465 | 91616 | 284 | 2.378723 | 6.75557332 | Cedratvirus borely | 3032482 | Viruses | Viruses | 388 | 1.7599999999999998e-103 | NTclustered | gi|2514762215|gb|OQ413575.1| | 3032482 | g89931 | i0 | 96.596 | 4.17957746478873 | 235 | 7 | 83 | 1 | 1 | 235 | 73057 | 72824 | Cedratvirus borely strain AA, complete genome | blastn | 1187 | 388 | 1 | Viruses | Pithoviruses | Cedratvirus borely |
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);;