metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA577580" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA577580" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
13318047	13318047	PRJNA577580_P_NODE_5031_length_400_cov_1.431193_g4953_i0	PRJNA577580	5031	400	1.431193	5.724772	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	93.6	3.4e-19	NR	QIG59935.1	2704072	g4953	i0	41.1	0.93	124	55	87	4	389	42	254	367	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	372	93.6	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
14592951	14592951	PRJNA577580_P_NODE_8912_length_304_cov_2.528139_g8834_i0	PRJNA577580	8912	304	2.528139	7.68554256	Solumvirus sp.	2487773	Viruses	Viruses	109	3.5100000000000004e-27	NR	AYV86227.1	2487773	g8834	i0	86.7	0.592105263157895	60	8	59.2	0	304	125	125	184	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	180	109	1	Viruses	Pithoviruses							Solumvirus sp.
28058722	28058722	PRJNA577580_P_NODE_12625_length_261_cov_1.659574_g12547_i0	PRJNA577580	12625	261	1.659574	4.33148814	Mitoviridae sp.	2809572	Viruses	Viruses	52.8	1.41e-5	NR	UJQ92489.1	2809572	g12547	i0	35.7	0.804597701149425	70	45	80.5	0	52	261	20	89	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	210	52.8	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
28121958	28121958	PRJNA577580_P_NODE_2725_length_547_cov_1.666667_g2647_i0	PRJNA577580	2725	547	1.666667	9.11666849	Dishui Lake large algae virus 1	2704073	Viruses	Viruses	68.9	4.75e-11	NR	QIG60086.1	2704073	g2647	i0	38.1	1.82632541133455	97	55	50.5	2	139	414	1	97	QIG60086.1 Erv1 [Dishui Lake large algae virus 1]	diamond	999	68.9	1	Viruses								Dishui Lake large algae virus 1
28248070	28248070	PRJNA577580_P_NODE_686_length_1036_cov_2.997923_g637_i0	PRJNA577580	686	1036	2.997923	31.05848228	Mitoviridae sp.	2809572	Viruses	Viruses	171	1.1e-43	NR	UJQ92489.1	2809572	g637	i0	37.2	0.732625482625483	253	154	71.8	2	270	1013	9	261	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	759	171	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
28595719	28595719	PRJNA577580_P_NODE_13147_length_256_cov_1.644809_g13069_i0	PRJNA577580	13147	256	1.644809	4.21071104	Barrevirus sp.	2487763	Viruses	Viruses	52	1.54e-5	NR	AYV77273.1	2487763	g13069	i0	32.5	0.97265625	83	54	97.3	1	254	6	94	174	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	249	52	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29745446	29745446	PRJNA577580_P_NODE_9010_length_303_cov_1.356522_g8932_i0	PRJNA577580	9010	303	1.356522	4.11026166	Duamitovirus	2948686	Viruses	Viruses	116	1.1300000000000002e-27	NR	YP_004564622.1	1037523	g8932	i0	65.5	4.16831683168317	84	23	77.2	1	239	6	339	422	YP_004564622.1 RNA-dependent RNA polymerase [Tuber aestivum mitovirus]	diamond	1263	117	0.991452991452991	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Duamitovirus	Duamitovirus tuae1
29858449	29858449	PRJNA577580_P_NODE_3791_length_462_cov_3.437018_g3713_i0	PRJNA577580	3791	462	3.437018	15.87902316	Marseillevirus LCMAC1	2506602	Viruses	Viruses	49.7	2.23e-4	NR	QBK85646.1	2506602	g3713	i0	37.8	0.480519480519481	74	44	46.8	1	52	267	34	107	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	222	49.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
30047870	30047870	PRJNA577580_P_NODE_16671_length_238_cov_2.024242_g16593_i0	PRJNA577580	16671	238	2.024242	4.81769596	Mitoviridae sp.	2809572	Viruses	Viruses	46.6	0.00155	NR	UJQ92489.1	2809572	g16593	i0	36.5	0.794117647058823	63	40	79.4	0	235	47	167	229	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	189	46.6	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
30205775	30205775	PRJNA577580_P_NODE_52_length_2278_cov_8.436735_g41_i0	PRJNA577580	52	2278	8.436735	192.1888233	Diaporthe gulyae mitovirus 3	3077427	Viruses	Viruses	144	8.62e-32	NR	WNM95031.1	3077427	g41	i0	29.2	0.578138718173837	439	269	55.7	12	406	1674	70	482	WNM95031.1 MAG: RNA-dependent RNA polymerase [Diaporthe gulyae mitovirus 3]	diamond	1317	144	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Diaporthe gulyae mitovirus 3
30837945	30837945	PRJNA577580_P_NODE_5634_length_377_cov_2.335526_g5556_i0	PRJNA577580	5634	377	2.335526	8.80493302	Marseillevirus LCMAC1	2506602	Viruses	Viruses	50.4	5.71e-5	NR	QBK85646.1	2506602	g5556	i0	32.4	0.541114058355438	68	46	54.1	0	359	156	33	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	204	50.4	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
31311941	31311941	PRJNA577580_P_NODE_435_length_1234_cov_7.890612_g397_i0	PRJNA577580	435	1234	7.890612	97.37015208	Ripajen virus	3131483	Viruses	Viruses	155	1.24e-37	NR	WZH61493.1	3131483	g397	i0	36.5	0.838735818476499	345	198	81.9	10	1011	1	45	376	WZH61493.1 MAG: RNA-dependent RNA polymerase [Ripajen virus]	diamond	1035	155	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripajen virus
31817983	31817983	PRJNA577580_P_NODE_14797_length_248_cov_0.891429_g14719_i0	PRJNA577580	14797	248	0.891429	2.21074392	Satyrvirus sp.	2487771	Viruses	Viruses	53.5	6.12e-6	NR	AYV85210.1	2487771	g14719	i0	37.5	1.95967741935484	80	47	94.4	2	8	241	30	108	AYV85210.1 MAG: serpin [Satyrvirus sp.]	diamond	486	53.5	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Satyrvirus sp.
32703228	32703228	PRJNA577580_P_NODE_9520_length_296_cov_1.399103_g9442_i0	PRJNA577580	9520	296	1.399103	4.14134488	Guangxi riverbank mitovirus 3	2937069	Viruses	Viruses	69.7	2.31e-11	NR	UPW42193.1	2937069	g9442	i0	40.2	2.93918918918919	97	57	97.3	1	295	8	379	475	UPW42193.1 MAG: putative RNA dependent RNA polymerase [Guangxi riverbank mitovirus 3]	diamond	870	69.7	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Guangxi riverbank mitovirus 3

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