metadata: contig_metadata: 7 rows where bioproject = "PRJNA195897" and tax

7 rows where bioproject = "PRJNA195897" and tax_kingdom = "Bamfordvirae"

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
18217674	18217674	PRJNA195897_P_NODE_3195_length_274_cov_1.413333_g3162_i0	PRJNA195897	3195	274	1.413333	3.87253242	Indivirus ILV1	1977633	Viruses	Viruses	108	5.3e-19	NTclustered	gi\|1174570775\|gb\|KY684086.1\|	1977633	g3162	i0	83.333	0.693430656934307	120	17	43	3	120	238	146633	146516	Indivirus ILV1 isolate ILV1 clone Indivirus_2, sequence	blastn	190	108	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
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
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);;