metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1186363" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1186363" 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
27767508	27767508	PRJNA1186363_P_NODE_4_length_5539_cov_6.688621_g3_i0	PRJNA1186363	4	5539	6.688621	370.48271719	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	2370	0	NR	WWZ85593.1	3132542	g3	i0	64.5	0.997653005957754	1842	551	94.9	19	2	5260	1154	2981	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	5526	2370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
27893446	27893446	PRJNA1186363_P_NODE_305_length_2352_cov_2.802984_g235_i0	PRJNA1186363	305	2352	2.802984	65.92618368	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	884	7.320000000000001e-289	NR	WWZ85593.1	3132542	g235	i0	56.6	1.02040816326531	800	322	99.9	6	2	2350	330	1121	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	2400	884	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
28240676	28240676	PRJNA1186363_P_NODE_30586_length_312_cov_0.828452_g29698_i0	PRJNA1186363	30586	312	0.828452	2.58477024	Tupanvirus soda lake	2126985	Viruses	Viruses	91.7	5.4e-19	NR	YP_010782554.1	2126985	g29698	i0	55.3	1.46153846153846	76	32	73.1	1	303	76	100	173	YP_010782554.1 ubiquitin-conjugating enzyme [Tupanvirus soda lake]	diamond	456	91.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
29819360	29819360	PRJNA1186363_P_NODE_26291_length_350_cov_1.971119_g25403_i0	PRJNA1186363	26291	350	1.971119	6.8989165	Moumouvirus lavasanguinem	3138182	Viruses	Viruses	43.1	0.0123	NR	BFL60918.1	3138182	g25403	i0	43.1	0.437142857142857	51	29	43.7	0	265	113	5	55	BFL60918.1 hypothetical protein MoumouF8_00015 [Moumouvirus lavasanguinem]	diamond	153	43.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'lavasanguinem'
30672503	30672503	PRJNA1186363_P_NODE_42413_length_245_cov_0.906977_g41525_i0	PRJNA1186363	42413	245	0.906977	2.22209365	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	43.5	0.0197	NR	YP_010803851.1	3060017	g41525	i0	42	0.612244897959184	50	28	60	1	213	67	22	71	YP_010803851.1 R3H domain-containing protein [Fadolivirus algeromassiliense]	diamond	150	43.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31273010	31273010	PRJNA1186363_P_NODE_2335_length_1302_cov_3.008137_g1938_i0	PRJNA1186363	2335	1302	3.008137	39.16594374	Pandoravirus massiliensis	2060085	Viruses	Viruses	183	6.01e-48	NR	UDO47403.1	2060085	g1938	i0	31.4	2.06221198156682	452	244	91	12	17	1201	59	501	UDO47403.1 hypothetical protein [Pandoravirus massiliensis]	diamond	2685	183	1	Viruses						Pandoravirus	Pandoravirus massiliensis
31778985	31778985	PRJNA1186363_P_NODE_37397_length_259_cov_1.258065_g36509_i0	PRJNA1186363	37397	259	1.258065	3.25838835	Clandestinovirus	2831644	Viruses	Viruses	98.2	4.39e-23	NR	QYA18369.1	2831644	g36509	i0	57.1	0.810810810810811	70	30	81.1	0	48	257	137	206	QYA18369.1 bifunctional linker histone H1/H5 [Clandestinovirus]	diamond	210	98.2	1	Viruses							Clandestinovirus
32127329	32127329	PRJNA1186363_P_NODE_6418_length_839_cov_1.593995_g5664_i0	PRJNA1186363	6418	839	1.593995	13.37361805	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	242	1.12e-68	NR	WWZ85593.1	3132542	g5664	i0	47.1	1.00119189511323	280	125	99.4	4	3	836	72	330	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	840	242	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4

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