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

8 rows where analysis = "diamond", bioproject = "PRJDB3785" 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
27032338	27032338	PRJDB3785_S_NODE_27002_length_161_cov_1.339286_g26849_i0	PRJDB3785	27002	161	1.339286	2.15625046	Picornaviridae sp.	1530251	Viruses	Viruses	107	1.49e-25	NR	XDJ26655.1	1530251	g26849	i0	98.1	0.987577639751553	53	1	98.8	0	2	160	1679	1731	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	159	107	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27253584	27253584	PRJDB3785_S_NODE_22423_length_169_cov_1.275000_g22270_i0	PRJDB3785	22423	169	1.275	2.15475	Terrestrivirus sp.	2487775	Viruses	Viruses	82	2.24e-17	NR	AYV75266.1	2487775	g22270	i0	65.5	1.95266272189349	55	19	97.6	0	3	167	7	61	AYV75266.1 MAG: putative elongation factor 1-gamma-A-like [Terrestrivirus sp.]	diamond	330	82	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27790713	27790713	PRJDB3785_S_NODE_19124_length_181_cov_1.234848_g18971_i0	PRJDB3785	19124	181	1.234848	2.23507488	brine shrimp tymo-like virus 1	2900478	Viruses	Viruses	118	4.57e-29	NR	UNI73998.1	2900478	g18971	i0	96.7	0.994475138121547	60	2	99.4	0	181	2	1176	1235	UNI73998.1 MAG: RNA-dependent RNA polymerase [brine shrimp tymo-like virus 1]	diamond	180	118	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		brine shrimp tymo-like virus 1
28327210	28327210	PRJDB3785_S_NODE_26946_length_161_cov_1.366071_g26793_i0	PRJDB3785	26946	161	1.366071	2.19937431	Picornaviridae sp.	1530251	Viruses	Viruses	107	1.49e-25	NR	XDJ26655.1	1530251	g26793	i0	83	0.987577639751553	53	9	98.8	0	3	161	1319	1371	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	159	107	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29773721	29773721	PRJDB3785_S_NODE_22051_length_170_cov_1.652893_g21898_i0	PRJDB3785	22051	170	1.652893	2.8099181	Chuvivirus	2842604	Viruses	Viruses	88.2	1.2e-18	NR	WET19887.1	2842604	g21898	i0	73.2	1.97647058823529	56	15	98.8	0	3	170	312	367	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	336	88.6	0.99548532731377	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
29874553	29874553	PRJDB3785_S_NODE_11411_length_225_cov_2.312500_g11258_i0	PRJDB3785	11411	225	2.3125	5.203125	Terrestrivirus sp.	2487775	Viruses	Viruses	48.5	5.36e-5	NR	AYV76392.1	2487775	g11258	i0	56.5	0.613333333333333	46	19	61.3	1	8	145	1	45	AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.]	diamond	138	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31232919	31232919	PRJDB3785_S_NODE_24575_length_165_cov_0.879310_g24422_i0	PRJDB3785	24575	165	0.87931	1.4508615	Picornaviridae sp.	1530251	Viruses	Viruses	81.6	2.47e-16	NR	XDJ26655.1	1530251	g24422	i0	74.1	0.981818181818182	54	14	98.2	0	164	3	1763	1816	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	162	81.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
32813661	32813661	PRJDB3785_S_NODE_15700_length_197_cov_0.979730_g15547_i0	PRJDB3785	15700	197	0.97973	1.9300681	brine shrimp tymo-like virus 1	2900478	Viruses	Viruses	134	1.21e-34	NR	UNI73998.1	2900478	g15547	i0	100	0.989847715736041	65	0	99	0	196	2	244	308	UNI73998.1 MAG: RNA-dependent RNA polymerase [brine shrimp tymo-like virus 1]	diamond	195	134	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		brine shrimp tymo-like virus 1

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