metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA758398" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA758398" 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
7118497	7118497	PRJNA758398_S_NODE_26_length_3593_cov_12.807280_g7_i0	PRJNA758398	26	3593	12.80728	460.1655704	Bundaberg bee virus 1	2201284	Viruses	Viruses	1149	0	NR	AWK77855.1	2201284	g7	i0	80.7	0.585304759254105	701	133	58.4	2	1184	3283	1	700	AWK77855.1 structural polyprotein [Bundaberg bee virus 1]	diamond	2103	1149	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Bundaberg bee virus 1
27210891	27210891	PRJNA758398_S_NODE_3522_length_504_cov_5.509890_g3381_i0	PRJNA758398	3522	504	5.50989	27.7698456	Sanya ochthera mantis Solinvi-like virus 1	2905562	Viruses	Viruses	49.3	0.0028	NR	UHM27575.1	2905562	g3381	i0	28.7	0.601190476190476	101	67	57.7	3	383	93	953	1052	UHM27575.1 MAG: RNA-dependent RNA polymerase [Sanya ochthera mantis Solinvi-like virus 1]	diamond	303	49.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Solinviviridae		Sanya ochthera mantis Solinvi-like virus 1
30653222	30653222	PRJNA758398_S_NODE_9813_length_309_cov_1.446154_g9672_i0	PRJNA758398	9813	309	1.446154	4.46861586	Sanya fiers-like virus 49	2970057	Viruses	Viruses	77.4	1.37e-15	NR	UUW21408.1	2970057	g9672	i0	56.5	0.669902912621359	69	30	67	0	1	207	64	132	UUW21408.1 MAG: hypothetical protein [Sanya fiers-like virus 49]	diamond	207	77.4	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Sambuevirus	Sambuevirus dinebrivicinum
32613834	32613834	PRJNA758398_S_NODE_16340_length_246_cov_4.284264_g16199_i0	PRJNA758398	16340	246	4.284264	10.53928944	African cichlid piscichuvirus	3065075	Viruses	Viruses	49.7	1.46e-4	NR	YP_010840939.1	3065075	g16199	i0	45.8	0.719512195121951	59	31	70.7	1	1	174	21	79	YP_010840939.1 L protein [Hardyhead chuvirus]	diamond	177	49.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus

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