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

4 rows where analysis = "diamond", bioproject = "PRJNA416866" 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
27739328	27739328	PRJNA416866_P_NODE_4124_length_325_cov_1.215909_g3981_i0	PRJNA416866	4124	325	1.215909	3.95170425	Caudoviricetes sp.	2832643	Viruses	Viruses	108	8.630000000000001e-27	NR	DAY69239.1	2832643	g3981	i0	55.4	1.80923076923077	101	44	92.3	1	302	3	119	219	DAY69239.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	588	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30392019	30392019	PRJNA416866_P_NODE_9333_length_210_cov_1.543624_g9189_i0	PRJNA416866	9333	210	1.543624	3.2416104	Moss partitivirus 7	3067240	Viruses	Viruses	94.7	1.1e-20	NR	WPR17416.1	3067240	g9189	i0	58	0.985714285714286	69	29	98.6	0	3	209	293	361	WPR17416.1 MAG: RNA-dependent RNA polymerase, partial [Moss partitivirus 7]	diamond	207	94.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Moss partitivirus 7
31055348	31055348	PRJNA416866_P_NODE_7995_length_228_cov_1.532934_g7851_i0	PRJNA416866	7995	228	1.532934	3.49508952	Tupanvirus deep ocean	2126984	Viruses	Viruses	56.2	5e-7	NR	YP_010781083.1	2126984	g7851	i0	38.7	0.986842105263158	75	38	98.7	1	225	1	94	160	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	225	56.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
31466250	31466250	PRJNA416866_P_NODE_5076_length_291_cov_1.113043_g4932_i0	PRJNA416866	5076	291	1.113043	3.23895513	Klosneuvirus KNV1	1977640	Viruses	Viruses	59.3	9.31e-8	NR	ARF12104.1	1977640	g4932	i0	40.3	0.742268041237113	72	35	71.1	3	284	78	11	77	ARF12104.1 serpin [Klosneuvirus KNV1]	diamond	216	59.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1

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