metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA541476" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA541476" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5612273	5612273	PRJNA541476_P_NODE_15405_length_307_cov_1.085470_g15199_i0	PRJNA541476	15405	307	1.08547	3.3323929	uncultured virus	340016	Viruses	Viruses	181	1.77e-53	NR	CAH6419174.1	340016	g15199	i0	86.1	0.986970684039088	101	14	98.7	0	305	3	70	170	CAH6419174.1 S-adenosylmethionine synthetase [uncultured virus]	diamond	303	181	1	Viruses								uncultured virus
26666098	26666098	PRJNA541476_P_NODE_4761_length_522_cov_1.875278_g4561_i0	PRJNA541476	4761	522	1.875278	9.78895116	rice-associated noda-like virus 2	2966239	Viruses	Viruses	47.8	0.00844	NR	UTU02166.1	2966239	g4561	i0	32.4	0.620689655172414	108	57	56.9	4	471	175	278	378	UTU02166.1 capsid protein [rice-associated noda-like virus 2]	diamond	324	47.8	1	Viruses		Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		rice-associated noda-like virus 2
26666101	26666101	PRJNA541476_P_NODE_6421_length_445_cov_3.814516_g6218_i0	PRJNA541476	6421	445	3.814516	16.9745962	Sylvanvirus sp.	2487774	Viruses	Viruses	199	7.89e-63	NR	AYV86982.1	2487774	g6218	i0	75.9	2.73707865168539	133	30	89.7	1	401	3	6	136	AYV86982.1 MAG: nucleic acid-binding protein [Sylvanvirus sp.]	diamond	1218	199	1	Viruses								Sylvanvirus sp.
26824855	26824855	PRJNA541476_P_NODE_11141_length_346_cov_1.058608_g10935_i0	PRJNA541476	11141	346	1.058608	3.66278368	Terrestrivirus sp.	2487775	Viruses	Viruses	71.6	6.33e-12	NR	AYV75160.1	2487775	g10935	i0	38.2	0.771676300578035	89	48	73.7	2	291	37	91	176	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	267	71.6	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27235906	27235906	PRJNA541476_P_NODE_7923_length_401_cov_3.411585_g7719_i0	PRJNA541476	7923	401	3.411585	13.68045585	Micromonas pusilla virus 12T	755272	Viruses	Viruses	122	2.2e-29	NR	YP_007676312.1	755272	g7719	i0	51.5	2.96259351620948	132	55	98.8	1	3	398	203	325	YP_007676312.1 heat shock protein 70 [Micromonas pusilla virus 12T]	diamond	1188	122	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Micromonas pusilla virus 12T
27394136	27394136	PRJNA541476_P_NODE_7783_length_405_cov_2.548193_g7579_i0	PRJNA541476	7783	405	2.548193	10.32018165	rice-associated noda-like virus 2	2966239	Viruses	Viruses	99	1.91e-21	NR	UTU02166.1	2966239	g7579	i0	60.2	0.614814814814815	83	33	61.5	0	249	1	39	121	UTU02166.1 capsid protein [rice-associated noda-like virus 2]	diamond	249	99	1	Viruses		Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		rice-associated noda-like virus 2
27835869	27835869	PRJNA541476_P_NODE_6584_length_440_cov_2.784741_g6380_i0	PRJNA541476	6584	440	2.784741	12.2528604	Solumvirus sp.	2487773	Viruses	Viruses	181	8.339999999999997e-55	NR	AYV86227.1	2487773	g6380	i0	66.4	0.913636363636364	134	40	88	1	2	388	54	187	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	402	181	1	Viruses	Pithoviruses							Solumvirus sp.
28751601	28751601	PRJNA541476_P_NODE_20727_length_279_cov_1.495146_g20521_i0	PRJNA541476	20727	279	1.495146	4.17145734	Faunusvirus sp.	2487766	Viruses	Viruses	63.9	2.03e-9	NR	AYV79658.1	2487766	g20521	i0	51.4	0.752688172043011	70	30	72	3	77	277	476	544	AYV79658.1 MAG: putative helicase/exonuclease [Faunusvirus sp.]	diamond	210	63.9	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Faunusvirus sp.
30551653	30551653	PRJNA541476_P_NODE_21073_length_278_cov_0.892683_g20867_i0	PRJNA541476	21073	278	0.892683	2.48165874	Tupanvirus deep ocean	2126984	Viruses	Viruses	89.7	5.1e-19	NR	YP_010781083.1	2126984	g20867	i0	53.2	1.70503597122302	79	36	85.3	1	238	2	124	201	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	474	89.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
30994214	30994214	PRJNA541476_P_NODE_4194_length_560_cov_2.316222_g3998_i0	PRJNA541476	4194	560	2.316222	12.9708432	Edafosvirus sp.	2487765	Viruses	Viruses	55.1	3.85e-5	NR	AYV78965.1	2487765	g3998	i0	60.5	0.203571428571429	38	15	20.4	0	268	381	203	240	AYV78965.1 MAG: DEAD/SNF2-like helicase, partial [Edafosvirus sp.]	diamond	114	55.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31088906	31088906	PRJNA541476_P_NODE_41615_length_230_cov_2.063694_g41409_i0	PRJNA541476	41615	230	2.063694	4.7464962	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	73.2	3.64e-13	NR	VBB18459.1	2420051	g41409	i0	48.6	0.939130434782609	72	37	93.9	0	14	229	183	254	VBB18459.1 class I SAM-dependent methyltransferase [Yasminevirus sp. GU-2018]	diamond	216	73.2	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32227747	32227747	PRJNA541476_P_NODE_12978_length_326_cov_1.525692_g12772_i0	PRJNA541476	12978	326	1.525692	4.97375592	Sylvanvirus sp.	2487774	Viruses	Viruses	68.2	9.34e-11	NR	AYV86437.1	2487774	g12772	i0	46.3	0.616564417177914	67	36	61.7	0	277	77	234	300	AYV86437.1 MAG: hypothetical protein Sylvanvirus1_33 [Sylvanvirus sp.]	diamond	201	68.2	1	Viruses								Sylvanvirus sp.
32385799	32385799	PRJNA541476_P_NODE_11679_length_339_cov_2.966165_g11473_i0	PRJNA541476	11679	339	2.966165	10.05529935	Terrestrivirus sp.	2487775	Viruses	Viruses	48.5	0.00104	NR	AYV76628.1	2487775	g11473	i0	38.8	0.752212389380531	85	39	70.8	3	45	284	215	291	AYV76628.1 MAG: hypothetical protein Terrestrivirus10_12 [Terrestrivirus sp.]	diamond	255	48.5	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
32417554	32417554	PRJNA541476_P_NODE_5619_length_478_cov_2.293827_g5417_i0	PRJNA541476	5619	478	2.293827	10.96449306	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	77.8	2.95e-13	NR	YP_010803800.1	3060017	g5417	i0	58.6	0.728033472803347	58	24	36.4	0	237	64	1048	1105	YP_010803800.1 helicase/uvrB [Fadolivirus algeromassiliense]	diamond	348	77.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
32858943	32858943	PRJNA541476_P_NODE_27740_length_254_cov_1.425414_g27534_i0	PRJNA541476	27740	254	1.425414	3.62055156	rice-associated noda-like virus 2	2966239	Viruses	Viruses	90.1	5.16e-19	NR	UTU02166.1	2966239	g27534	i0	61.3	0.885826771653543	75	28	87.4	1	254	33	189	263	UTU02166.1 capsid protein [rice-associated noda-like virus 2]	diamond	225	90.1	1	Viruses		Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		rice-associated noda-like virus 2

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