metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1123309" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1123309" 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
26848841	26848841	PRJNA1123309_P_NODE_23901_length_328_cov_1.164706_g23521_i0	PRJNA1123309	23901	328	1.164706	3.82023568	Bodo saltans virus	2024608	Viruses	Viruses	48.1	0.00127	NR	YP_010778218.1	2024608	g23521	i0	50	0.365853658536585	40	20	36.6	0	155	36	758	797	YP_010778218.1 hypothetical protein QJ851_gp0379 [Bodo saltans virus]	diamond	120	48.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
27828335	27828335	PRJNA1123309_P_NODE_27524_length_309_cov_0.983051_g27144_i0	PRJNA1123309	27524	309	0.983051	3.03762759	Circular genetic element sp.	2202954	Viruses	Viruses	60.8	3.28e-8	NR	AXH78947.1	2202954	g27144	i0	49.1	0.514563106796116	53	26	51.5	1	162	4	2	53	AXH78947.1 MAG: putative rep protein [Circular genetic element sp.]	diamond	159	60.8	1	Viruses							Circular genetic element sp.
28144261	28144261	PRJNA1123309_P_NODE_60685_length_245_cov_0.906977_g60305_i0	PRJNA1123309	60685	245	0.906977	2.22209365	uncultured Caudovirales phage	2100421	Viruses	Viruses	107	3.88e-26	NR	CAB4154031.1	2100421	g60305	i0	89.5	0.697959183673469	57	6	69.8	0	73	243	1	57	CAB4154031.1 Thrombospondin type-1 (TSP1) repeat, partial [uncultured Caudovirales phage]	diamond	171	107	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
29059787	29059787	PRJNA1123309_P_NODE_57908_length_247_cov_0.896552_g57528_i0	PRJNA1123309	57908	247	0.896552	2.21448344	Microvirus sp.	2202559	Viruses	Viruses	72	1.82e-12	NR	QJB19969.1	2202559	g57528	i0	51.6	0.753036437246964	62	30	75.3	0	60	245	1	62	QJB19969.1 MAG: major capsid protein [Microvirus sp.]	diamond	186	72	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
29501624	29501624	PRJNA1123309_P_NODE_61390_length_245_cov_0.906977_g61010_i0	PRJNA1123309	61390	245	0.906977	2.22209365	Staphylococcus phage vB_SepS_SEP9	1434319	Viruses	Viruses	43.9	0.00131	NR	YP_009007751.1	1434319	g61010	i0	65.5	0.355102040816327	29	10	35.5	0	90	4	3	31	YP_009007751.1 hypothetical protein SEP9_083 [Staphylococcus phage vB_SepS_SEP9]	diamond	87	43.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Sextaecvirus SEP9
31207149	31207149	PRJNA1123309_P_NODE_18655_length_364_cov_1.037801_g18276_i0	PRJNA1123309	18655	364	1.037801	3.77759564	Catovirus CTV1	1977631	Viruses	Viruses	174	6.94e-52	NR	ARF08994.1	1977631	g18276	i0	71.3	0.947802197802198	115	33	94.8	0	18	362	83	197	ARF08994.1 hypothetical protein Catovirus_1_1044 [Catovirus CTV1]	diamond	345	174	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
31365965	31365965	PRJNA1123309_P_NODE_51536_length_251_cov_0.865169_g51156_i0	PRJNA1123309	51536	251	0.865169	2.17157419	Caudoviricetes sp.	2832643	Viruses	Viruses	120	1.37e-29	NR	XOS26090.1	2832643	g51156	i0	67.1	0.9800796812749	82	27	98	0	1	246	467	548	XOS26090.1 MAG: hypothetical protein MSP0002_7 [Caudoviricetes sp.]	diamond	246	120	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31428976	31428976	PRJNA1123309_P_NODE_50916_length_251_cov_0.876404_g50536_i0	PRJNA1123309	50916	251	0.876404	2.19977404	Flavobacterium phage Fpv2	1814282	Viruses	Viruses	57.8	7.89e-8	NR	YP_009321918.1	1814283	g50536	i0	49	0.585657370517928	49	25	58.6	0	104	250	1	49	YP_009321918.1 hypothetical protein BOW81_gp49 [Flavobacterium phage Fpv20]	diamond	147	57.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Fipvunavirus	Flavobacterium phage Fpv20
31934988	31934988	PRJNA1123309_P_NODE_13397_length_418_cov_3.127536_g13020_i0	PRJNA1123309	13397	418	3.127536	13.07310048	Terrestrivirus sp.	2487775	Viruses	Viruses	58.9	5.63e-7	NR	AYV76628.1	2487775	g13020	i0	35.9	0.91866028708134	128	55	78.9	6	366	37	173	291	AYV76628.1 MAG: hypothetical protein Terrestrivirus10_12 [Terrestrivirus sp.]	diamond	384	58.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31998451	31998451	PRJNA1123309_P_NODE_64018_length_243_cov_0.917647_g63638_i0	PRJNA1123309	64018	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	144	2.0699999999999998e-42	NR	DAL41053.1	2832643	g63638	i0	93.4	2.81481481481481	76	5	93.8	0	14	241	7	82	DAL41053.1 MAG TPA_asm: Terminase [Caudoviricetes sp.]	diamond	684	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32030148	32030148	PRJNA1123309_P_NODE_21378_length_344_cov_1.206642_g20999_i0	PRJNA1123309	21378	344	1.206642	4.15084848	Circular genetic element sp.	2202954	Viruses	Viruses	54.7	3.71e-6	NR	AXH78727.1	2202954	g20999	i0	59.5	0.366279069767442	42	17	36.6	0	132	7	1	42	AXH78727.1 MAG: hypothetical protein [Circular genetic element sp.]	diamond	126	54.7	1	Viruses							Circular genetic element sp.
32125162	32125162	PRJNA1123309_P_NODE_50458_length_251_cov_0.876404_g50078_i0	PRJNA1123309	50458	251	0.876404	2.19977404	Catovirus CTV1	1977631	Viruses	Viruses	96.3	5.839999999999999e-23	NR	ARF08745.1	1977631	g50078	i0	59.2	0.848605577689243	71	29	84.9	0	37	249	23	93	ARF08745.1 hypothetical protein Catovirus_1_795 [Catovirus CTV1]	diamond	213	96.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
32251863	32251863	PRJNA1123309_P_NODE_64538_length_243_cov_0.917647_g64158_i0	PRJNA1123309	64538	243	0.917647	2.22988221	Harvfovirus sp.	2487768	Viruses	Viruses	62	6.07e-9	NR	AYV81013.1	2487768	g64158	i0	60	0.617283950617284	50	20	61.7	0	13	162	368	417	AYV81013.1 MAG: SPFH domain / Band 7 domain containing protein [Harvfovirus sp.]	diamond	150	62	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
32504859	32504859	PRJNA1123309_P_NODE_39119_length_273_cov_1.135000_g38739_i0	PRJNA1123309	39119	273	1.135	3.09855	Pimephales minnow adintovirus	2609864	Viruses	Viruses	44.7	0.0102	NR	DAC81404.1	2609864	g38739	i0	36	1.68131868131868	75	47	81.3	1	240	19	42	116	DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus]	diamond	459	45.1	0.991130820399113	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
32714548	32714548	PRJNA1123309_P_NODE_59360_length_246_cov_0.901734_g58980_i0	PRJNA1123309	59360	246	0.901734	2.21826564	Ghabrivirales	2732540	Viruses	Viruses	78.2	1.31e-14	NR	UUT40380.1	2971329	g58980	i0	45	2.8780487804878	80	41	96.3	2	7	243	480	557	UUT40380.1 coat protein [Geotrichum candidum totivirus 3b]	diamond	708	78.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Geotrichum candidum totivirus 3b

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