contig_metadata
9 rows where bioproject = "PRJNA558770" and tax_phylum = "Nucleocytoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6917860 | 6917860 | PRJNA558770_P_NODE_237186_length_234_cov_2.613065_g235181_i0 | PRJNA558770 | 237186 | 234 | 2.613065 | 6.1145721 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 130 | 9.41e-26 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g235181 | i0 | 100 | 0.786324786324786 | 70 | 0 | 62 | 0 | 6 | 75 | 462896 | 462827 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 184 | 130 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 18980500 | 18980500 | PRJNA558770_P_NODE_214755_length_234_cov_3.256281_g212750_i0 | PRJNA558770 | 214755 | 234 | 3.256281 | 7.61969754 | Mimiviridae | 549779 | Viruses | Viruses | 62.1 | 3.48e-5 | NTclustered | gi|2500366567|ref|NC_075368.1| | 2109587 | g212750 | i0 | 100 | 1.31623931623932 | 33 | 0 | 14 | 0 | 37 | 69 | 1053081 | 1053113 | Moumouvirus australiensis isolate 10A, complete genome | blastn | 308 | 62.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus australiense | ||
| 24765492 | 24765492 | PRJNA558770_P_NODE_203300_length_234_cov_3.658291_g201295_i0 | PRJNA558770 | 203300 | 234 | 3.658291 | 8.56040094 | Theiavirus salishense | 3060737 | Viruses | Viruses | 60.2 | 1.25e-4 | NTclustered | gi|2500354595|ref|NC_075036.1| | 2024608 | g201295 | i0 | 81.081 | 0.435897435897436 | 74 | 14 | 44 | 0 | 160 | 233 | 16806 | 16879 | Bodo saltans virus strain NG1, complete genome | blastn | 102 | 60.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 26776659 | 26776659 | PRJNA558770_P_NODE_216501_length_234_cov_3.201005_g214496_i0 | PRJNA558770 | 216501 | 234 | 3.201005 | 7.4903517 | Mimiviridae | 549779 | Viruses | Viruses | 53.9 | 3.46e-6 | NR | ARF09327.1 | 1977631 | g214496 | i0 | 96 | 3.17948717948718 | 25 | 1 | 32.1 | 0 | 75 | 1 | 147 | 171 | ARF09327.1 packaging ATPase [Catovirus CTV1] | diamond | 744 | 53.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 27647767 | 27647767 | PRJNA558770_P_NODE_57324_length_276_cov_11.946058_g55320_i0 | PRJNA558770 | 57324 | 276 | 11.946058 | 32.97112008 | Monkeypox virus | 10244 | Viruses | Viruses | 152 | 1.09e-40 | NR | XEX02893.1 | 10244 | g55320 | i0 | 58.8 | 63.195652173913 | 153 | 0 | 97.8 | 1 | 5 | 274 | 104 | 256 | XEX02893.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 17442 | 152 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 27711150 | 27711150 | PRJNA558770_P_NODE_167324_length_234_cov_5.316583_g165319_i0 | PRJNA558770 | 167324 | 234 | 5.316583 | 12.44080422 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 46.6 | 0.00143 | NR | ARF08085.1 | 1977631 | g165319 | i0 | 80 | 0.628205128205128 | 25 | 5 | 32.1 | 0 | 159 | 233 | 220 | 244 | ARF08085.1 mRNA capping enzyme [Catovirus CTV1] | diamond | 147 | 46.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 28910213 | 28910213 | PRJNA558770_P_NODE_215848_length_234_cov_3.221106_g213843_i0 | PRJNA558770 | 215848 | 234 | 3.221106 | 7.53738804 | Bodo saltans virus | 2024608 | Viruses | Viruses | 43.9 | 0.013 | NR | YP_010778203.1 | 2024608 | g213843 | i0 | 39.2 | 2.84615384615385 | 74 | 41 | 94.9 | 1 | 3 | 224 | 660 | 729 | YP_010778203.1 D5 family helicase-primase [Bodo saltans virus] | diamond | 666 | 43.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 29921170 | 29921170 | PRJNA558770_P_NODE_74051_length_241_cov_7.621359_g72046_i0 | PRJNA558770 | 74051 | 241 | 7.621359 | 18.36747519 | Camelpox virus | 28873 | Viruses | Viruses | 69.3 | 1.59e-11 | NR | NP_570494.1 | 28873 | g72046 | i0 | 36.6 | 1.63070539419087 | 131 | 32 | 99.6 | 1 | 240 | 1 | 523 | 653 | NP_570494.1 CMLV104 [Camelpox virus] | diamond | 393 | 69.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus camelpox | ||
| 32670966 | 32670966 | PRJNA558770_P_NODE_227780_length_234_cov_2.869347_g225775_i0 | PRJNA558770 | 227780 | 234 | 2.869347 | 6.71427198 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 50.4 | 5.82e-5 | NR | ARF08692.1 | 1977631 | g225775 | i0 | 84 | 0.320512820512821 | 25 | 4 | 32.1 | 0 | 75 | 1 | 109 | 133 | ARF08692.1 hypothetical protein Catovirus_1_742 [Catovirus CTV1] | diamond | 75 | 50.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 |
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);;