metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax_phylum = "Kitrinoviricota"

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_species
20887395	20887395	PRJNA509429_P_NODE_8797_length_491_cov_1.907895_g7996_i0	PRJNA509429	8797	491	1.907895	9.36776445	Forni cryoconite toluca-like virus 2	3367771	Viruses	Viruses	243	1.11e-75	NR	XHY08967.1	3367771	g7996	i0	74.2	3.70875763747454	151	39	92.3	0	37	489	191	341	XHY08967.1 MAG: structural protein [Forni cryoconite toluca-like virus 2]	diamond	1821	243	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes			Forni cryoconite toluca-like virus 2
27361857	27361857	PRJNA509429_P_NODE_26903_length_243_cov_4.144231_g26075_i0	PRJNA509429	26903	243	4.1442310000000004	10.07048133	Qianjiang tombus-like virus 245	3347919	Viruses	Viruses	57	3.05e-7	NR	XHA86978.1	3347919	g26075	i0	35.9	1.97530864197531	78	49	96.3	1	5	238	49	125	XHA86978.1 MAG: putative viral coat protein [Qianjiang tombus-like virus 245]	diamond	480	57	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Qianjiang tombus-like virus 245
28403591	28403591	PRJNA509429_P_NODE_10026_length_459_cov_1.948113_g9211_i0	PRJNA509429	10026	459	1.948113	8.94183867	Qianjiang tombus-like virus 183	3347850	Viruses	Viruses	152	5.26e-41	NR	XHA86823.1	3347850	g9211	i0	48.3	1.97385620915033	151	78	98.7	0	458	6	34	184	XHA86823.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 183]	diamond	906	152	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Qianjiang tombus-like virus 183
30108694	30108694	PRJNA509429_P_NODE_28132_length_236_cov_1.427861_g27304_i0	PRJNA509429	28132	236	1.427861	3.36975196	Forni cryoconite toluca-like virus 2	3367771	Viruses	Viruses	95.9	2.5000000000000002e-22	NR	XHY08966.1	3367771	g27304	i0	56.9	0.915254237288136	72	31	91.5	0	2	217	103	174	XHY08966.1 MAG: RNA-dependent RNA polymerase [Forni cryoconite toluca-like virus 2]	diamond	216	95.9	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes			Forni cryoconite toluca-like virus 2
30267049	30267049	PRJNA509429_P_NODE_42612_length_173_cov_1.159420_g41784_i0	PRJNA509429	42612	173	1.15942	2.0057966	Flumine tombus-like virus 62	2941452	Viruses	Viruses	83.2	6.84e-18	NR	UQB76388.1	2941452	g41784	i0	73.2	0.971098265895954	56	15	97.1	0	173	6	126	181	UQB76388.1 RNA polymerase, partial [Flumine tombus-like virus 62]	diamond	168	83.2	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Flumine tombus-like virus 62
30425143	30425143	PRJNA509429_P_NODE_44553_length_167_cov_2.075758_g43725_i0	PRJNA509429	44553	167	2.075758	3.46651586	Tolivirales sp.	2809914	Viruses	Viruses	95.1	2.5500000000000004e-21	NR	WRQ65695.1	2809914	g43725	i0	79.6	0.970059880239521	54	11	97	0	164	3	79	132	WRQ65695.1 structural protein [Tolivirales sp.]	diamond	162	95.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales		Tolivirales sp.
30645661	30645661	PRJNA509429_P_NODE_40813_length_178_cov_2.181818_g39985_i0	PRJNA509429	40813	178	2.181818	3.88363604	Qianjiang tombus-like virus 17	3347835	Viruses	Viruses	48.1	1.87e-4	NR	XHA86791.1	3347836	g39985	i0	43.9	0.960674157303371	57	32	96.1	0	176	6	299	355	XHA86791.1 MAG: putative viral coat protein [Qianjiang tombus-like virus 170]	diamond	171	48.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Qianjiang tombus-like virus 170
32052428	32052428	PRJNA509429_P_NODE_24018_length_265_cov_1.713043_g23190_i0	PRJNA509429	24018	265	1.713043	4.53956395	Viruses	10239	Viruses	Viruses	123	6.43e-32	NR	QRI44283.1	2583950	g23190	i0	64.8	5.97735849056604	88	31	99.6	0	1	264	194	281	QRI44283.1 MAG: hypothetical protein, partial [Tombusviridae sp.]	diamond	1584	123	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Tombusviridae sp.
32763760	32763760	PRJNA509429_P_NODE_34040_length_204_cov_1.893491_g33212_i0	PRJNA509429	34040	204	1.893491	3.86272164	Forni cryoconite toluca-like virus 2	3367771	Viruses	Viruses	52.8	4.25e-6	NR	XHY08966.1	3367771	g33212	i0	50	1.57352941176471	56	28	82.4	0	2	169	168	223	XHY08966.1 MAG: RNA-dependent RNA polymerase [Forni cryoconite toluca-like virus 2]	diamond	321	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes			Forni cryoconite toluca-like virus 2
32826820	32826820	PRJNA509429_P_NODE_46480_length_162_cov_1.771654_g45652_i0	PRJNA509429	46480	162	1.771654	2.87007948	Forni cryoconite toluca-like virus 1	3367770	Viruses	Viruses	48.1	1.58e-4	NR	XHY08965.1	3367770	g45652	i0	48.1	1	54	19	100	1	1	162	35	79	XHY08965.1 MAG: structural protein [Forni cryoconite toluca-like virus 1]	diamond	162	48.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes			Forni cryoconite toluca-like virus 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);;