metadata: contig_metadata: 6 rows where bioproject = "PRJEB64798" and tax

6 rows where bioproject = "PRJEB64798" and tax_clade = "Pithoviruses"

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_clade	tax_genus	tax_species
26907106	26907106	PRJEB64798_P_NODE_115642_length_208_cov_10.641509_g113876_i0	PRJEB64798	115642	208	10.641509	22.13433872	Pithovirus LCPAC3	2506594	Viruses	Viruses	53.5	3.58e-6	NR	QBK92009.1	2506594	g113876	i0	65.6	0.461538461538462	32	11	46.2	0	206	111	557	588	QBK92009.1 MAG: A18-like helicase [Pithovirus LCPAC304]	diamond	96	53.5	1	Viruses	Pithoviruses		Pithovirus LCPAC304
29118174	29118174	PRJEB64798_P_NODE_139449_length_193_cov_23.027778_g137683_i0	PRJEB64798	139449	193	23.027778	44.44361154	Cedratvirus A11	1903266	Viruses	Viruses	48.9	1.19e-4	NR	YP_009329004.1	1903266	g137683	i0	38.6	2.17616580310881	70	34	94.8	3	183	1	78	147	YP_009329004.1 Hypothetical protein BQ3484_64 [Cedratvirus A11]	diamond	420	48.9	1	Viruses	Pithoviruses	Alphacedratvirus	Alphacedratvirus aljazairmassiliense
29307301	29307301	PRJEB64798_P_NODE_115329_length_208_cov_16.364780_g113563_i0	PRJEB64798	115329	208	16.36478	34.0387424	Pithovirus LCPAC3	2506594	Viruses	Viruses	43.5	0.0131	NR	QBK91764.1	2506594	g113563	i0	48.4	0.447115384615385	31	16	44.7	0	93	1	47	77	QBK91764.1 MAG: DEAD/SNF2-like helicase [Pithovirus LCPAC304]	diamond	93	43.5	1	Viruses	Pithoviruses		Pithovirus LCPAC304
30886831	30886831	PRJEB64798_P_NODE_176934_length_175_cov_19.531746_g175168_i0	PRJEB64798	176934	175	19.531746	34.1805555	Pithovirus LCPAC3	2506593	Viruses	Viruses	72.8	3.1e-13	NR	QBK91577.1	2506593	g175168	i0	67.3	0.942857142857143	55	18	94.3	0	7	171	219	273	QBK91577.1 MAG: hypothetical protein LCPAC302_01970 [Pithovirus LCPAC302]	diamond	165	72.8	1	Viruses	Pithoviruses		Pithovirus LCPAC302
31234308	31234308	PRJEB64798_P_NODE_249875_length_152_cov_2.592233_g248109_i0	PRJEB64798	249875	152	2.592233	3.94019416	Pithovirus LCPAC3	2506593	Viruses	Viruses	48.9	5.52e-5	NR	QBK91384.1	2506593	g248109	i0	36.8	1.125	57	28	96.7	2	3	149	104	160	QBK91384.1 MAG: galactosyl transferase GMA12/MNN10 family protein [Pithovirus LCPAC302]	diamond	171	48.9	1	Viruses	Pithoviruses		Pithovirus LCPAC302
31866864	31866864	PRJEB64798_P_NODE_203417_length_166_cov_6.717949_g201651_i0	PRJEB64798	203417	166	6.717949	11.15179534	Solumvirus sp.	2487773	Viruses	Viruses	75.9	2.76e-14	NR	AYV86346.1	2487773	g201651	i0	63	0.975903614457831	54	20	97.6	0	4	165	219	272	AYV86346.1 MAG: hypothetical protein Solumvirus5_13 [Solumvirus sp.]	diamond	162	75.9	1	Viruses	Pithoviruses		Solumvirus sp.

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