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

5 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
27181953	27181953	PRJNA896973_S_NODE_1522_length_311_cov_3.193277_g1508_i0	PRJNA896973	1522	311	3.193277	9.93109147	Ripoglor virus	3130730	Viruses	Viruses	47.8	0.00147	NR	WZH60210.1	3130730	g1508	i0	31.9	0.877813504823151	91	55	84.9	3	277	14	97	183	WZH60210.1 MAG: RNA-dependent RNA polymerase [Ripoglor virus]	diamond	273	47.8	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripoglor virus
27435189	27435189	PRJNA896973_P_NODE_28543_length_235_cov_5.580247_g28449_i0	PRJNA896973	28543	235	5.580247	13.11358045	Tolivirales sp.	2809914	Viruses	Viruses	75.1	1.31e-13	NR	WRQ65272.1	2809914	g28449	i0	66	0.676595744680851	53	18	67.7	0	212	54	978	1030	WRQ65272.1 polyprotein [Tolivirales sp.]	diamond	159	75.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp.
30877175	30877175	PRJNA896973_P_NODE_23754_length_248_cov_0.880000_g23660_i0	PRJNA896973	23754	248	0.88	2.1824	Erysiphales associated mitovirus 1	2719863	Viruses	Viruses	45.1	0.00609	NR	QIP68031.1	2719863	g23660	i0	47.7	0.532258064516129	44	23	53.2	0	248	117	698	741	QIP68031.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1]	diamond	132	45.1	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Erysiphales associated mitovirus 1
30877177	30877177	PRJNA896973_S_NODE_1974_length_280_cov_2.458937_g1960_i0	PRJNA896973	1974	280	2.458937	6.8850236	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	76.3	9.67e-14	NR	UNY42122.1	3003959	g1960	i0	65.4	0.557142857142857	52	17	54.6	1	279	127	425	476	UNY42122.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	156	76.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30908918	30908918	PRJNA896973_S_NODE_2294_length_263_cov_2.705263_g2280_i0	PRJNA896973	2294	263	2.705263	7.11484169	Qianjiang tombus-like virus 56	3348124	Viruses	Viruses	47	0.00143	NR	XHA86470.1	3348124	g2280	i0	45.5	0.627376425855513	55	30	62.7	0	46	210	275	329	XHA86470.1 MAG: hypothetical protein [Qianjiang tombus-like virus 56]	diamond	165	47	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Qianjiang tombus-like virus 56

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