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

5 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_kingdom = "Orthornavirae"

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
28114312	28114312	PRJNA1174234_P_NODE_35685_length_241_cov_0.916667_g35489_i0	PRJNA1174234	35685	241	0.916667	2.20916747	Diaporthe gulyae mitovirus 3	3077427	Viruses	Viruses	48.5	3.24e-4	NR	WNM95031.1	3077427	g35489	i0	81.5	0.336099585062241	27	5	33.6	0	3	83	690	716	WNM95031.1 MAG: RNA-dependent RNA polymerase [Diaporthe gulyae mitovirus 3]	diamond	81	48.5	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Diaporthe gulyae mitovirus 3
28272119	28272119	PRJNA1174234_P_NODE_27646_length_259_cov_1.209677_g27450_i0	PRJNA1174234	27646	259	1.209677	3.13306343	Pegivirus scotophili	3052612	Viruses	Viruses	44.3	0.0137	NR	YP_009506366.1	3052612	g27450	i0	42.9	0.405405405405405	35	20	40.5	0	50	154	519	553	YP_009506366.1 polyprotein [Pegivirus scotophili]	diamond	105	44.3	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pegivirus	Pegivirus scotophili
30988560	30988560	PRJNA1174234_P_NODE_27774_length_258_cov_1.351351_g27578_i0	PRJNA1174234	27774	258	1.351351	3.48648558	Orius laevigatus tombus-like virus 1	3344938	Viruses	Viruses	47.8	7.45e-4	NR	XGU09131.1	3344938	g27578	i0	41	0.709302325581395	61	36	70.9	0	9	191	451	511	XGU09131.1 MAG: RdRp [Orius laevigatus tombus-like virus 1]	diamond	183	47.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Orius laevigatus tombus-like virus 1
31557727	31557727	PRJNA1174234_P_NODE_12936_length_383_cov_0.993548_g12740_i0	PRJNA1174234	12936	383	0.993548	3.80528884	Qianjiang noda-like virus 99	3348689	Viruses	Viruses	66.6	5.08e-10	NR	XHA86106.1	3348689	g12740	i0	34.1	0.986945169712794	126	76	97.9	3	7	381	143	262	XHA86106.1 MAG: hypothetical protein [Qianjiang noda-like virus 99]	diamond	378	66.6	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		Qianjiang noda-like virus 99
32285479	32285479	PRJNA1174234_P_NODE_1519_length_975_cov_1.506652_g1388_i0	PRJNA1174234	1519	975	1.506652	14.689857	Orius laevigatus tombus-like virus 1	3344938	Viruses	Viruses	145	6.46e-36	NR	XGU09133.1	3344938	g1388	i0	42.3	0.516923076923077	168	94	50.8	2	409	903	154	321	XGU09133.1 MAG: RdRp [Orius laevigatus tombus-like virus 1]	diamond	504	145	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Orius laevigatus tombus-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);;