metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA934472" 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
27063600	27063600	PRJNA934472_P_NODE_37862_length_243_cov_3.917647_g37484_i0	PRJNA934472	37862	243	3.917647	9.51988221	Leviviricetes	2842243	Viruses	Viruses	57.4	2.48e-7	NR	UJQ85483.1	2027243	g37484	i0	39.4	2.4320987654321	71	39	87.7	1	213	1	219	285	UJQ85483.1 MAG: hypothetical protein 1 [Leviviridae sp.]	diamond	591	57.4	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
27088302	27088302	PRJNA934472_P_NODE_27882_length_280_cov_1.743961_g27504_i0	PRJNA934472	27882	280	1.743961	4.8830908	Changjiang levi-like virus 1	1922773	Viruses	Viruses	99.8	1.11e-22	NR	APG77113.1	1922773	g27504	i0	74.6	0.632142857142857	59	15	63.2	0	35	211	110	168	APG77113.1 hypothetical protein [Changjiang levi-like virus 1]	diamond	177	99.8	1	Viruses							Changjiang levi-like virus 1
27657017	27657017	PRJNA934472_P_NODE_38224_length_243_cov_0.905882_g37846_i0	PRJNA934472	38224	243	0.905882	2.20129326	Bacteriophage sp.	38018	Viruses	Viruses	159	2.51e-43	NR	QHJ80602.1	38018	g37846	i0	93.8	0.987654320987654	80	5	98.8	0	3	242	649	728	QHJ80602.1 MAG: hypothetical protein [Bacteriophage sp.]	diamond	240	159	1	Viruses							Bacteriophage sp.
29077802	29077802	PRJNA934472_P_NODE_18668_length_336_cov_1.171103_g18291_i0	PRJNA934472	18668	336	1.171103	3.93490608	Streptomyces phage SparkleGoddess	2283305	Viruses	Viruses	104	3.41e-25	NR	AXH68751.1	2283305	g18291	i0	50.9	1.95535714285714	110	41	87.5	2	43	336	6	114	AXH68751.1 major tail protein [Streptomyces phage SparkleGoddess]	diamond	657	104	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Stanwilliamsviridae	Gilsonvirus	Gilsonvirus comrade
30246366	30246366	PRJNA934472_P_NODE_16932_length_351_cov_1.107914_g16555_i0	PRJNA934472	16932	351	1.107914	3.88877814	Leviviridae sp.	2027243	Viruses	Viruses	100	6e-22	NR	URG15607.1	2027243	g16555	i0	44.2	4.94871794871795	113	58	93.2	2	351	25	275	386	URG15607.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	1737	100	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
30341473	30341473	PRJNA934472_P_NODE_25872_length_289_cov_3.069444_g25494_i0	PRJNA934472	25872	289	3.069444	8.87069316	Hangzhou steitz-like virus 7	3029018	Viruses	Viruses	52	3.39e-5	NR	WEU70967.1	3029018	g25494	i0	35.6	1.78546712802768	87	52	90.3	3	1	261	275	357	WEU70967.1 MAG: maturation protein [Hangzhou steitz-like virus 7]	diamond	516	52	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae		Hangzhou steitz-like virus 7
30758761	30758761	PRJNA934472_P_NODE_37414_length_245_cov_0.895349_g37036_i0	PRJNA934472	37414	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	58.9	7.74e-8	NR	YP_001429638.1	458639	g37036	i0	41.7	1.48163265306122	60	35	73.5	0	181	2	1123	1182	YP_001429638.1 endolysin [Bacillus phage 0305phi8-36]	diamond	363	58.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Bacillus phage 0305phi8-36
30878032	30878032	PRJNA934472_P_NODE_28334_length_278_cov_1.502439_g27956_i0	PRJNA934472	28334	278	1.502439	4.17678042	uncultured Caudovirales phage	2100421	Viruses	Viruses	62.4	5.12e-9	NR	CAB4131244.1	2100421	g27956	i0	48.5	0.712230215827338	66	31	70.1	2	274	80	234	297	CAB4131244.1 DNA primase/polymerase, bifunctional, N-terminal [uncultured Caudovirales phage]	diamond	198	62.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
31162130	31162130	PRJNA934472_P_NODE_16575_length_354_cov_1.893238_g16198_i0	PRJNA934472	16575	354	1.893238	6.70206252	ssRNA phage Esthiorhiza.2_3	2786047	Viruses	Viruses	65.9	9.26e-10	NR	YP_010769523.1	2786048	g16198	i0	32.2	1.99152542372881	118	68	99.2	2	2	352	199	305	YP_010769523.1 maturation protein [ssRNA phage Esthiorhiza.2_30]	diamond	705	65.9	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Mihkrovirus	Mihkrovirus pedovicinum
31573738	31573738	PRJNA934472_P_NODE_12176_length_408_cov_4.313433_g11799_i0	PRJNA934472	12176	408	4.313433	17.59880664	Riparelt virus	3130044	Viruses	Viruses	113	3.01e-26	NR	WZH59164.1	3130044	g11799	i0	42.9	0.977941176470588	133	71	95.6	3	392	3	358	488	WZH59164.1 MAG: maturation protein, partial [Riparelt virus]	diamond	399	113	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Riparelt virus
32774680	32774680	PRJNA934472_P_NODE_22540_length_308_cov_2.404255_g22162_i0	PRJNA934472	22540	308	2.404255	7.4051054	Leviviridae sp.	2027243	Viruses	Viruses	122	7.999999999999998e-30	NR	UJQ85814.1	2027243	g22162	i0	60.8	1.97727272727273	102	40	99.4	0	1	306	242	343	UJQ85814.1 MAG: hypothetical protein 2 [Leviviridae sp.]	diamond	609	122	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
32869219	32869219	PRJNA934472_P_NODE_23760_length_301_cov_1.210526_g23382_i0	PRJNA934472	23760	301	1.210526	3.64368326	Riboviria sp.	2585031	Viruses	Viruses	73.6	7.44e-13	NR	WKV34107.1	2585031	g23382	i0	61.7	0.598006644518272	60	20	56.8	1	174	4	10	69	WKV34107.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.]	diamond	180	73.6	1	Viruses							Riboviria 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);;