metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA453567" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA453567" 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
27282049	27282049	PRJNA453567_P_NODE_11703_length_271_cov_3.064103_g11466_i0	PRJNA453567	11703	271	3.064103	8.30371913	root	1	Root_unresolved	Root_unresolved	82.4	2.02e-16	NR	AYV76653.1	2487775	g11466	i0	45.8	3.66420664206642	83	45	91.9	0	269	21	42	124	AYV76653.1 MAG: beta-lactamase superfamily domain [Terrestrivirus sp.]	diamond	993	82.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27486928	27486928	PRJNA453567_P_NODE_26963_length_169_cov_1.151515_g26726_i0	PRJNA453567	26963	169	1.151515	1.94606035	Terrestrivirus sp.	2487775	Viruses	Viruses	48.9	1.9e-5	NR	AYV76392.1	2487775	g26726	i0	54.3	0.816568047337278	46	20	81.7	1	139	2	1	45	AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.]	diamond	138	48.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27645013	27645013	PRJNA453567_P_NODE_924_length_1213_cov_4.036565_g847_i0	PRJNA453567	924	1213	4.036565	48.96353345	Pacmanvirus A23	1932881	Viruses	Viruses	87.8	1.47e-15	NR	YP_009361487.1	1932881	g847	i0	29	0.546578730420445	221	145	53.4	5	94	741	10	223	YP_009361487.1 Peptide chain release factor eRF/aRF, subunit 1, partial [Pacmanvirus A23]	diamond	663	87.8	1	Viruses							Pacmanvirus A23
27724517	27724517	PRJNA453567_P_NODE_3164_length_615_cov_1.737024_g2951_i0	PRJNA453567	3164	615	1.737024	10.6826976	root	1	Root_unresolved	Root_unresolved	50.8	0.00162	NR	AEX62528.1	1128131	g2951	i0	35.2	2.33170731707317	71	46	34.6	0	137	349	763	833	AEX62528.1 putative helicase [Moumouvirus Monve]	diamond	1434	51.2	0.9921875	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
29129013	29129013	PRJNA453567_P_NODE_9169_length_315_cov_2.309353_g8932_i0	PRJNA453567	9169	315	2.309353	7.27446195	Terrestrivirus sp.	2487775	Viruses	Viruses	44.3	0.0248	NR	AYV75294.1	2487775	g8932	i0	38.5	0.495238095238095	52	32	49.5	0	158	3	7	58	AYV75294.1 MAG: hypothetical protein Terrestrivirus1_168 [Terrestrivirus sp.]	diamond	156	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
29823178	29823178	PRJNA453567_P_NODE_7191_length_367_cov_1.181818_g6954_i0	PRJNA453567	7191	367	1.181818	4.33727206	Chlorovirus sp.	2809302	Viruses	Viruses	106	8.15e-24	NR	XOK35624.1	2809302	g6954	i0	47.1	1.7983651226158	102	54	83.4	0	340	35	90	191	XOK35624.1 Oxidoreductase [Chlorovirus sp.]	diamond	660	106	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
30360940	30360940	PRJNA453567_P_NODE_13332_length_251_cov_2.532710_g13095_i0	PRJNA453567	13332	251	2.53271	6.3571021	uncultured virus	340016	Viruses	Viruses	48.1	4.59e-4	NR	CAH6420706.1	340016	g13095	i0	35.7	0.669322709163347	56	36	66.9	0	226	59	219	274	CAH6420706.1 Hypothetical protein HVR_LOCUS1261 [uncultured virus]	diamond	168	48.1	1	Viruses							uncultured virus
31055902	31055902	PRJNA453567_P_NODE_1875_length_846_cov_5.582200_g1726_i0	PRJNA453567	1875	846	5.5822	47.225412	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	147	5.3599999999999995e-37	NR	VBB18869.1	2420051	g1726	i0	37.4	0.861702127659574	243	113	85.8	5	112	837	82	286	VBB18869.1 hypothetical protein YASMINEVIRUS_1401 [Yasminevirus sp. GU-2018]	diamond	729	147	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
31782740	31782740	PRJNA453567_P_NODE_937_length_1207_cov_4.258120_g847_i1	PRJNA453567	937	1207	4.25812	51.3955084	Pacmanvirus A23	1932881	Viruses	Viruses	87.8	1.44e-15	NR	YP_009361487.1	1932881	g847	i1	29	0.549295774647887	221	145	53.7	5	275	922	10	223	YP_009361487.1 Peptide chain release factor eRF/aRF, subunit 1, partial [Pacmanvirus A23]	diamond	663	87.8	1	Viruses							Pacmanvirus A23
32510941	32510941	PRJNA453567_P_NODE_33799_length_151_cov_1.026316_g33562_i0	PRJNA453567	33799	151	1.026316	1.54973716	uncultured Caudovirales phage	2100421	Viruses	Viruses	84.3	2.65e-18	NR	CAB5214411.1	2100421	g33562	i0	68	1.94701986754967	50	16	99.3	0	2	151	63	112	CAB5214411.1 hypothetical protein UFOVP190_104 [uncultured Caudovirales phage]	diamond	294	84.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32794007	32794007	PRJNA453567_P_NODE_14200_length_241_cov_1.897059_g13963_i0	PRJNA453567	14200	241	1.897059	4.57191219	TTV-like mini virus	93678	Viruses	Viruses	42.7	0.0368	NR	UGV35367.1	93678	g13963	i0	41.3	0.784232365145228	63	32	78.4	2	40	228	7	64	UGV35367.1 MAG: ORF1 [TTV-like mini virus]	diamond	189	42.7	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus

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