contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB6055" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125526 | 125526 | PRJEB6055_S_NODE_1701_length_229_cov_17422.345361_g1677_i0 | PRJEB6055 | 1701 | 229 | 17422.345361 | 39897.17087669 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 78.7 | 3.37e-10 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1677 | i0 | 94.231 | 19.2794759825328 | 52 | 1 | 22 | 2 | 2 | 52 | 25 | 75 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4415 | 78.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 2267490 | 2267490 | PRJEB6055_S_NODE_1162_length_260_cov_14565.560000_g1138_i0 | PRJEB6055 | 1162 | 260 | 14565.56 | 37870.456 | Viruses | 10239 | Viruses | Viruses | 78.7 | 3.91e-10 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1138 | i0 | 92.727 | 17.0730769230769 | 55 | 2 | 21 | 2 | 2 | 56 | 22855 | 22803 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4439 | 78.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 2675614 | 2675614 | PRJEB6055_S_NODE_2303_length_208_cov_19537.641618_g2279_i0 | PRJEB6055 | 2303 | 208 | 19537.641618 | 40638.29456544 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 78.7 | 3.01e-10 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g2279 | i0 | 100 | 21.1971153846154 | 42 | 0 | 20 | 0 | 166 | 207 | 102 | 61 | Chrysochromulina parva virophage Curly, complete genome | blastn | 4409 | 78.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 10328581 | 10328581 | PRJEB6055_S_NODE_2969_length_191_cov_23456.500000_g2945_i0 | PRJEB6055 | 2969 | 191 | 23456.5 | 44801.915 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 78.7 | 2.71e-10 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g2945 | i0 | 100 | 23.1623036649215 | 42 | 0 | 22 | 0 | 149 | 190 | 66 | 25 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4424 | 78.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 12879174 | 12879174 | PRJEB6055_S_NODE_1891_length_222_cov_19635.625668_g1867_i0 | PRJEB6055 | 1891 | 222 | 19635.625668 | 43591.08898296 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 76.8 | 1.17e-9 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1867 | i0 | 100 | 19.8423423423423 | 41 | 0 | 18 | 0 | 2 | 42 | 25 | 65 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4405 | 76.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 13745710 | 13745710 | PRJEB6055_S_NODE_11_length_990_cov_4206.610471_g3_i2 | PRJEB6055 | 11 | 990 | 4206.610471 | 41645.4436629 | Viruses | 10239 | Viruses | Viruses | 75 | 2.14e-8 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g3 | i2 | 100 | 4.44343434343434 | 40 | 0 | 4 | 0 | 2 | 41 | 25 | 64 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4399 | 75 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 15020102 | 15020102 | PRJEB6055_S_NODE_1892_length_222_cov_19580.352941_g1868_i0 | PRJEB6055 | 1892 | 222 | 19580.352941 | 43468.38352902 | Viruses | 10239 | Viruses | Viruses | 75 | 4.2e-9 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1868 | i0 | 100 | 19.8153153153153 | 40 | 0 | 18 | 0 | 2 | 41 | 25 | 64 | Chrysochromulina parva virophage Larry, complete genome | blastn | 4399 | 75 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 21394346 | 21394346 | PRJEB6055_S_NODE_3037_length_190_cov_21221.025806_g3013_i0 | PRJEB6055 | 3037 | 190 | 21221.025806 | 40319.9490314 | Viruses | 10239 | Viruses | Viruses | 75 | 3.48e-9 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g3013 | i0 | 95.652 | 23.4 | 46 | 2 | 24 | 0 | 144 | 189 | 106 | 61 | Chrysochromulina parva virophage Curly, complete genome | blastn | 4446 | 75 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 24351366 | 24351366 | PRJEB6055_S_NODE_1120_length_264_cov_14774.580786_g1096_i0 | PRJEB6055 | 1120 | 264 | 14774.580786 | 39004.89327504 | Chrysochromulina parva virophage Curly | 2420054 | Viruses | Viruses | 80.5 | 1.11e-10 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g1096 | i0 | 100 | 16.8560606060606 | 43 | 0 | 16 | 0 | 221 | 263 | 103 | 61 | Chrysochromulina parva virophage Curly, complete genome | blastn | 4450 | 80.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly |
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);;