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

8 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Duplornaviricota"

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
27078895	27078895	PRJNA558770_P_NODE_201442_length_234_cov_3.728643_g199437_i0	PRJNA558770	201442	234	3.728643	8.72502462	Totiviridae sp.	1955172	Viruses	Viruses	47	0.00105	NR	WAK77569.1	1955172	g199437	i0	86.4	0.282051282051282	22	3	28.2	0	167	232	539	560	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	66	47	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
28026531	28026531	PRJNA558770_P_NODE_133405_length_234_cov_7.788945_g131400_i0	PRJNA558770	133405	234	7.788945	18.2261313	Botrytis cinerea botybirnavirus 2	2735874	Viruses	Viruses	45.8	0.00286	NR	QJT73738.1	2735874	g131400	i0	35.1	0.987179487179487	77	48	98.7	1	4	234	672	746	QJT73738.1 hypothetical protein [Botrytis cinerea botybirnavirus 2]	diamond	231	45.8	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Botybirnaviridae	Botybirnavirus	Botybirnavirus kyu
29037042	29037042	PRJNA558770_P_NODE_170108_length_234_cov_5.160804_g168103_i0	PRJNA558770	170108	234	5.160804	12.07628136	Fusarium oxysporum chrysovirus 1	434898	Viruses	Viruses	45.8	0.00206	NR	YP_009665201.1	434898	g168103	i0	35.1	0.987179487179487	77	31	98.7	1	2	232	6	63	YP_009665201.1 coat protein, partial [Fusarium oxysporum chrysovirus 1]	diamond	231	45.8	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus fusarii
30868705	30868705	PRJNA558770_P_NODE_239154_length_234_cov_2.562814_g237149_i0	PRJNA558770	239154	234	2.562814	5.99698476	Penicillium roseopurpureum chrysovirus 1	2485919	Viruses	Viruses	68.6	2.74e-11	NR	AYP71814.1	2485919	g237149	i0	49.4	0.987179487179487	77	36	98.7	1	4	234	304	377	AYP71814.1 hypothetical protein [Penicillium roseopurpureum chrysovirus 1]	diamond	231	68.6	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus penicillii
31374612	31374612	PRJNA558770_P_NODE_119976_length_234_cov_9.211055_g117971_i0	PRJNA558770	119976	234	9.211055	21.5538687	Malassezia restricta associated totivirus 1	3048757	Viruses	Viruses	48.1	4.26e-4	NR	CAI9858976.1	3048757	g117971	i0	83.3	0.307692307692308	24	4	30.8	0	75	4	242	265	CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1]	diamond	72	48.1	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 1
32274536	32274536	PRJNA558770_P_NODE_162998_length_234_cov_5.572864_g160993_i0	PRJNA558770	162998	234	5.572864	13.04050176	Ghabrivirales	2732540	Viruses	Viruses	49.3	1.6e-4	NR	AOX47598.1	1905690	g160993	i0	31.6	8.71794871794872	76	40	97.4	1	6	233	251	314	AOX47598.1 RNA-dependent RNA polymerase, partial [Pterostylis totivirus-like]	diamond	2040	49.3	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Pterostylis totivirus-like
32891342	32891342	PRJNA558770_P_NODE_208960_length_234_cov_3.452261_g206955_i0	PRJNA558770	208960	234	3.452261	8.07829074	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	48.1	4.09e-4	NR	CAI9858974.1	3048756	g206955	i0	84	0.320512820512821	25	4	32.1	0	2	76	647	671	CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1]	diamond	75	48.1	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
32891365	32891365	PRJNA558770_P_NODE_335840_length_233_cov_4.777778_g333835_i0	PRJNA558770	335840	233	4.777778	11.13222274	Malassezia restricta associated totivirus 1	3048757	Viruses	Viruses	53.9	3.74e-6	NR	CAI9858976.1	3048757	g333835	i0	100	0.296137339055794	23	0	29.6	0	3	71	375	397	CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1]	diamond	69	53.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 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);;