metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA438572" 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
4262052	4262052	PRJNA438572_P_NODE_20564_length_248_cov_0.891429_g20445_i0	PRJNA438572	20564	248	0.891429	2.21074392	Klebsiella phage PhiKpNIH-6	2689112	Viruses	Viruses	160	1.6599999999999996e-43	NR	QHB49514.1	2689112	g20445	i0	98.8	0.991935483870968	82	1	99.2	0	2	247	732	813	QHB49514.1 baseplate wedge subunit [Klebsiella phage PhiKpNIH-6]	diamond	246	160	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Marfavirus	Marfavirus F48
17012301	17012301	PRJNA438572_P_NODE_17574_length_252_cov_0.871508_g17455_i0	PRJNA438572	17574	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	125	6.5699999999999985e-34	NR	YP_184882.1	39640	g17455	i0	71.1	4.96428571428571	83	23	97.6	1	252	7	65	147	YP_184882.1 hypothetical protein CcBV_31.2 [Bracoviriform congregatae]	diamond	1251	126	0.992063492063492	Viruses					Polydnaviriformidae	Bracoviriform	Bracoviriform congregatae
26822967	26822967	PRJNA438572_P_NODE_12481_length_292_cov_0.963470_g12362_i0	PRJNA438572	12481	292	0.96347	2.8133324	Chlorovirus sp.	2809302	Viruses	Viruses	57	6.44e-7	NR	XOK29430.1	2809302	g12362	i0	51	0.503424657534247	49	23	49.3	1	2	145	282	330	XOK29430.1 Mastigoneme-like protein [Chlorovirus sp.]	diamond	147	57	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
27265732	27265732	PRJNA438572_P_NODE_1583_length_759_cov_1.774052_g1479_i0	PRJNA438572	1583	759	1.774052	13.46505468	Erysiphe necator associated virus 1	2741902	Viruses	Viruses	385	8.11e-129	NR	QKI79983.1	2741902	g1479	i0	71.4	3.98418972332016	252	71	99.6	1	2	757	76	326	QKI79983.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 1]	diamond	3024	385	1	Viruses							Erysiphe necator associated virus 1
27897138	27897138	PRJNA438572_P_NODE_8345_length_352_cov_4.544803_g8226_i0	PRJNA438572	8345	352	4.544803	15.99770656	Faustovirus ST1	1973452	Viruses	Viruses	77.8	6.04e-14	NR	SME65073.1	1973452	g8226	i0	54.4	0.579545454545455	68	31	58	0	5	208	367	434	SME65073.1 Cysteine desulfurase [Faustovirus ST1]	diamond	204	77.8	1	Viruses							Faustovirus ST1
28528901	28528901	PRJNA438572_P_NODE_17787_length_252_cov_0.871508_g17668_i0	PRJNA438572	17787	252	0.871508	2.19620016	Caudoviricetes sp.	2832643	Viruses	Viruses	163	1.39e-44	NR	XOR52197.1	2832643	g17668	i0	89.3	2	84	9	100	0	252	1	591	674	XOR52197.1 MAG: terminase large subunit [Caudoviricetes sp.]	diamond	504	163	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28528904	28528904	PRJNA438572_P_NODE_19467_length_249_cov_0.886364_g19348_i0	PRJNA438572	19467	249	0.886364	2.20704636	Methylophilaceae phage P1925	1913040	Viruses	Viruses	43.1	0.0296	NR	APC43904.1	1913040	g19348	i0	46.6	0.698795180722892	58	28	66.3	1	83	247	798	855	APC43904.1 host specificity protein J [Methylophilaceae phage P19250A]	diamond	174	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Methylophilaceae phage P19250A
28765959	28765959	PRJNA438572_P_NODE_20707_length_247_cov_1.344828_g20588_i0	PRJNA438572	20707	247	1.344828	3.32172516	root	1	Root_unresolved	Root_unresolved	45.8	0.00334	NR	BAR34331.1	1407671	g20588	i0	57.6	1.46963562753036	33	14	40.1	0	2	100	1242	1274	BAR34331.1 hypothetical protein [uncultured Mediterranean phage uvMED]	diamond	363	46.2	0.991341991341991	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
29318017	29318017	PRJNA438572_P_NODE_20669_length_247_cov_1.758621_g20550_i0	PRJNA438572	20669	247	1.758621	4.34379387	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	110	2.3e-26	NR	YP_010803269.1	3060017	g20550	i0	60.5	0.983805668016194	81	32	98.4	0	243	1	222	302	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	243	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29349735	29349735	PRJNA438572_P_NODE_14369_length_275_cov_1.158416_g14250_i0	PRJNA438572	14369	275	1.158416	3.185644	Ralstonia phage RsoM2USA	2070027	Viruses	Viruses	51.6	4.26e-5	NR	AVH85344.1	2070027	g14250	i0	44.8	1.38545454545455	58	32	63.3	0	273	100	191	248	AVH85344.1 hypothetical protein RsoM2USA_416 [Ralstonia phage RsoM2USA]	diamond	381	51.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Ralstonia phage RsoM2USA
29381250	29381250	PRJNA438572_P_NODE_7049_length_379_cov_2.941176_g6930_i0	PRJNA438572	7049	379	2.941176	11.14705704	Catovirus CTV1	1977631	Viruses	Viruses	86.3	1.11e-17	NR	ARF09195.1	1977631	g6930	i0	42.1	0.846965699208443	107	59	82.3	1	63	374	73	179	ARF09195.1 hypothetical protein Catovirus_2_144 [Catovirus CTV1]	diamond	321	86.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
30644566	30644566	PRJNA438572_P_NODE_22853_length_244_cov_0.912281_g22734_i0	PRJNA438572	22853	244	0.912281	2.22596564	Caudoviricetes sp.	2832643	Viruses	Viruses	75.1	1.51e-13	NR	DAS78333.1	2832643	g22734	i0	48.8	2.01639344262295	82	36	99.6	3	244	2	485	561	DAS78333.1 MAG TPA: DNA polymerase B [Caudoviricetes sp.]	diamond	492	75.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30707854	30707854	PRJNA438572_P_NODE_24514_length_242_cov_0.923077_g24395_i0	PRJNA438572	24514	242	0.923077	2.23384634	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	46.6	0.00162	NR	VBB18962.1	2420051	g24395	i0	31.4	2.25619834710744	70	44	86.8	1	242	33	232	297	VBB18962.1 phosphoribosylpyrophosphate synthetase [Yasminevirus sp. GU-2018]	diamond	546	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
31624562	31624562	PRJNA438572_P_NODE_14036_length_278_cov_1.136585_g13917_i0	PRJNA438572	14036	278	1.136585	3.1597063	Erysiphe necator associated flexivirus 3	2743100	Viruses	Viruses	139	4.95e-36	NR	QKN22675.1	2743100	g13917	i0	68.1	0.982014388489209	91	29	98.2	0	275	3	242	332	QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3]	diamond	273	139	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 3
31830509	31830509	PRJNA438572_P_NODE_23177_length_244_cov_0.912281_g23058_i0	PRJNA438572	23177	244	0.912281	2.22596564	Straboviridae	2946170	Viruses	Viruses	54.3	2.15e-7	NR	YP_010092337.1	2006942	g23058	i0	53.5	1.56147540983607	43	20	52.9	0	1	129	43	85	YP_010092337.1 hypothetical protein KNT72_gp229 [Serratia phage X20]	diamond	381	54.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Winklervirus	Winklervirus xtwenty
32067393	32067393	PRJNA438572_P_NODE_23038_length_244_cov_0.912281_g22919_i0	PRJNA438572	23038	244	0.912281	2.22596564	Fusarium mangiferae partitivirus 1	2880274	Viruses	Viruses	84	1.17e-16	NR	UBZ25877.1	2880274	g22919	i0	49.4	0.971311475409836	79	40	97.1	0	2	238	377	455	UBZ25877.1 coat protein [Fusarium mangiferae partitivirus 1]	diamond	237	84	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Fusarium mangiferae partitivirus 1
32162573	32162573	PRJNA438572_P_NODE_8898_length_342_cov_1.059480_g8779_i0	PRJNA438572	8898	342	1.05948	3.6234216	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	95.1	2.7e-20	NR	YP_010803269.1	3060017	g8779	i0	62.3	0.605263157894737	69	26	60.5	0	341	135	346	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	207	95.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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