metadata: contig_metadata: 7 rows where bioproject = "PRJNA983848", tax_kingdom = "Orthornavirae" and tax

7 rows where bioproject = "PRJNA983848", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

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
6069768	6069768	PRJNA983848_P_NODE_110745_length_286_cov_1.267606_g104862_i0	PRJNA983848	110745	286	1.267606	3.62535316	Bivalve RNA virus G5	1926968	Viruses	Viruses	202	2.4799999999999996e-47	NTclustered	gi\|2032488565\|gb\|MW588039.1\|	1926968	g104862	i0	80.702	3.88461538461538	285	34	98	14	6	286	349	82	Bivalve RNA virus G5 strain Abbotsbury/A/2016 replicative protein and structural protein genes, complete cds	blastn	1111	202	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Bivalve RNA virus G5
29527106	29527106	PRJNA983848_P_NODE_93450_length_315_cov_1.611570_g87567_i0	PRJNA983848	93450	315	1.61157	5.0764455	Viruses	10239	Viruses	Viruses	178	1.68e-49	NR	YP_009329823.1	1926968	g87567	i0	81	2	105	20	100	0	315	1	655	759	YP_009329823.1 structural protein [Bivalve RNA virus G5]	diamond	630	178	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Bivalve RNA virus G5
29646962	29646962	PRJNA983848_P_NODE_139530_length_252_cov_1.279330_g133647_i0	PRJNA983848	139530	252	1.27933	3.2239116	Picornavirales Q_sR_OV_	464095	Viruses	Viruses	101	1.1200000000000001e-22	NR	ASG92545.1	2016075	g133647	i0	63.4	1.97619047619048	82	29	97.6	1	7	252	721	801	ASG92545.1 putative non-structural protein [Picornavirales Q_sR_OV_023]	diamond	498	101	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Picornavirales Q_sR_OV_023
31169522	31169522	PRJNA983848_P_NODE_103515_length_297_cov_1.196429_g97632_i0	PRJNA983848	103515	297	1.196429	3.55339413	Viruses	10239	Viruses	Viruses	67.4	1.64e-10	NR	AWK77858.1	2201290	g97632	i0	38.3	1.93939393939394	94	47	94.9	2	294	13	2383	2465	AWK77858.1 polyprotein [Bundaberg bee virus 7]	diamond	576	67.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Bundaberg bee virus 7
31707405	31707405	PRJNA983848_P_NODE_76977_length_355_cov_1.333333_g71094_i0	PRJNA983848	76977	355	1.333333	4.73333215	Viruses	10239	Viruses	Viruses	206	6.999999999999998e-59	NR	ASG92545.1	2016075	g71094	i0	83.9	2.99154929577465	118	19	99.7	0	2	355	1133	1250	ASG92545.1 putative non-structural protein [Picornavirales Q_sR_OV_023]	diamond	1062	206	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Picornavirales Q_sR_OV_023
32271060	32271060	PRJNA983848_P_NODE_48218_length_507_cov_1.467742_g42345_i0	PRJNA983848	48218	507	1.467742	7.44145194	Picornavirales Q_sR_OV_	464095	Viruses	Viruses	201	1.6399999999999998e-56	NR	ASG92546.1	2016075	g42345	i0	55.2	1.01775147928994	172	73	99.4	1	2	505	762	933	ASG92546.1 putative structural protein [Picornavirales Q_sR_OV_023]	diamond	516	201	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Picornavirales Q_sR_OV_023
32429224	32429224	PRJNA983848_P_NODE_61919_length_412_cov_2.203540_g56037_i0	PRJNA983848	61919	412	2.20354	9.0785848	Bivalve RNA virus G5	1926968	Viruses	Viruses	270	2.979999999999999e-82	NR	YP_009329823.1	1926968	g56037	i0	94.2	0.997572815533981	137	8	99.8	0	411	1	463	599	YP_009329823.1 structural protein [Bivalve RNA virus G5]	diamond	411	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Bivalve RNA virus G5

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