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

9 rows where bioproject = "PRJEB11748", 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
8943362	8943362	PRJEB11748_P_NODE_227888_length_261_cov_26.445000_g225705_i0	PRJEB11748	227888	261	26.445	69.02145	Megavirus chilense	3060301	Viruses	Viruses	86.1	2.35e-12	NTclustered	gi\|574609279\|gb\|KF527229.1\|	1128143	g225705	i0	90.625	10.0191570881226	64	6	25	0	126	189	1829	1766	Megavirus terra1 genome	blastn	2615	86.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
27349212	27349212	PRJEB11748_P_NODE_295823_length_221_cov_8.237500_g293640_i0	PRJEB11748	295823	221	8.2375	18.204875	Indivirus ILV1	1977633	Viruses	Viruses	42.7	0.0287	NR	ARF09927.1	1977633	g293640	i0	53.5	0.583710407239819	43	20	58.4	0	23	151	623	665	ARF09927.1 superfamily II helicase [Indivirus ILV1]	diamond	129	42.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
27633254	27633254	PRJEB11748_P_NODE_268344_length_236_cov_2.240000_g266161_i0	PRJEB11748	268344	236	2.24	5.2864	Chlorovirus sp.	2809302	Viruses	Viruses	83.6	7.53e-19	NR	WZO93680.1	2809302	g266161	i0	83.3	0.610169491525424	48	8	61	0	1	144	40	87	WZO93680.1 ubiquitin [Chlorovirus sp.]	diamond	144	83.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
27885618	27885618	PRJEB11748_P_NODE_114565_length_388_cov_6.449541_g112391_i0	PRJEB11748	114565	388	6.449541	25.02421908	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	68.6	1.73e-10	NR	YP_010802889.1	3060017	g112391	i0	54.5	0.425257731958763	55	24	41.8	1	341	180	751	805	YP_010802889.1 inter-alpha-trypsin inhibitor family protein [Fadolivirus algeromassiliense]	diamond	165	68.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
28043597	28043597	PRJEB11748_P_NODE_241205_length_252_cov_8.984293_g239022_i0	PRJEB11748	241205	252	8.984293	22.64041836	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	63.5	1.31e-9	NR	YP_010803946.1	3060017	g239022	i0	46.4	0.821428571428571	69	36	82.1	1	209	3	84	151	YP_010803946.1 hypothetical protein QKU48_gp1063 [Fadolivirus algeromassiliense]	diamond	207	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
28991127	28991127	PRJEB11748_P_NODE_236148_length_256_cov_1.810256_g233965_i0	PRJEB11748	236148	256	1.810256	4.63425536	carnivorous sponge associated iridovirus	2971331	Viruses	Viruses	101	1.5899999999999995e-23	NR	UUT40495.1	2971331	g233965	i0	71.2	0.7734375	66	19	77.3	0	33	230	13	78	UUT40495.1 hypothetical protein [carnivorous sponge associated iridovirus]	diamond	198	101	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		carnivorous sponge associated iridovirus
29054155	29054155	PRJEB11748_P_NODE_312888_length_213_cov_9.243421_g310705_i0	PRJEB11748	312888	213	9.243421	19.68848673	Klosneuvirus KNV1	1977640	Viruses	Viruses	45.8	0.00178	NR	ARF12633.1	1977640	g310705	i0	64.3	0.394366197183099	28	10	39.4	0	191	108	2	29	ARF12633.1 zinc finger protein [Klosneuvirus KNV1]	diamond	84	45.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
29180556	29180556	PRJEB11748_P_NODE_376209_length_182_cov_9.826446_g374026_i0	PRJEB11748	376209	182	9.826446	17.88413172	Edafosvirus sp.	2487765	Viruses	Viruses	68.2	2.62e-12	NR	AYV78393.1	2487765	g374026	i0	68.9	1.68131868131868	45	14	74.2	0	24	158	126	170	AYV78393.1 MAG: hypothetical protein Edafosvirus11_28 [Edafosvirus sp.]	diamond	306	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31638398	31638398	PRJEB11748_P_NODE_31836_length_784_cov_5.705394_g29968_i0	PRJEB11748	31836	784	5.705394	44.73028896	Prasinovirus	181084	Viruses	Viruses	232	5.68e-70	NR	QIG59838.1	2704074	g29968	i0	65.9	3.17219387755102	167	57	63.9	0	783	283	282	448	QIG59838.1 hypothetical protein [Dishui Lake phycodnavirus 3]	diamond	2487	233	0.995708154506438	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Dishui Lake phycodnavirus 3

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