metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA169559" 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
26630790	26630790	PRJNA169559_P_NODE_25301_length_299_cov_1.385185_g23225_i0	PRJNA169559	25301	299	1.3851850000000001	4.14170315	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	57.8	3.58e-7	NR	YP_010803269.1	3060017	g23225	i0	62.5	0.40133779264214	40	15	40.1	0	3	122	153	192	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	120	57.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27231938	27231938	PRJNA169559_P_NODE_3403_length_903_cov_2.027460_g2326_i0	PRJNA169559	3403	903	2.02746	18.3079638	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	266	6.31e-83	NR	YP_010803269.1	3060017	g2326	i0	52.9	0.803986710963455	242	114	80.4	0	899	174	173	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	726	266	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30800498	30800498	PRJNA169559_P_NODE_22074_length_342_cov_2.460064_g20009_i0	PRJNA169559	22074	342	2.460064	8.41341888	uncultured virus	340016	Viruses	Viruses	102	1.43e-22	NR	CAH6420218.1	340016	g20009	i0	40.7	1.95614035087719	113	67	99.1	0	339	1	92	204	CAH6420218.1 Hypothetical protein MVR_LOCUS69 [uncultured virus]	diamond	669	102	1	Viruses							uncultured virus
30958696	30958696	PRJNA169559_P_NODE_16754_length_414_cov_2.329870_g14776_i0	PRJNA169559	16754	414	2.32987	9.6456618	Marseillevirus LCMAC1	2506602	Viruses	Viruses	52	2.07e-5	NR	QBK85646.1	2506602	g14776	i0	35.4	0.471014492753623	65	42	47.1	0	205	399	36	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	195	52	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
31053673	31053673	PRJNA169559_P_NODE_47775_length_171_cov_2.654930_g45698_i0	PRJNA169559	47775	171	2.65493	4.5399303	uncultured virus	340016	Viruses	Viruses	44.7	0.00308	NR	CAH6419193.1	340016	g45698	i0	42	1.75438596491228	50	29	87.7	0	19	168	797	846	CAH6419193.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	300	44.7	1	Viruses							uncultured virus
31559483	31559483	PRJNA169559_P_NODE_5716_length_710_cov_9.505140_g4319_i0	PRJNA169559	5716	710	9.50514	67.486494	Edafosvirus sp.	2487765	Viruses	Viruses	70.9	5.4e-10	NR	AYV78747.1	2487765	g4319	i0	28.7	0.633802816901408	150	77	59.2	5	165	584	1013	1142	AYV78747.1 MAG: hypothetical protein Edafosvirus29_11 [Edafosvirus sp.]	diamond	450	70.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31622483	31622483	PRJNA169559_P_NODE_42236_length_229_cov_1.975000_g40159_i0	PRJNA169559	42236	229	1.975	4.52275	Emiliania huxleyi virus 2	181208	Viruses	Viruses	46.6	0.00118	NR	AET98133.1	181210	g40159	i0	44.2	0.563318777292576	43	23	56.3	1	100	228	45	86	AET98133.1 hypothetical protein EPVG_00246 [Emiliania huxleyi virus 201]	diamond	129	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 201
32128924	32128924	PRJNA169559_P_NODE_48238_length_162_cov_2.120301_g46161_i0	PRJNA169559	48238	162	2.120301	3.43488762	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	47	3.87e-4	NR	YP_010803269.1	3060017	g46161	i0	52.4	0.777777777777778	42	20	77.8	0	160	35	373	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	126	47	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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