metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA551951" 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_order	tax_family	tax_genus	tax_species
15823388	15823388	PRJNA551951_S_NODE_5353_length_380_cov_3.457971_g5235_i0	PRJNA551951	5353	380	3.457971	13.1402898	Gammaretrovirus	153135	Viruses	Viruses	204	4.57e-58	NR	ABU54795.1	11786	g5235	i0	96.1	8.04473684210526	102	4	80.5	0	67	372	657	758	ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus]	diamond	3057	206	0.990291262135922	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26966227	26966227	PRJNA551951_S_NODE_3502_length_493_cov_9.272926_g3389_i0	PRJNA551951	3502	493	9.272926	45.71552518	Gammaretrovirus	153135	Viruses	Viruses	299	2.47e-92	NR	AAA79247.1	11786	g3389	i0	99.3	10.5882352941176	145	1	88.2	0	41	475	219	363	AAA79247.1 putative reverse transcriptase [Murine leukemia virus]	diamond	5220	300	0.996666666666667	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28404675	28404675	PRJNA551951_S_NODE_13946_length_180_cov_3.000000_g13828_i0	PRJNA551951	13946	180	3	5.4	Caudoviricetes sp.	2832643	Viruses	Viruses	82.4	1.71e-16	NR	XOS60132.1	2832643	g13828	i0	73.6	0.883333333333333	53	14	88.3	0	19	177	702	754	XOS60132.1 MAG: hypothetical protein MSP0240_74 [Caudoviricetes sp.]	diamond	159	82.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28941687	28941687	PRJNA551951_S_NODE_5028_length_394_cov_8.122563_g4911_i0	PRJNA551951	5028	394	8.122563	32.00289822	Vibrio phage vB_VhaM_VH-8	2660693	Viruses	Viruses	144	5.109999999999999e-40	NR	QGH73806.1	2660693	g4911	i0	72	0.708121827411167	93	25	70.8	1	377	99	151	242	QGH73806.1 ribonucleotide reductase of class Ia alpha subunit [Vibrio phage vB_VhaM_VH-8]	diamond	279	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage vB_VhaM_VH-8
32513048	32513048	PRJNA551951_S_NODE_14399_length_176_cov_1.751773_g14281_i0	PRJNA551951	14399	176	1.751773	3.08312048	Caudoviricetes sp.	2832643	Viruses	Viruses	71.2	5.67e-13	NR	XOS60131.1	2832643	g14281	i0	79.5	0.75	44	9	75	0	133	2	1	44	XOS60131.1 MAG: hypothetical protein MSP0240_73 [Caudoviricetes sp.]	diamond	132	71.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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