metadata: contig_metadata: 6 rows where bioproject = "PRJEB14175", tax_kingdom = "Bamfordvirae" and tax

6 rows where bioproject = "PRJEB14175", tax_kingdom = "Bamfordvirae" and tax_phylum = "Nucleocytoviricota"

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
25911641	25911641	PRJEB14175_P_NODE_15180_length_923_cov_10.520882_g13547_i0	PRJEB14175	15180	923	10.520882	97.10774086	Mimiviridae	549779	Viruses	Viruses	182	4.66e-52	NR	ARF09867.1	1977633	g13547	i0	63.9	1.19284940411701	122	44	39.7	0	409	44	11	132	ARF09867.1 hypothetical protein Indivirus_4_39 [Indivirus ILV1]	diamond	1101	182	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
26047577	26047577	PRJEB14175_P_NODE_150797_length_276_cov_1.190698_g148530_i0	PRJEB14175	150797	276	1.190698	3.28632648	Acanthocystis turfacea Chlorella virus OR	1278266	Viruses	Viruses	75	5.42e-9	NTclustered	gi\|448935730\|gb\|JX997185.1\|	1278277	g148530	i0	95.652	0.166666666666667	46	2	17	0	231	276	222927	222972	Acanthocystis turfacea Chlorella virus OR0704.3, partial genome	blastn	46	75	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Acanthocystis turfacea Chlorella virus OR0704.3
32908864	32908864	PRJEB14175_P_NODE_179113_length_245_cov_44.239130_g176846_i0	PRJEB14175	179113	245	44.23913	108.3858685	Iridovirus Liz-CrIV	2594309	Viruses	Viruses	68.2	4.03e-11	NR	QEA08244.1	2594309	g176846	i0	77.5	0.489795918367347	40	9	49	0	23	142	401	440	QEA08244.1 putative helicase [Iridovirus Liz-CrIV]	diamond	120	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Iridovirus Liz-CrIV
32908943	32908943	PRJEB14175_P_NODE_188969_length_237_cov_1.931818_g186702_i0	PRJEB14175	188969	237	1.931818	4.57840866	Barrevirus sp.	2487763	Viruses	Viruses	53.9	3.84e-6	NR	AYV76846.1	2487763	g186702	i0	43.4	0.670886075949367	53	28	67.1	1	215	57	183	233	AYV76846.1 MAG: HNH endonuclease [Barrevirus sp.]	diamond	159	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
32991156	32991156	PRJEB14175_P_NODE_241147_length_205_cov_14.791667_g238879_i0	PRJEB14175	241147	205	14.791667	30.32291735	Tupanvirus	2094720	Viruses	Viruses	96.3	3.14e-21	NR	YP_010780259.1	2126984	g238879	i0	71	1.81463414634146	62	18	90.7	0	187	2	147	208	YP_010780259.1 glycosyl hydrolase family 18 [Tupanvirus deep ocean]	diamond	372	96.7	0.995863495346432	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
33010898	33010898	PRJEB14175_P_NODE_120300_length_319_cov_3.089147_g118034_i0	PRJEB14175	120300	319	3.089147	9.85437893	European chub iridovirus	2578140	Viruses	Viruses	99	1.05e-24	NR	QCQ67839.1	2578140	g118034	i0	53.9	10.1755485893417	76	35	71.5	0	23	250	2	77	QCQ67839.1 ubiquitin family protein [European chub iridovirus]	diamond	3246	99	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		European chub iridovirus

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