metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA195897" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA195897" 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
365962	365962	PRJNA195897_P_NODE_1_length_9208_cov_44.865378_g0_i0	PRJNA195897	1	9208	44.865378	4131.20400624	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	3395	0	NR	WEU70895.1	3029006	g0	i0	62.8	0.891724587315378	2737	957	88.9	17	836	9022	12	2694	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	8211	3395	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
26711617	26711617	PRJNA195897_P_NODE_3961_length_241_cov_1.494792_g3928_i0	PRJNA195897	3961	241	1.494792	3.60244872	Viruses	10239	Viruses	Viruses	42.7	0.0367	NR	WPF46901.1	3086121	g3928	i0	30	1.94190871369295	60	42	74.7	0	23	202	384	443	WPF46901.1 MAG: putative major capsid protein [Lake Baikal virophage 16]	diamond	468	43.1	0.990719257540603	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae		Lake Baikal virophage 16
27547865	27547865	PRJNA195897_P_NODE_6924_length_189_cov_1.035714_g6891_i0	PRJNA195897	6924	189	1.035714	1.95749946	Moumouvirus goulette	1247379	Viruses	Viruses	83.2	4.96e-17	NR	YP_010779165.1	1247379	g6891	i0	53.2	0.984126984126984	62	29	98.4	0	3	188	245	306	YP_010779165.1 synthetase [Moumouvirus goulette]	diamond	186	83.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus goulettemassiliense
27642814	27642814	PRJNA195897_P_NODE_11304_length_164_cov_1.217391_g11271_i0	PRJNA195897	11304	164	1.217391	1.99652124	Gaeavirus sp.	2487767	Viruses	Viruses	63.5	5.8e-10	NR	AYV79987.1	2487767	g11271	i0	56.4	1.00609756097561	55	23	98.8	1	1	162	977	1031	AYV79987.1 MAG: mRNA capping enzyme [Gaeavirus sp.]	diamond	165	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
27990028	27990028	PRJNA195897_P_NODE_3065_length_280_cov_2.952381_g3032_i0	PRJNA195897	3065	280	2.952381	8.2666668	Gaeavirus sp.	2487767	Viruses	Viruses	65.9	7.8e-12	NR	AYV80119.1	2487767	g3032	i0	46.5	0.760714285714286	71	35	76.1	1	7	219	4	71	AYV80119.1 MAG: hypothetical protein Gaeavirus10_15 [Gaeavirus sp.]	diamond	213	65.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
28210771	28210771	PRJNA195897_P_NODE_486_length_768_cov_1.824757_g458_i0	PRJNA195897	486	768	1.824757	14.01413376	Klosneuvirus KNV1	1977640	Viruses	Viruses	278	3.67e-90	NR	ARF11950.1	1977640	g458	i0	57.6	0.9296875	238	99	93	1	763	50	64	299	ARF11950.1 elongation factor Tu EF-Tu-like protein [Klosneuvirus KNV1]	diamond	714	278	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28558408	28558408	PRJNA195897_P_NODE_3367_length_265_cov_2.004630_g3334_i0	PRJNA195897	3367	265	2.00463	5.3122695	Picornaviridae sp.	1530251	Viruses	Viruses	138	1.01e-35	NR	URG14784.1	1530251	g3334	i0	74.4	0.973584905660377	86	22	97.4	0	4	261	212	297	URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	258	138	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28779146	28779146	PRJNA195897_P_NODE_5827_length_202_cov_1.359477_g5794_i0	PRJNA195897	5827	202	1.359477	2.74614354	Changjiang picorna-like virus 2	1922791	Viruses	Viruses	59.7	2.33e-8	NR	YP_009336608.1	1922791	g5794	i0	43.3	0.995049504950495	67	37	98	1	4	201	849	915	YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2]	diamond	201	59.7	1	Viruses							Changjiang picorna-like virus 2
29158362	29158362	PRJNA195897_P_NODE_9269_length_169_cov_0.866667_g9236_i0	PRJNA195897	9269	169	0.866667	1.46466723	Marnaviridae sp.	2715102	Viruses	Viruses	57.8	6.94e-8	NR	ULG00022.1	2715102	g9236	i0	38.9	1.91715976331361	54	33	95.9	0	7	168	530	583	ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.]	diamond	324	57.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
29599954	29599954	PRJNA195897_P_NODE_6730_length_191_cov_1.098592_g6697_i0	PRJNA195897	6730	191	1.098592	2.09831072	uncultured virus	340016	Viruses	Viruses	47.8	1.98e-4	NR	CAH6421098.1	340016	g6697	i0	36.1	0.958115183246073	61	39	95.8	0	190	8	76	136	CAH6421098.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	183	47.8	1	Viruses							uncultured virus
32002181	32002181	PRJNA195897_P_NODE_10218_length_167_cov_0.872881_g10185_i0	PRJNA195897	10218	167	0.872881	1.45771127	Flamingopox virus FGPVKD	503979	Viruses	Viruses	54.7	8.06e-7	NR	YP_009448168.1	2059380	g10185	i0	55.3	8.60479041916168	47	21	84.4	0	27	167	156	202	YP_009448168.1 ankyrin repeat family protein [Flamingopox virus FGPVKD09]	diamond	1437	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Avipoxvirus	Flamingopox virus FGPVKD09

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