metadata: contig_metadata: 9 rows where bioproject = "PRJNA438111", tax_phylum = "Nucleocytoviricota" and tax

9 rows where bioproject = "PRJNA438111", tax_phylum = "Nucleocytoviricota" and tax_superkingdom = "Viruses"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18941866	18941866	PRJNA438111_P_NODE_13455_length_284_cov_2.188235_g12830_i0	PRJNA438111	13455	284	2.188235	6.2145874	Megavirus	3044761	Viruses	Viruses	52.8	0.026	NTclustered	gi\|574609279\|gb\|KF527229.1\|	1128143	g12830	i0	100	0.197183098591549	28	0	10	0	50	77	788224	788251	Megavirus terra1 genome	blastn	56	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
28497218	28497218	PRJNA438111_P_NODE_5147_length_435_cov_2.706897_g4578_i0	PRJNA438111	5147	435	2.706897	11.77500195	Klosneuvirus KNV1	1977640	Viruses	Viruses	187	3.01e-54	NR	ARF12356.1	1977640	g4578	i0	60.1	7.00689655172414	138	45	95.2	1	1	414	128	255	ARF12356.1 fructose-1,6-bisphosphatase [Klosneuvirus KNV1]	diamond	3048	187	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
29349662	29349662	PRJNA438111_P_NODE_20729_length_236_cov_3.285024_g20104_i0	PRJNA438111	20729	236	3.285024	7.75265664	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	73.6	3.24e-13	NR	VBB18342.1	2420051	g20104	i0	46.6	3.71186440677966	73	38	92.8	1	13	231	171	242	VBB18342.1 hypothetical protein YASMINEVIRUS_805 [Yasminevirus sp. GU-2018]	diamond	876	73.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
29918147	29918147	PRJNA438111_P_NODE_70871_length_164_cov_1.577778_g70246_i0	PRJNA438111	70871	164	1.577778	2.58755592	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	95.9	2.3700000000000003e-21	NR	YP_009448418.1	2023057	g70246	i0	74.1	0.98780487804878	54	14	98.8	0	2	163	129	182	YP_009448418.1 Arginyl-tRNA synthetase [Orpheovirus IHUMI-LCC2]	diamond	162	95.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
30644525	30644525	PRJNA438111_P_NODE_4993_length_441_cov_5.849515_g4430_i0	PRJNA438111	4993	441	5.849515	25.79636115	Klosneuvirus KNV1	1977640	Viruses	Viruses	79	6.68e-14	NR	ARF12220.1	1977640	g4430	i0	30.7	0.952380952380952	140	93	94.6	3	424	8	255	391	ARF12220.1 hypothetical protein Klosneuvirus_4_35 [Klosneuvirus KNV1]	diamond	420	79	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
30676078	30676078	PRJNA438111_P_NODE_46853_length_185_cov_3.525641_g46228_i0	PRJNA438111	46853	185	3.525641	6.52243585	Nucleocytoviricota sp.	2809609	Viruses	Viruses	41.2	0.0309	NR	UZT28927.1	2809609	g46228	i0	41.2	0.827027027027027	51	29	81.1	1	11	160	76	126	UZT28927.1 hypothetical protein [Nucleocytoviricota sp.]	diamond	153	41.2	1	Viruses	Bamfordvirae	Nucleocytoviricota					Nucleocytoviricota sp.
31957142	31957142	PRJNA438111_P_NODE_13197_length_286_cov_3.085603_g12572_i0	PRJNA438111	13197	286	3.085603	8.82482458	Klosneuvirus	1977639	Viruses	Viruses	105	1.75e-25	NR	ARF12304.1	1977640	g12572	i0	57.4	1.97202797202797	94	40	98.6	0	3	284	114	207	ARF12304.1 metal dependent phosphohydrolase [Klosneuvirus KNV1]	diamond	564	105	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32067311	32067311	PRJNA438111_P_NODE_11378_length_305_cov_2.641304_g10753_i0	PRJNA438111	11378	305	2.641304	8.0559772	Mimivirus LCMiAC	2506609	Viruses	Viruses	63.2	4e-9	NR	QBK89199.1	2506609	g10753	i0	35	0.983606557377049	100	62	96.4	2	4	297	155	253	QBK89199.1 MAG: endonuclease/exonuclease/phosphatase family protein [Mimivirus LCMiAC02]	diamond	300	63.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
32573938	32573938	PRJNA438111_P_NODE_3419_length_529_cov_7.076000_g2913_i0	PRJNA438111	3419	529	7.076	37.43204	Klosneuvirus KNV1	1977640	Viruses	Viruses	100	4.19e-21	NR	ARF12097.1	1977640	g2913	i0	35.7	0.969754253308129	171	96	90.2	4	3	479	596	764	ARF12097.1 hypothetical protein Klosneuvirus_3_232 [Klosneuvirus KNV1]	diamond	513	100	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1

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);;