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

11 rows where analysis = "diamond", bioproject = "PRJNA393181" 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_family	tax_genus	tax_species
28085914	28085914	PRJNA393181_S_NODE_3705_length_572_cov_2.809346_g3610_i0	PRJNA393181	3705	572	2.809346	16.06945912	Caudoviricetes sp.	2832643	Viruses	Viruses	214	4.83e-62	NR	XOF03585.1	2832643	g3610	i0	56.3	2.02447552447552	190	80	99.7	1	571	2	287	473	XOF03585.1 MAG: portal protein [Caudoviricetes sp.]	diamond	1158	214	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28212029	28212029	PRJNA393181_S_NODE_10486_length_373_cov_2.068452_g10380_i0	PRJNA393181	10486	373	2.068452	7.71532596	Caudoviricetes sp.	2832643	Viruses	Viruses	145	1.4299999999999998e-37	NR	XOF03585.1	2832643	g10380	i0	53.7	0.989276139410188	123	57	98.9	0	371	3	39	161	XOF03585.1 MAG: portal protein [Caudoviricetes sp.]	diamond	369	145	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29159734	29159734	PRJNA393181_S_NODE_34589_length_186_cov_2.617450_g34483_i0	PRJNA393181	34589	186	2.61745	4.868457	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	46.6	6.55e-4	NR	QDP58365.1	2591644	g34483	i0	41.4	0.935483870967742	58	34	93.5	0	184	11	77	134	QDP58365.1 MAG: hypothetical protein Unbinned664contig1000_46 [Prokaryotic dsDNA virus sp.]	diamond	174	46.6	1	Viruses						Prokaryotic dsDNA virus sp.
29443465	29443465	PRJNA393181_S_NODE_46250_length_153_cov_2.775862_g46144_i0	PRJNA393181	46250	153	2.775862	4.24706886	uncultured Caudovirales phage	2100421	Viruses	Viruses	67.8	1.63e-11	NR	CAB4128237.1	2100421	g46144	i0	56.9	2	51	22	100	0	153	1	403	453	CAB4128237.1 hypothetical protein UFOVP99_20 [uncultured Caudovirales phage]	diamond	306	67.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
30075165	30075165	PRJNA393181_S_NODE_30252_length_203_cov_3.831325_g30146_i0	PRJNA393181	30252	203	3.831325	7.77758975	Caudoviricetes sp.	2832643	Viruses	Viruses	82	2.08e-16	NR	XOF03572.1	2832643	g30146	i0	60.9	0.945812807881773	64	25	94.6	0	193	2	44	107	XOF03572.1 MAG: major head protein [Caudoviricetes sp.]	diamond	192	82	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30233298	30233298	PRJNA393181_S_NODE_44592_length_157_cov_1.950000_g44486_i0	PRJNA393181	44592	157	1.95	3.0615	Caudoviricetes sp.	2832643	Viruses	Viruses	84	9.76e-18	NR	XOS64099.1	2832643	g44486	i0	76.9	0.993630573248408	52	12	99.4	0	1	156	25	76	XOS64099.1 MAG: hypothetical protein MSP0612_65 [Caudoviricetes sp.]	diamond	156	84	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30707147	30707147	PRJNA393181_S_NODE_36714_length_179_cov_2.197183_g36608_i0	PRJNA393181	36714	179	2.197183	3.93295757	uncultured Caudovirales phage	2100421	Viruses	Viruses	80.5	7.64e-16	NR	CAB4160552.1	2100421	g36608	i0	62.5	4.13966480446927	64	19	98.9	1	2	178	248	311	CAB4160552.1 Head-to-tail connector protein, podovirus-type [uncultured Caudovirales phage]	diamond	741	80.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
30896985	30896985	PRJNA393181_S_NODE_43454_length_160_cov_1.585366_g43348_i0	PRJNA393181	43454	160	1.585366	2.5365856	Medusavirus sp. 'euryale'	3349365	Viruses	Viruses	66.2	2.38e-11	NR	BFT93230.1	3349365	g43348	i0	64.6	0.9	48	17	90	0	149	6	18	65	BFT93230.1 Endonuclease V [Medusavirus sp. 'euryale']	diamond	144	66.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Mamonoviridae	Medusavirus	Medusavirus sp. 'euryale'
31434054	31434054	PRJNA393181_S_NODE_16616_length_293_cov_3.031250_g16510_i0	PRJNA393181	16616	293	3.03125	8.8815625	Acetobacter phage phiAX1	2860314	Viruses	Viruses	61.2	5.31e-9	NR	BCZ75895.1	2860314	g16510	i0	51	0.522184300341297	51	25	52.2	0	271	119	134	184	BCZ75895.1 hypothetical protein [Acetobacter phage phiAX1]	diamond	153	61.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Acetobacter phage phiAX1
31655367	31655367	PRJNA393181_S_NODE_29477_length_207_cov_2.523529_g29371_i0	PRJNA393181	29477	207	2.523529	5.22370503	Caudoviricetes sp.	2832643	Viruses	Viruses	84	4.29e-17	NR	XOF03572.1	2832643	g29371	i0	64.5	1.88405797101449	62	22	89.9	0	205	20	99	160	XOF03572.1 MAG: major head protein [Caudoviricetes sp.]	diamond	390	84	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
32856342	32856342	PRJNA393181_S_NODE_9560_length_390_cov_2.405099_g9454_i0	PRJNA393181	9560	390	2.405099	9.3798861	uncultured Caudovirales phage	2100421	Viruses	Viruses	122	1.79e-30	NR	CAB4144136.1	2100421	g9454	i0	48.7	0.915384615384615	119	61	91.5	0	1	357	247	365	CAB4144136.1 hypothetical protein UFOVP469_14 [uncultured Caudovirales phage]	diamond	357	122	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch

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