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

5 rows where analysis = "diamond", bioproject = "PRJNA492280" 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
28687294	28687294	PRJNA492280_P_NODE_9707_length_172_cov_3.881481_g9600_i0	PRJNA492280	9707	172	3.881481	6.67614732	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	43.9	0.0058	NR	YP_010840939.1	2951531	g9600	i0	55.3	0.819767441860465	47	20	80.2	1	160	23	14	60	YP_010840939.1 L protein [Hardyhead chuvirus]	diamond	141	43.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
30361222	30361222	PRJNA492280_P_NODE_16272_length_164_cov_4.149606_g16165_i0	PRJNA492280	16272	164	4.149606	6.80535384	Erysiphales associated mitovirus 1	2719863	Viruses	Viruses	44.3	0.00368	NR	QIP68031.1	2719863	g16165	i0	79.2	0.439024390243902	24	5	43.9	0	4	75	224	247	QIP68031.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1]	diamond	72	44.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Erysiphales associated mitovirus 1
31909718	31909718	PRJNA492280_P_NODE_28477_length_155_cov_4.737288_g28370_i0	PRJNA492280	28477	155	4.737288	7.3427964	Xiaogan botourmia-like virus 3	2970214	Viruses	Viruses	52.4	4.43e-6	NR	UUW21033.1	2970214	g28370	i0	87.5	0.929032258064516	24	3	46.5	0	76	5	189	212	UUW21033.1 MAG: putative RNA-dependent RNA polymerase [Xiaogan botourmia-like virus 3]	diamond	144	52.4	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Xiaogan botourmia-like virus 3
32447836	32447836	PRJNA492280_P_NODE_32679_length_150_cov_5.345133_g32572_i0	PRJNA492280	32679	150	5.345133	8.0176995	Plasmopara viticola lesion associated Partitivirus 3	2692001	Viruses	Viruses	43.9	0.0042	NR	QHD64799.1	2692001	g32572	i0	76	1.96	25	6	50	0	76	150	258	282	QHD64799.1 coat protein [Plasmopara viticola lesion associated Partitivirus 3]	diamond	294	43.9	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Plasmopara viticola lesion associated Partitivirus 3
32668495	32668495	PRJNA492280_P_NODE_18720_length_164_cov_3.551181_g18613_i0	PRJNA492280	18720	164	3.551181	5.82393684	Leviviridae sp.	2027243	Viruses	Viruses	44.3	0.00366	NR	URG15268.1	2027243	g18613	i0	83.3	0.439024390243902	24	4	43.9	0	91	162	254	277	URG15268.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	72	44.3	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);;