metadata: contig_metadata: 5 rows where bioproject = "PRJNA1089179" and tax

5 rows where bioproject = "PRJNA1089179" 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
2745555	2745555	PRJNA1089179_P_NODE_23_length_2254_cov_201.654746_g19_i0	PRJNA1089179	23	2254	201.654746	4545.29797484	brine shrimp iflavirus 3	2900464	Viruses	Viruses	3999	0	NTclustered	gi\|2209094748\|gb\|OL472446.1\|	2900464	g19	i0	99.057	10.8531499556344	2228	21	99	0	24	2251	7008	9235	MAG: Brine shrimp iflavirus 3 isolate VIE/10 RNA-dependent RNA polymerase gene, complete cds	blastn	24463	3999	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 3
16320062	16320062	PRJNA1089179_P_NODE_12193_length_270_cov_1.969543_g12175_i0	PRJNA1089179	12193	270	1.969543	5.3177661	African cichlid piscichuvirus	3065075	Viruses	Viruses	85.1	6.59e-17	NR	WLN26256.1	3065075	g12175	i0	51.3	0.888888888888889	80	39	88.9	0	2	241	236	315	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	240	85.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
18046487	18046487	PRJNA1089179_P_NODE_11475_length_277_cov_1.509804_g11457_i0	PRJNA1089179	11475	277	1.509804	4.18215708	Zebrafish picornavirus 1	2304617	Viruses	Viruses	427	3.6199999999999996e-115	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g11457	i0	96.512	2.7942238267148	258	9	93	0	20	277	7485	7742	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	774	427	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
27532888	27532888	PRJNA1089179_P_NODE_7843_length_321_cov_3.802419_g7825_i0	PRJNA1089179	7843	321	3.802419	12.20576499	Chuvivirus	2842604	Viruses	Viruses	139	2.12e-36	NR	WET19887.1	2842604	g7825	i0	64.2	1.98130841121495	106	38	99.1	0	2	319	249	354	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	636	139	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
31679285	31679285	PRJNA1089179_P_NODE_3297_length_446_cov_4.080429_g3279_i0	PRJNA1089179	3297	446	4.080429	18.19871334	African cichlid piscichuvirus	3065075	Viruses	Viruses	100	1.82e-21	NR	UVF58767.1	3065075	g3279	i0	39.9	1.02914798206278	153	87	99.6	2	2	445	2	154	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	459	100	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus

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