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

6 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax_kingdom = "Orthornavirae"

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.
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
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.

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