metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax_kingdom = "Sangervirae"

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_species
4777097	4777097	PRJNA976345_P_NODE_8044_length_626_cov_2.377327_g6600_i0	PRJNA976345	8044	626	2.377327	14.88206702	Microviridae sp.	2202644	Viruses	Viruses	265	1.25e-85	NR	AXL15266.1	2202644	g6600	i0	64	1.85463258785942	197	62	92	3	580	5	1	193	AXL15266.1 replication initiator protein [Microviridae sp.]	diamond	1161	265	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
11471126	11471126	PRJNA976345_P_NODE_3589_length_1075_cov_3.625962_g2527_i0	PRJNA976345	3589	1075	3.625962	38.9790915	Microvirus sp.	2202559	Viruses	Viruses	110	7.67e-25	NR	QJB20403.1	2202559	g2527	i0	47	0.326511627906977	117	57	32.7	1	640	290	35	146	QJB20403.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	351	110	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
21350646	21350646	PRJNA976345_P_NODE_4977_length_847_cov_2.402709_g3738_i0	PRJNA976345	4977	847	2.402709	20.35094523	Viruses	10239	Viruses	Viruses	342	2.21e-111	NR	AVQ10214.1	1478972	g3738	i0	62.8	7.10507674144038	282	96	99.5	2	845	3	50	323	AVQ10214.1 putative major capsid protein [Gokushovirinae environmental samples]	diamond	6018	343	0.997084548104956	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Gokushovirinae environmental samples
28636904	28636904	PRJNA976345_P_NODE_137367_length_172_cov_1.437956_g135759_i0	PRJNA976345	137367	172	1.437956	2.47328432	Microvirus sp.	2202559	Viruses	Viruses	43.9	0.00566	NR	QXN72827.1	2202559	g135759	i0	48.6	1.55232558139535	37	17	64.5	1	25	135	104	138	QXN72827.1 MAG: major capsid protein [Microvirus sp.]	diamond	267	43.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
28769122	28769122	PRJNA976345_P_NODE_142807_length_169_cov_2.402985_g141199_i0	PRJNA976345	142807	169	2.402985	4.06104465	Viruses	10239	Viruses	Viruses	73.6	3.07e-14	NR	QJB20568.1	2202559	g141199	i0	69.1	3.92307692307692	55	17	97.6	0	165	1	31	85	QJB20568.1 MAG: DNA pilot protein [Microvirus sp.]	diamond	663	73.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
32017504	32017504	PRJNA976345_P_NODE_6698_length_697_cov_3.442598_g5319_i0	PRJNA976345	6698	697	3.442598	23.99490806	Microviridae sp. ctjWc39	2656702	Viruses	Viruses	67	1.29e-10	NR	QGH72128.1	2656702	g5319	i0	35	1.45480631276901	80	52	34.4	0	407	646	1	80	QGH72128.1 MAG: DNA binding protein [Microviridae sp. ctjWc39]	diamond	1014	67	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp. ctjWc39
32781860	32781860	PRJNA976345_P_NODE_20640_length_371_cov_2.014881_g19041_i0	PRJNA976345	20640	371	2.014881	7.47520851	Viruses	10239	Viruses	Viruses	147	4.33e-39	NR	AVQ10203.1	1478972	g19041	i0	70.3	6.46900269541779	101	30	81.7	0	3	305	442	542	AVQ10203.1 putative major capsid protein [Gokushovirinae environmental samples]	diamond	2400	147	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Gokushovirinae environmental samples

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