contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1164198" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19437979 | 19437979 | PRJNA1164198_P_NODE_3096_length_714_cov_2.068643_g2872_i0 | PRJNA1164198 | 3096 | 714 | 2.068643 | 14.77011102 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 298 | 1.44e-98 | NR | YP_010803019.1 | 3060017 | g2872 | i0 | 57 | 1.98739495798319 | 237 | 102 | 99.6 | 0 | 2 | 712 | 17 | 253 | YP_010803019.1 peptidase C1a [Fadolivirus algeromassiliense] | diamond | 1419 | 298 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 26850764 | 26850764 | PRJNA1164198_P_NODE_28821_length_245_cov_0.906977_g28552_i0 | PRJNA1164198 | 28821 | 245 | 0.906977 | 2.22209365 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 50.1 | 4.98e-5 | NR | YP_010782233.1 | 2126985 | g28552 | i0 | 39.2 | 1.93469387755102 | 79 | 48 | 96.7 | 0 | 237 | 1 | 52 | 130 | YP_010782233.1 hypothetical protein QJ857_gp0474 [Tupanvirus soda lake] | diamond | 474 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27261810 | 27261810 | PRJNA1164198_P_NODE_6803_length_482_cov_1.760391_g6543_i0 | PRJNA1164198 | 6803 | 482 | 1.760391 | 8.48508462 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 198 | 2.08e-57 | NR | YP_010782121.1 | 2126985 | g6543 | i0 | 61.8 | 0.977178423236514 | 157 | 60 | 97.7 | 0 | 481 | 11 | 246 | 402 | YP_010782121.1 arylsulfatase [Tupanvirus soda lake] | diamond | 471 | 198 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27388308 | 27388308 | PRJNA1164198_P_NODE_31423_length_234_cov_2.670807_g31154_i0 | PRJNA1164198 | 31423 | 234 | 2.670807 | 6.24968838 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 111 | 2.69e-26 | NR | UGV21557.1 | 2903093 | g31154 | i0 | 68 | 0.961538461538462 | 75 | 24 | 96.2 | 0 | 231 | 7 | 965 | 1039 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 225 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 27609259 | 27609259 | PRJNA1164198_P_NODE_22244_length_263_cov_1.884211_g21975_i0 | PRJNA1164198 | 22244 | 263 | 1.884211 | 4.95547493 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 135 | 1.68e-34 | NR | UGV21557.1 | 2903093 | g21975 | i0 | 74.7 | 0.992395437262357 | 87 | 22 | 99.2 | 0 | 2 | 262 | 1144 | 1230 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 261 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 27988080 | 27988080 | PRJNA1164198_P_NODE_17665_length_294_cov_1.407240_g17396_i0 | PRJNA1164198 | 17665 | 294 | 1.40724 | 4.1372856 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 77.4 | 1e-15 | NR | ARF09177.1 | 1977631 | g17396 | i0 | 42.7 | 0.979591836734694 | 96 | 52 | 98 | 1 | 6 | 293 | 6 | 98 | ARF09177.1 hypothetical protein Catovirus_2_126 [Catovirus CTV1] | diamond | 288 | 77.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 28146115 | 28146115 | PRJNA1164198_P_NODE_28545_length_246_cov_0.901734_g28276_i0 | PRJNA1164198 | 28545 | 246 | 0.901734 | 2.21826564 | Dickeya phage vB_DsoM_JA11 | 2382310 | Viruses | Viruses | 82 | 1.63e-17 | NR | YP_009813682.1 | 2382310 | g28276 | i0 | 56.4 | 0.951219512195122 | 78 | 34 | 95.1 | 0 | 245 | 12 | 31 | 108 | YP_009813682.1 hypothetical protein HOU32_gp237 [Dickeya phage vB_DsoM_JA11] | diamond | 234 | 82 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salmondvirus | Salmondvirus JA11 | ||||
| 28808640 | 28808640 | PRJNA1164198_P_NODE_28708_length_245_cov_1.523256_g28439_i0 | PRJNA1164198 | 28708 | 245 | 1.523256 | 3.7319772 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 116 | 5.36e-28 | NR | UGV21557.1 | 2903093 | g28439 | i0 | 69.5 | 1.00408163265306 | 82 | 24 | 99.2 | 1 | 3 | 245 | 697 | 778 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 246 | 116 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 28872004 | 28872004 | PRJNA1164198_P_NODE_10908_length_376_cov_2.435644_g10640_i0 | PRJNA1164198 | 10908 | 376 | 2.435644 | 9.15802144 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 218 | 4.45e-63 | NR | UGV21557.1 | 2903093 | g10640 | i0 | 87.9 | 0.98936170212766 | 124 | 15 | 98.9 | 0 | 374 | 3 | 170 | 293 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 372 | 218 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 29819117 | 29819117 | PRJNA1164198_P_NODE_12531_length_350_cov_1.891697_g12262_i0 | PRJNA1164198 | 12531 | 350 | 1.891697 | 6.6209395 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 164 | 3.16e-44 | NR | UGV21557.1 | 2903093 | g12262 | i0 | 66.1 | 0.985714285714286 | 115 | 39 | 98.6 | 0 | 5 | 349 | 1228 | 1342 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 345 | 164 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 30609055 | 30609055 | PRJNA1164198_P_NODE_4633_length_584_cov_1.921722_g4385_i0 | PRJNA1164198 | 4633 | 584 | 1.921722 | 11.22285648 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 226 | 1.1e-64 | NR | UGV21557.1 | 2903093 | g4385 | i0 | 57.9 | 0.976027397260274 | 190 | 80 | 97.6 | 0 | 581 | 12 | 1772 | 1961 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 570 | 226 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 30925352 | 30925352 | PRJNA1164198_P_NODE_21934_length_265_cov_2.135417_g21665_i0 | PRJNA1164198 | 21934 | 265 | 2.135417 | 5.65885505 | Crogonang virus 178 | 3063382 | Viruses | Viruses | 86.3 | 5.01e-18 | NR | WPR18581.1 | 3063382 | g21665 | i0 | 53.6 | 0.950943396226415 | 84 | 36 | 95.1 | 1 | 264 | 13 | 23 | 103 | WPR18581.1 MAG: RNA-dependent RNA polymerase, partial [Crogonang virus 178] | diamond | 252 | 86.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Crogonang virus 178 | ||||
| 31145840 | 31145840 | PRJNA1164198_P_NODE_21375_length_269_cov_0.979592_g21106_i0 | PRJNA1164198 | 21375 | 269 | 0.979592 | 2.63510248 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 171 | 2.8e-47 | NR | UGV21557.1 | 2903093 | g21106 | i0 | 93.3 | 0.992565055762082 | 89 | 6 | 99.3 | 0 | 268 | 2 | 284 | 372 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 267 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae | |||
| 32443542 | 32443542 | PRJNA1164198_P_NODE_27779_length_247_cov_0.896552_g27510_i0 | PRJNA1164198 | 27779 | 247 | 0.896552 | 2.21448344 | Acanthamoeba polyphaga mimivirus | 212035 | Viruses | Viruses | 88.2 | 4.51e-19 | NR | AVG46078.1 | 212035 | g27510 | i0 | 63 | 2.95141700404858 | 81 | 28 | 98.4 | 2 | 3 | 245 | 98 | 176 | AVG46078.1 hypothetical protein [Acanthamoeba polyphaga mimivirus] | diamond | 729 | 88.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 32664082 | 32664082 | PRJNA1164198_P_NODE_29880_length_243_cov_1.835294_g29611_i0 | PRJNA1164198 | 29880 | 243 | 1.835294 | 4.45976442 | Saccharomyces 2 | 3431059 | Viruses | Viruses | 120 | 1.64e-29 | NR | NP_660178.1 | 186772 | g29611 | i0 | 76.3 | 0.987654320987654 | 80 | 19 | 98.8 | 0 | 3 | 242 | 21 | 100 | NP_660178.1 RNA-dependent RNA polymerase [Saccharomyces 20S RNA narnavirus] | diamond | 240 | 120 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus saccharominor | ||
| 32758732 | 32758732 | PRJNA1164198_P_NODE_5700_length_527_cov_2.603524_g5445_i0 | PRJNA1164198 | 5700 | 527 | 2.603524 | 13.72057148 | Giant panda Iflaviridae | 2903093 | Viruses | Viruses | 226 | 9.71e-65 | NR | UGV21557.1 | 2903093 | g5445 | i0 | 62.6 | 0.973434535104364 | 171 | 63 | 97.3 | 1 | 513 | 1 | 2060 | 2229 | UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae] | diamond | 513 | 226 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Giant panda Iflaviridae |
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);;