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

6 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_phylum = "Lenarviricota"

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
26726267	26726267	PRJNA356682_P_NODE_40701_length_245_cov_2.255814_g40010_i0	PRJNA356682	40701	245	2.255814	5.5267443	Sonabek virus	3131524	Viruses	Viruses	48.9	1.2e-4	NR	WZH61556.1	3131524	g40010	i0	74.4	0.477551020408163	39	10	47.8	0	131	15	41	79	WZH61556.1 MAG: hypothetical protein [Sonabek virus]	diamond	117	48.9	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Sonabek virus
27454265	27454265	PRJNA356682_P_NODE_18203_length_336_cov_1.543726_g17512_i0	PRJNA356682	18203	336	1.543726	5.18691936	ssRNA phage SRR5467	2845702	Viruses	Viruses	50.4	1.98e-4	NR	YP_010770102.1	2786474	g17512	i0	35.2	0.633928571428571	71	46	63.4	0	2	214	321	391	YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9]	diamond	213	50.4	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Solspiviridae	Oekfovirus	Oekfovirus sp. 'lutivicinum'
28180058	28180058	PRJNA356682_P_NODE_43806_length_242_cov_0.911243_g43115_i0	PRJNA356682	43806	242	0.911243	2.20520806	ssRNA phage ESE	3430437	Viruses	Viruses	138	3.3e-36	NR	YP_010769154.1	2786005	g43115	i0	78.8	0.991735537190083	80	17	99.2	0	242	3	442	521	YP_010769154.1 RNA-directed RNA polymerase [ssRNA phage ESE029]	diamond	240	138	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Lohngkovirus	Lohngkovirus defluviicola
31686630	31686630	PRJNA356682_P_NODE_8877_length_469_cov_3.174242_g8188_i0	PRJNA356682	8877	469	3.174242	14.88719498	Qianjiang levi-like virus 15	3348422	Viruses	Viruses	49.7	0.00126	NR	XHA87311.1	3348422	g8188	i0	40	0.479744136460554	75	39	44.8	2	108	317	1	74	XHA87311.1 MAG: putative phage maturation protein [Qianjiang levi-like virus 15]	diamond	225	49.7	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Qianjiang levi-like virus 15
31876367	31876367	PRJNA356682_P_NODE_10537_length_431_cov_1.656425_g9847_i0	PRJNA356682	10537	431	1.656425	7.13919175	ssRNA phage SRR5467	2845702	Viruses	Viruses	102	2.25e-22	NR	YP_010770102.1	2786474	g9847	i0	39.3	0.939675174013921	135	81	94	1	2	406	189	322	YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9]	diamond	405	102	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Solspiviridae	Oekfovirus	Oekfovirus sp. 'lutivicinum'
32792714	32792714	PRJNA356682_P_NODE_10000_length_442_cov_3.907859_g9310_i0	PRJNA356682	10000	442	3.907859	17.27273678	Leviviridae sp.	2027243	Viruses	Viruses	103	1.08e-22	NR	URG15324.1	2027243	g9310	i0	46.5	0.773755656108597	114	61	77.4	0	87	428	88	201	URG15324.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	342	103	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.

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