contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB7614" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2271537 | 2271537 | PRJEB7614_P_NODE_4482_length_197_cov_21905.523810_g4415_i0 | PRJEB7614 | 4482 | 197 | 21905.52381 | 43153.8819057 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g4415 | i0 | 100 | 16.4213197969543 | 30 | 0 | 16 | 0 | 3 | 32 | 34 | 63 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3235 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 9065976 | 9065976 | PRJEB7614_P_NODE_1128_length_313_cov_7506.714789_g1063_i0 | PRJEB7614 | 1128 | 313 | 7506.714789 | 23496.01728957 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 60.2 | 1.75e-4 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1063 | i0 | 100 | 10.4025559105431 | 32 | 0 | 10 | 0 | 280 | 311 | 65 | 34 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3256 | 60.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 10341729 | 10341729 | PRJEB7614_P_NODE_2029_length_260_cov_3886.969697_g1962_i0 | PRJEB7614 | 2029 | 260 | 3886.969697 | 10106.1212122 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 62.1 | 3.94e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g1962 | i0 | 97.222 | 14.9192307692308 | 36 | 1 | 14 | 0 | 2 | 37 | 22851 | 22816 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3879 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 17574326 | 17574326 | PRJEB7614_P_NODE_2854_length_230_cov_123424.616915_g2787_i0 | PRJEB7614 | 2854 | 230 | 123424.616915 | 283876.6189045 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g2787 | i0 | 100 | 14.1347826086957 | 30 | 0 | 14 | 0 | 163 | 192 | 63 | 34 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3251 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 17990215 | 17990215 | PRJEB7614_P_NODE_3035_length_225_cov_4773.423469_g2968_i0 | PRJEB7614 | 3035 | 225 | 4773.423469 | 10740.20280525 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 62.1 | 3.32e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g2968 | i0 | 97.222 | 17.24 | 36 | 1 | 16 | 0 | 189 | 224 | 22816 | 22851 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3879 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 18848120 | 18848120 | PRJEB7614_P_NODE_455_length_392_cov_319158.991736_g398_i0 | PRJEB7614 | 455 | 392 | 319158.991736 | 1251103.24760512 | Viruses | 10239 | Viruses | Viruses | 71.3 | 1.03e-7 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g398 | i0 | 97.561 | 18.6811224489796 | 41 | 1 | 18 | 0 | 324 | 364 | 104 | 64 | Chrysochromulina parva virophage Curly, complete genome | blastn | 7323 | 71.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Curly | |||
| 22673338 | 22673338 | PRJEB7614_P_NODE_4638_length_195_cov_19381.795181_g4571_i0 | PRJEB7614 | 4638 | 195 | 19381.795181 | 37794.50060295 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g4571 | i0 | 100 | 16.6 | 30 | 0 | 16 | 0 | 164 | 193 | 63 | 34 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3237 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 23090643 | 23090643 | PRJEB7614_P_NODE_2459_length_244_cov_4241.567442_g2392_i0 | PRJEB7614 | 2459 | 244 | 4241.567442 | 10349.42455848 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 62.1 | 3.66e-5 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g2392 | i0 | 97.222 | 15.8975409836066 | 36 | 1 | 15 | 0 | 208 | 243 | 22816 | 22851 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3879 | 62.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 23948868 | 23948868 | PRJEB7614_P_NODE_4919_length_191_cov_14860.197531_g4852_i0 | PRJEB7614 | 4919 | 191 | 14860.197531 | 28382.97728421 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g4852 | i0 | 100 | 17.0418848167539 | 30 | 0 | 16 | 0 | 3 | 32 | 34 | 63 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3255 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25222548 | 25222548 | PRJEB7614_P_NODE_940_length_329_cov_139554.996667_g875_i0 | PRJEB7614 | 940 | 329 | 139554.996667 | 459135.93903443 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g875 | i0 | 100 | 10.2765957446809 | 30 | 0 | 10 | 0 | 155 | 184 | 63 | 34 | Chrysochromulina parva virophage Larry, complete genome | blastn | 3381 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25525700 | 25525700 | PRJEB7614e_S_NODE_57_length_537_cov_55.446215_g52_i0 | PRJEB7614 | 57 | 537 | 55.446215 | 297.74617455 | Chrysochromulina parva virophage Larry | 2420056 | Viruses | Viruses | 54.7 | 0.015 | NTclustered | gi|1509794397|gb|MH920636.1| | 2420056 | g52 | i0 | 100 | 0.0540037243947858 | 29 | 0 | 5 | 0 | 509 | 537 | 22814 | 22842 | Chrysochromulina parva virophage Larry, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Chrysochromulina parva virophage Larry | |||
| 25933937 | 25933937 | PRJEB7614a_S_NODE_81364_length_210_cov_8.497143_g80160_i0 | PRJEB7614 | 81364 | 210 | 8.497143 | 17.8440003 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g80160 | i0 | 94.286 | 0.166666666666667 | 35 | 1 | 16 | 1 | 79 | 112 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26160844 | 26160844 | PRJEB7614b_S_NODE_1285_length_201_cov_517.614458_g1283_i0 | PRJEB7614 | 1285 | 201 | 517.614458 | 1040.40506058 | Viruses | 10239 | Viruses | Viruses | 60.2 | 1.04e-4 | NTclustered | gi|1509794377|gb|MH919296.1| | 2420054 | g1283 | i0 | 97.143 | 16.8606965174129 | 35 | 1 | 17 | 0 | 21 | 55 | 70 | 104 | Chrysochromulina parva virophage Curly, complete genome | blastn | 3389 | 60.2 | 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);;