metadata: contig_metadata: 5 rows where bioproject = "PRJNA577226", tax_phylum = "Lenarviricota" and tax

5 rows where bioproject = "PRJNA577226", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

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_species
5665255	5665255	PRJNA577226_S_NODE_27965_length_236_cov_8.814070_g27026_i0	PRJNA577226	27965	236	8.81407	20.8012052	Chrocaburb virus	3129338	Viruses	Viruses	342	1.12e-89	NTclustered	gi\|2717317323\|gb\|PP171786.1\|	3129338	g27026	i0	92.797	26.0169491525424	236	17	100	0	1	236	314	79	MAG: Chrocaburb virus isolate CC1A_k141_16204 genomic sequence	blastn	6140	342	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Chrocaburb virus
6940061	6940061	PRJNA577226_S_NODE_40366_length_196_cov_1.283019_g39427_i0	PRJNA577226	40366	196	1.283019	2.51471724	Ripaglys virus	3130696	Viruses	Viruses	139	1.27e-28	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g39427	i0	85.926	44.1122448979592	135	14	68	5	59	191	2145	2276	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	8646	139	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Ripaglys virus
10765540	10765540	PRJNA577226_S_NODE_17569_length_305_cov_2.570896_g16630_i0	PRJNA577226	17569	305	2.570896	7.8412328	Sopawol virus	3131668	Viruses	Viruses	287	7.16e-73	NTclustered	gi\|2717323098\|gb\|PP173969.1\|	3131668	g16630	i0	84.026	189.931147540984	313	34	99	14	2	305	362	57	MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence	blastn	57929	287	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Sopawol virus
27205793	27205793	PRJNA577226_S_NODE_63442_length_158_cov_1.561983_g62503_i0	PRJNA577226	63442	158	1.561983	2.46793314	Botourmiaviridae sp.	2808997	Viruses	Viruses	68.9	6.68e-12	NR	UJQ92002.1	2808997	g62503	i0	56	0.949367088607595	50	22	94.9	0	155	6	446	495	UJQ92002.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	150	68.9	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Botourmiaviridae sp.
29795133	29795133	PRJNA577226_S_NODE_19411_length_289_cov_1.075397_g18472_i0	PRJNA577226	19411	289	1.075397	3.10789733	Botourmiaviridae sp.	2808997	Viruses	Viruses	144	1.0599999999999998e-37	NR	UJQ92002.1	2808997	g18472	i0	69.8	0.996539792387543	96	29	99.7	0	289	2	300	395	UJQ92002.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	288	144	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Botourmiaviridae 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);;