metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
27019512	27019512	PRJNA700095_P_NODE_49602_length_254_cov_1.646409_g48338_i0	PRJNA700095	49602	254	1.646409	4.18187886	Hepacivirus hominis	3052230	Viruses	Viruses	44.3	0.0116	NR	BDG69781.1	3052230	g48338	i0	46.5	0.507874015748031	43	22	49.6	1	216	91	262	304	BDG69781.1 polyprotein, partial [Hepacivirus hominis]	diamond	129	44.3	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Hepacivirus	Hepacivirus hominis
27177373	27177373	PRJNA700095_P_NODE_62922_length_243_cov_0.894118_g61658_i0	PRJNA700095	62922	243	0.894118	2.17270674	Chrocalork virus	3129572	Viruses	Viruses	42.7	0.0335	NR	WZH58539.1	3129572	g61658	i0	38.4	0.901234567901235	73	44	88.9	1	216	1	167	239	WZH58539.1 MAG: maturation protein [Chrocalork virus]	diamond	219	42.7	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chrocalork virus
28282681	28282681	PRJNA700095_P_NODE_63546_length_242_cov_1.449704_g62282_i0	PRJNA700095	63546	242	1.449704	3.50828368	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	69.3	1.62e-11	NR	UVF58767.1	2951531	g62282	i0	45.6	0.979338842975207	79	42	96.7	1	234	1	1	79	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	237	69.3	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
29040898	29040898	PRJNA700095_P_NODE_1528_length_1471_cov_36.190272_g1069_i0	PRJNA700095	1528	1471	36.190272	532.35890112	Erysiphe necator associated sobemo-like virus 2	2743138	Viruses	Viruses	473	1.86e-161	NR	QKN22714.1	2743138	g1069	i0	53.1	0.79537729435758	390	183	79.5	0	1359	190	3	392	QKN22714.1 putative RNA-dependent RNA polymerase [Erysiphe necator associated sobemo-like virus 2]	diamond	1170	473	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Sobemovirus	Erysiphe necator associated sobemo-like virus 2
30082565	30082565	PRJNA700095_P_NODE_23532_length_356_cov_4.671378_g22268_i0	PRJNA700095	23532	356	4.671378	16.63010568	Vespa velutina associated permutotetra-like virus 1	2675464	Viruses	Viruses	82.8	1.05e-15	NR	QGL51735.1	2675464	g22268	i0	41.4	0.97752808988764	116	66	97.8	2	354	7	143	256	QGL51735.1 structural protein precursor [Vespa velutina associated permutotetra-like virus 1]	diamond	348	82.8	1	Viruses	Orthornavirae				Permutotetraviridae		Vespa velutina associated permutotetra-like virus 1
31599896	31599896	PRJNA700095_P_NODE_20756_length_386_cov_2.418530_g19493_i0	PRJNA700095	20756	386	2.41853	9.3355258	Grapevine umbra-like virus 4	3113825	Viruses	Viruses	174	2.9399999999999995e-48	NR	WRQ19770.1	3113825	g19493	i0	67.8	0.940414507772021	121	39	94	0	10	372	441	561	WRQ19770.1 MAG: RNA-dependent RNA polymerase [Grapevine umbra-like virus 4]	diamond	363	174	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Grapevine umbra-like virus 4

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