metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB43370" 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
10262971	10262971	PRJEB43370_P_NODE_109_length_1201_cov_6.372396_g90_i0	PRJEB43370	109	1201	6.372396	76.53247596	Psittaciform aveparvovirus	3042447	Viruses	Viruses	587	5.51e-208	NR	XNT21000.1	3042447	g90	i0	71.9	1.92589508742714	384	106	95.9	1	17	1168	6	387	XNT21000.1 MAG: replication protein [Parvoviridae sp.]	diamond	2313	587	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform aveparvovirus
26589983	26589983	PRJEB43370_P_NODE_1_length_8785_cov_289.177656_g0_i0	PRJEB43370	1	8785	289.177656	25404.2570796	Beihai picorna-like virus 48	1922592	Viruses	Viruses	1821	0	NR	YP_009333545.1	1922592	g0	i0	41.3	0.888560045532157	2602	1364	85.4	46	7749	247	121	2660	YP_009333545.1 hypothetical protein [Beihai picorna-like virus 48]	diamond	7806	1821	1	Viruses							Beihai picorna-like virus 48
27665504	27665504	PRJEB43370_P_NODE_444_length_645_cov_1.570470_g404_i0	PRJEB43370	444	645	1.57047	10.1295315	Rhabdoviridae sp.	1955137	Viruses	Viruses	150	3.72e-41	NR	XKB76562.1	1955137	g404	i0	42.2	0.804651162790698	173	100	80.5	0	597	79	90	262	XKB76562.1 MAG: hypothetical protein [Rhabdoviridae sp.]	diamond	519	150	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Rhabdoviridae sp.
28075665	28075665	PRJEB43370_P_NODE_2825_length_258_cov_1.244019_g2782_i0	PRJEB43370	2825	258	1.244019	3.20956902	Rhabdoviridae sp.	1955137	Viruses	Viruses	96.7	4.91e-21	NR	XKB76565.1	1955137	g2782	i0	58	1.02325581395349	88	32	98.8	2	3	257	791	876	XKB76565.1 MAG: L protein [Rhabdoviridae sp.]	diamond	264	96.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Rhabdoviridae sp.
28732220	28732220	PRJEB43370_P_NODE_3067_length_248_cov_1.829146_g3024_i0	PRJEB43370	3067	248	1.829146	4.53628208	root	1	Root_unresolved	Root_unresolved	44.3	0.0107	NR	AVG47719.1	212035	g3024	i0	46.5	1.54838709677419	43	23	52	0	136	8	17	59	AVG47719.1 JMJC domain [Acanthamoeba polyphaga mimivirus]	diamond	384	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
29401876	29401876	PRJEB43370_P_NODE_3689_length_229_cov_1.155556_g3646_i0	PRJEB43370	3689	229	1.155556	2.64622324	Leviviridae sp.	2027243	Viruses	Viruses	85.1	3.2e-17	NR	UJQ85807.1	2027243	g3646	i0	52.1	0.930131004366812	71	34	93	0	215	3	36	106	UJQ85807.1 MAG: hypothetical protein 1 [Leviviridae sp.]	diamond	213	85.1	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
29654101	29654101	PRJEB43370_P_NODE_4190_length_217_cov_2.446429_g4147_i0	PRJEB43370	4190	217	2.446429	5.30875093	Terrestrivirus sp.	2487775	Viruses	Viruses	48.9	3.4e-5	NR	AYV76392.1	2487775	g4147	i0	54.3	0.63594470046083	46	20	63.6	1	191	54	1	45	AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.]	diamond	138	48.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
29970266	29970266	PRJEB43370_P_NODE_2491_length_274_cov_0.933333_g2448_i0	PRJEB43370	2491	274	0.933333	2.55733242	Durnavirales sp.	2809355	Viruses	Viruses	80.1	3.72e-15	NR	WRQ64726.1	2809355	g2448	i0	43.2	0.886861313868613	81	46	88.7	0	32	274	215	295	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	243	80.1	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
31993264	31993264	PRJEB43370_P_NODE_1458_length_361_cov_1.653846_g1415_i0	PRJEB43370	1458	361	1.653846	5.97038406	Rhabdoviridae sp.	1955137	Viruses	Viruses	68.6	1.25e-10	NR	XKB76561.1	1955137	g1415	i0	33.3	0.997229916897507	120	80	99.7	0	2	361	49	168	XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.]	diamond	360	68.6	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Rhabdoviridae sp.
32499784	32499784	PRJEB43370_P_NODE_4499_length_211_cov_1.283951_g4456_i0	PRJEB43370	4499	211	1.283951	2.70913661	Caudoviricetes sp.	2832643	Viruses	Viruses	74.3	1.12e-13	NR	DAK32950.1	2832643	g4456	i0	51.5	1.93364928909953	68	33	96.7	0	209	6	135	202	DAK32950.1 MAG TPA: virion structural protein [Caudoviricetes sp.]	diamond	408	74.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;