metadata: contig_metadata: 12 rows where bioproject = "PRJNA851399" and tax

12 rows where bioproject = "PRJNA851399" 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
7217736	7217736	PRJNA851399_P_NODE_6226_length_381_cov_1.039157_g5774_i0	PRJNA851399	6226	381	1.039157	3.95918817	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	536	8.229999999999999e-148	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5774	i0	91.864	1	381	31	100	0	1	381	6460	6840	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	381	536	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
11042835	11042835	PRJNA851399_P_NODE_14729_length_196_cov_1.387755_g14276_i0	PRJNA851399	14729	196	1.387755	2.7199998	Chronaparn virus	3129907	Viruses	Viruses	255	1.2e-63	NTclustered	gi\|2717318620\|gb\|PP172304.1\|	3129907	g14276	i0	94.578	151.178571428571	166	8	84	1	2	166	2518	2353	MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence	blastn	29631	255	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Chronaparn virus
25065471	25065471	PRJNA851399_P_NODE_25420_length_167_cov_0.864407_g24967_i0	PRJNA851399	25420	167	0.864407	1.44355969	Viruses	10239	Viruses	Viruses	88.2	1.28e-18	NR	UJQ91961.1	2808997	g24967	i0	76.4	4.8502994011976	55	13	98.8	0	1	165	418	472	UJQ91961.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.]	diamond	810	88.2	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
26674823	26674823	PRJNA851399_P_NODE_30561_length_165_cov_0.879310_g30108_i0	PRJNA851399	30561	165	0.87931	1.4508615	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	98.2	3.8900000000000003e-22	NR	CAI9858974.1	3048756	g30108	i0	80	1	55	11	100	0	165	1	383	437	CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1]	diamond	165	98.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
27055083	27055083	PRJNA851399_P_NODE_9362_length_263_cov_1.401869_g8909_i0	PRJNA851399	9362	263	1.401869	3.68691547	Varroa picorna-like virus	2873563	Viruses	Viruses	50.4	9.52e-5	NR	UCR92485.1	2873563	g8909	i0	50	0.593155893536122	52	24	59.3	1	21	176	685	734	UCR92485.1 MAG: polyprotein [Varroa picorna-like virus]	diamond	156	50.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus
28444733	28444733	PRJNA851399_P_NODE_22506_length_172_cov_1.243902_g22053_i0	PRJNA851399	22506	172	1.243902	2.13951144	Varroa picorna-like virus	2873563	Viruses	Viruses	50.4	2.67e-5	NR	UCR92485.1	2873563	g22053	i0	49	0.854651162790698	49	24	85.5	1	152	6	864	911	UCR92485.1 MAG: polyprotein [Varroa picorna-like virus]	diamond	147	50.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus
29391929	29391929	PRJNA851399_P_NODE_89_length_2720_cov_10.243729_g60_i0	PRJNA851399	89	2720	10.243729	278.6294288	Dicistroviridae sp.	1955144	Viruses	Viruses	153	1.26e-33	NR	XCO49393.1	1955144	g60	i0	26.8	0.721323529411765	654	381	67.5	22	2480	645	911	1508	XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.]	diamond	1962	153	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
29707114	29707114	PRJNA851399_P_NODE_8230_length_293_cov_1.598361_g7777_i0	PRJNA851399	8230	293	1.598361	4.68319773	Varroa picorna-like virus	2873563	Viruses	Viruses	63.9	2.51e-9	NR	UCR92485.1	2873563	g7777	i0	36.6	0.839590443686007	82	52	84	0	41	286	120	201	UCR92485.1 MAG: polyprotein [Varroa picorna-like virus]	diamond	246	63.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus
30054814	30054814	PRJNA851399_P_NODE_7271_length_329_cov_2.096429_g6818_i0	PRJNA851399	7271	329	2.096429	6.89725141	Dicistroviridae sp.	1955144	Viruses	Viruses	109	4.5e-25	NR	XCO49393.1	1955144	g6818	i0	53.3	1.95136778115502	107	49	96.7	1	11	328	329	435	XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.]	diamond	642	109	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
30939832	30939832	PRJNA851399_P_NODE_9794_length_254_cov_1.492683_g9341_i0	PRJNA851399	9794	254	1.492683	3.79141482	Dicistroviridae sp.	1955144	Viruses	Viruses	91.7	2.69e-19	NR	XCO49393.1	1955144	g9341	i0	49.4	1.96062992125984	83	42	98	0	3	251	91	173	XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.]	diamond	498	91.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
31730027	31730027	PRJNA851399_P_NODE_10337_length_244_cov_1.825641_g9884_i0	PRJNA851399	10337	244	1.825641	4.45456404	Cheilomenes sexmaculata picorna-like virus 1	2946586	Viruses	Viruses	53.9	4.36e-6	NR	URA11580.1	2946586	g9884	i0	39	0.94672131147541	77	42	91	2	224	3	1837	1911	URA11580.1 polyprotein [Cheilomenes sexmaculata picorna-like virus 1]	diamond	231	53.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Cheilomenes sexmaculata picorna-like virus 1
32489628	32489628	PRJNA851399_P_NODE_12279_length_218_cov_1.349112_g11826_i0	PRJNA851399	12279	218	1.349112	2.94106416	Varroa picorna-like virus	2873563	Viruses	Viruses	45.1	0.00425	NR	UCR92485.1	2873563	g11826	i0	38.2	0.935779816513762	68	32	89.4	2	196	2	1	61	UCR92485.1 MAG: polyprotein [Varroa picorna-like virus]	diamond	204	45.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus

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