metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA489308" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA489308" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
450225	450225	PRJNA489308_P_NODE_1_length_9248_cov_163.244578_g0_i0	PRJNA489308	1	9248	163.244578	15096.85857344	brine shrimp iflavirus 3	2900464	Viruses	Viruses	16859	0	NTclustered	gi\|2209094758\|gb\|OL472451.1\|	2900464	g0	i0	99.61	10.9972967128028	9238	35	99	1	1	9238	1	9237	MAG: Brine shrimp iflavirus 3 isolate KAZ/15-16 RNA-dependent RNA polymerase gene, complete cds	blastn	101703	16859	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 3
1724808	1724808	PRJNA489308_P_NODE_14042_length_320_cov_1.242915_g13966_i0	PRJNA489308	14042	320	1.242915	3.977328	Cotonvirus japonicum	3059904	Viruses	Viruses	52.8	0.03	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g13966	i0	96.774	0.096875	31	1	10	0	9	39	1266203	1266173	Cotonvirus japonicus DNA, complete genome	blastn	31	52.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
3000795	3000795	PRJNA489308_P_NODE_10423_length_351_cov_3.737410_g10347_i0	PRJNA489308	10423	351	3.73741	13.1183091	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	62.1	5.51e-5	NTclustered	gi\|2214231579\|gb\|OM622281.1\|	3003959	g10347	i0	86.207	0.501424501424501	58	6	16	2	157	213	8912	8856	MAG: Picornavirales sp. isolate HPLV-26 genomic sequence	blastn	176	62.1	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
5553844	5553844	PRJNA489308_P_NODE_38825_length_241_cov_0.916667_g38749_i0	PRJNA489308	38825	241	0.916667	2.20916747	Escherichia phage mEp013	3121468	Viruses	Viruses	52.8	0.022	NTclustered	gi\|2691724853\|gb\|PP180002.1\|	3121468	g38749	i0	100	0.116182572614108	28	0	12	0	147	174	50181	50208	Escherichia phage mEp013, complete genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Escherichia phage mEp013
6201245	6201245	PRJNA489308_P_NODE_3485_length_538_cov_6.440860_g3409_i0	PRJNA489308	3485	538	6.44086	34.6518268	root	1	Root_unresolved	Root_unresolved	56.5	0.004	NTclustered	gi\|2293615484\|gb\|OP072807.1\|	38018	g3409	i0	100	0.769516728624535	30	0	6	0	195	224	80172	80201	MAG: Bacteriophage sp. isolate 3938_66698, partial genome	blastn	414	56.5	1	Viruses								Bacteriophage sp.
9378042	9378042	PRJNA489308_P_NODE_33108_length_248_cov_0.880000_g33032_i0	PRJNA489308	33108	248	0.88	2.1824	Sclerotinia sclerotiorum fusarivirus 2	2822941	Viruses	Viruses	422	1.48e-113	NTclustered	gi\|2029278261\|gb\|MT646393.1\|	2822941	g33032	i0	97.561	2.13306451612903	246	6	99	0	3	248	6179	5934	MAG: Sclerotinia sclerotiorum fusarivirus 2, partial genome	blastn	529	422	1	Viruses		Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae		Sclerotinia sclerotiorum fusarivirus 2
9378102	9378102	PRJNA489308_P_NODE_4448_length_490_cov_2.985612_g4372_i0	PRJNA489308	4448	490	2.985612	14.6294988	Marine virus AFVG_250M428	2693597	Viruses	Viruses	52.8	0.048	NTclustered	gi\|1789809847\|gb\|MN694203.1\|	2693597	g4372	i0	100	0.0571428571428571	28	0	6	0	104	131	19701	19674	MAG: Marine virus AFVG_250M428, complete genome	blastn	28	52.8	1	Viruses	Marine virus AFVG							Marine virus AFVG_250M428
10026405	10026405	PRJNA489308_P_NODE_36468_length_244_cov_0.900585_g36392_i0	PRJNA489308	36468	244	0.900585	2.1974274	Viruses	10239	Viruses	Viruses	58.4	4.73e-4	NTclustered	gi\|1780386545\|gb\|MK978772.1\|	2682469	g36392	i0	94.737	0.840163934426229	38	1	15	1	201	237	260218	260181	Moumouvirus maliensis, complete genome	blastn	205	58.4	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'maliensis'
23402471	23402471	PRJNA489308_P_NODE_26079_length_264_cov_1.664921_g26003_i0	PRJNA489308	26079	264	1.664921	4.39539144	Siphoviridae sp. ct8eQ1	2826171	Viruses	Viruses	52.8	0.024	NTclustered	gi\|2051100442\|tpg\|BK015025.1\|	2826171	g26003	i0	100	0.106060606060606	28	0	11	0	211	238	30141	30114	MAG TPA_asm: Siphoviridae sp. ct8eQ1, partial genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ct8eQ1
23402540	23402540	PRJNA489308_P_NODE_37439_length_242_cov_4.491124_g37363_i0	PRJNA489308	37439	242	4.491124	10.86852008	Sclerotinia sclerotiorum mitovirus 42	2879888	Viruses	Viruses	110	1.28e-19	NTclustered	gi\|2132909481\|gb\|MW454891.1\|	2879888	g37363	i0	93.243	0.305785123966942	74	5	31	0	112	185	3066	3139	Sclerotinia sclerotiorum mitovirus 42 isolate GB&PB-4 RNA-dependent RNA polymerase gene, complete cds	blastn	74	110	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Sclerotinia sclerotiorum mitovirus 42

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