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

5 rows where analysis = "diamond", bioproject = "PRJNA1134759" 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
26690486	26690486	PRJNA1134759_P_NODE_31241_length_301_cov_1.824561_g31065_i0	PRJNA1134759	31241	301	1.824561	5.49192861	brine shrimp arlivirus 9	2900384	Viruses	Viruses	178	4.059999999999999e-52	NR	UNI74140.1	2900384	g31065	i0	88	1.99335548172757	100	12	99.7	0	1	300	296	395	UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9]	diamond	600	178	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
27386610	27386610	PRJNA1134759_P_NODE_18483_length_374_cov_1.813953_g18307_i0	PRJNA1134759	18483	374	1.813953	6.78418422	Fusarium culmorum yue-like virus 1	3233859	Viruses	Viruses	68.6	1.53e-10	NR	XCO56027.1	3233859	g18307	i0	39.8	0.82620320855615	103	58	81	2	319	17	452	552	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	309	68.6	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Fusarium culmorum yue-like virus 1
29217938	29217938	PRJNA1134759_P_NODE_58669_length_227_cov_2.233766_g58493_i0	PRJNA1134759	58669	227	2.233766	5.07064882	brine shrimp arlivirus 9	2900384	Viruses	Viruses	70.9	1.98e-12	NR	UNI74143.1	2900384	g58493	i0	56	0.991189427312775	75	33	99.1	0	225	1	194	268	UNI74143.1 MAG: hypothetical protein [brine shrimp arlivirus 9]	diamond	225	70.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
29996402	29996402	PRJNA1134759_P_NODE_51171_length_249_cov_1.329545_g50995_i0	PRJNA1134759	51171	249	1.329545	3.31056705	Chuvivirus	2842604	Viruses	Viruses	96.3	4.47e-21	NR	WET19887.1	2842604	g50995	i0	61	1.97590361445783	82	32	98.8	0	248	3	261	342	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	492	96.3	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
31587502	31587502	PRJNA1134759_P_NODE_36576_length_283_cov_1.485714_g36400_i0	PRJNA1134759	36576	283	1.485714	4.20457062	brine shrimp arlivirus 9	2900384	Viruses	Viruses	164	2.24e-50	NR	UNI74142.1	2900384	g36400	i0	84.9	0.985865724381625	93	14	98.6	0	1	279	23	115	UNI74142.1 MAG: hypothetical protein [brine shrimp arlivirus 9]	diamond	279	164	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9

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