metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA610520" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA610520" 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_genus	tax_species
27901197	27901197	PRJNA610520_S_NODE_56745_length_259_cov_1.241935_g56655_i0	PRJNA610520	56745	259	1.241935	3.21661165	Pandoravirus celtis	2568002	Viruses	Viruses	68.2	4.69e-11	NR	QBZ80797.1	2568002	g56655	i0	59.3	0.683397683397683	59	23	67.2	1	42	215	381	439	QBZ80797.1 hypothetical protein pclt_cds_199 [Pandoravirus celtis]	diamond	177	68.2	1	Viruses	Pandoravirus	Pandoravirus celtis
28451449	28451449	PRJNA610520_S_NODE_50646_length_271_cov_1.348485_g50556_i0	PRJNA610520	50646	271	1.348485	3.65439435	Pandoravirus	2060084	Viruses	Viruses	53.9	2.35e-6	NR	YP_008438385.1	1349410	g50556	i0	57.7	3.05535055350553	52	21	57.6	1	158	3	22	72	YP_008438385.1 hypothetical protein psal_cds_1092 [Pandoravirus salinus]	diamond	828	53.9	1	Viruses	Pandoravirus	Pandoravirus salinus
31041425	31041425	PRJNA610520_S_NODE_27135_length_332_cov_2.625483_g27045_i0	PRJNA610520	27135	332	2.625483	8.71660356	Pandoravirus	2060084	Viruses	Viruses	55.8	2.55e-6	NR	YP_008319683.2	1349409	g27045	i0	48.6	2.68373493975904	72	36	64.2	1	110	322	110	181	YP_008319683.2 Ankyrin repeat domain containing protein [Pandoravirus dulcis]	diamond	891	56.2	0.99288256227758	Viruses	Pandoravirus	Pandoravirus dulcis
32433054	32433054	PRJNA610520_S_NODE_70499_length_235_cov_2.080247_g70409_i0	PRJNA610520	70499	235	2.080247	4.88858045	Pandoravirus	2060084	Viruses	Viruses	47	4.3e-4	NR	YP_009481478.1	2107707	g70409	i0	42.9	1.28936170212766	56	30	68.9	1	211	50	89	144	YP_009481478.1 hypothetical protein pmac_cds_794 [Pandoravirus macleodensis]	diamond	303	47	1	Viruses	Pandoravirus	Pandoravirus macleodensis

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