metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA663960" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA663960" 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
3713813	3713813	PRJNA663960_S_NODE_43_length_2151_cov_43.415399_g19_i1	PRJNA663960	43	2151	43.415399	933.86523249	Moloney murine leukemia virus	11801	Viruses	Viruses	1295	0	NR	NP_057933.2	11801	g19	i1	97.6	2.76569037656904	659	16	91.9	0	2070	94	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5949	1295	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
13916049	13916049	PRJNA663960_S_NODE_31_length_2381_cov_39.373608_g19_i0	PRJNA663960	31	2381	39.373608	937.48560648	Moloney murine leukemia virus	11801	Viruses	Viruses	1295	0	NR	NP_057933.2	11801	g19	i0	97.6	2.49097018059639	659	16	83	0	2300	324	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5931	1295	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26650264	26650264	PRJNA663960_S_NODE_58541_length_161_cov_0.894737_g58305_i0	PRJNA663960	58541	161	0.894737	1.44052657	Viruses	10239	Viruses	Viruses	58.5	5.73e-9	NR	QAU04449.1	2508852	g58305	i0	47.2	2.96273291925466	53	28	98.8	0	159	1	68	120	QAU04449.1 anaerobic ribonucleoside-triphosphate reductase activating protein [Vibrio phage Va1]	diamond	477	58.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage Va1
28123758	28123758	PRJNA663960_S_NODE_44985_length_181_cov_1.902985_g44749_i0	PRJNA663960	44985	181	1.902985	3.44440285	Pseudomonas phage Astolliot	2928830	Viruses	Viruses	42	0.00413	NR	UOL48816.1	2928830	g44749	i0	44.7	0.779005524861878	47	25	77.9	1	2	142	10	55	UOL48816.1 hypothetical protein [Pseudomonas phage Astolliot]	diamond	141	42	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Otagovirus	Pseudomonas phage Astolliot
28376224	28376224	PRJNA663960_S_NODE_50886_length_170_cov_1.243902_g50650_i0	PRJNA663960	50886	170	1.243902	2.1146334	Riboviria sp.	2585031	Viruses	Viruses	105	5.0399999999999995e-25	NR	QDH86582.1	2585031	g50650	i0	92.7	0.970588235294118	55	4	97.1	0	167	3	315	369	QDH86582.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.]	diamond	165	105	1	Viruses							Riboviria sp.
30429405	30429405	PRJNA663960_S_NODE_4153_length_438_cov_3.864450_g3918_i0	PRJNA663960	4153	438	3.86445	16.926291	Riboviria sp.	2585031	Viruses	Viruses	217	1.3100000000000001e-65	NR	QDH86582.1	2585031	g3918	i0	91.3	0.787671232876712	115	10	78.8	0	3	347	370	484	QDH86582.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.]	diamond	345	217	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);;