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

5 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Negarnaviricota"

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
25791273	25791273	PRJEB20058_P_NODE_31131_length_752_cov_2.308249_g28639_i0	PRJEB20058	31131	752	2.308249	17.35803248	Sonemauk virus	3131582	Viruses	Viruses	144	2.98e-35	NR	WZH61623.1	3131582	g28639	i0	38.5	1.78723404255319	221	126	85.4	5	69	710	1069	1286	WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus]	diamond	1344	144	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Sonemauk virus
32928044	32928044	PRJEB20058_P_NODE_19417_length_942_cov_2.770715_g17366_i0	PRJEB20058	19417	942	2.770715	26.1001353	Plasmopara viticola lesion associated mycobunyavirales-like virus 1	2689124	Viruses	Viruses	147	1.7199999999999998e-35	NR	QGY72638.1	2689124	g17366	i0	34.3	0.993630573248408	312	185	93.6	8	2	883	615	924	QGY72638.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mycobunyavirales-like virus 1]	diamond	936	147	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Plasmopara viticola lesion associated mycobunyavirales-like virus 1
32962904	32962904	PRJEB20058_P_NODE_54810_length_567_cov_27.339921_g52065_i0	PRJEB20058	54810	567	27.339921	155.01735207	Rhizoctonia cerealis bunyavirus	3068840	Viruses	Viruses	56.6	6.96e-6	NR	WMI40170.1	3068840	g52065	i0	26.3	0.804232804232804	152	105	79.9	2	45	497	84	229	WMI40170.1 MAG: hypothetical protein [Rhizoctonia cerealis bunyavirus]	diamond	456	56.6	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Rhizoctonia cerealis bunyavirus
33013644	33013644	PRJEB20058_P_NODE_229780_length_232_cov_3.491228_g226955_i0	PRJEB20058	229780	232	3.491228	8.09964896	Sonemauk virus	3131582	Viruses	Viruses	75.9	7.14e-14	NR	WZH61623.1	3131582	g226955	i0	50.6	0.995689655172414	77	38	99.6	0	231	1	1150	1226	WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus]	diamond	231	75.9	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Sonemauk virus
33030920	33030920	PRJEB20058_P_NODE_30508_length_759_cov_30.325215_g28033_i0	PRJEB20058	30508	759	30.325215	230.16838185	African cichlid piscichuvirus	3065075	Viruses	Viruses	125	1.47e-28	NR	WLN26256.1	3065075	g28033	i0	44.1	0.573122529644269	145	81	57.3	0	736	302	90	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	435	125	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus

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