metadata: contig_metadata: 8 rows where bioproject = "PRJNA1078753", tax_kingdom = "Orthornavirae" and tax

8 rows where bioproject = "PRJNA1078753", 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_genus	tax_species
18044258	18044258	PRJNA1078753_P_NODE_18595_length_284_cov_2.189573_g18399_i0	PRJNA1078753	18595	284	2.189573	6.21838732	Partitiviridae sp.	1955170	Viruses	Viruses	114	2.59e-28	NR	QDH91349.1	1955170	g18399	i0	65.9	0.897887323943662	85	29	89.8	0	283	29	170	254	QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.]	diamond	255	114	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
19318469	19318469	PRJNA1078753_P_NODE_9736_length_359_cov_1.356643_g9540_i0	PRJNA1078753	9736	359	1.356643	4.87034837	Fabavirus betaviciae	3047702	Viruses	Viruses	259	1.87e-64	NTclustered	gi\|2202597465\|gb\|MZ571837.1\|	76875	g9540	i0	80.347	4.14763231197772	346	65	96	3	1	344	2864	3208	Broad bean wilt virus 2 isolate LNSY-YZC segment RNA2, complete sequence	blastn	1489	259	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus betaviciae
26624260	26624260	PRJNA1078753_P_NODE_81_length_2396_cov_5.068015_g56_i0	PRJNA1078753	81	2396	5.068015	121.4296394	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	153	4.92e-34	NR	WZI33259.1	RQ13	g56	i0	25.7	1.01168614357262	808	508	97.2	28	2328	1	307	1054	WZI33259.1 MAG: polyprotein [Crocidura lasiura picornavirus 2]	diamond	2424	153	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Zebrafish jaw picornavirus
27983434	27983434	PRJNA1078753_P_NODE_905_length_982_cov_3.667767_g763_i0	PRJNA1078753	905	982	3.667767	36.01747194	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	289	2.72e-84	NR	XBH24011.1	RQ13	g763	i0	49.8	7.15478615071283	293	144	88.9	3	982	110	2094	2385	XBH24011.1 MAG: polyprotein [Coleura bat picornavirus]	diamond	7026	289	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Zebrafish jaw picornavirus
28141544	28141544	PRJNA1078753_P_NODE_1105_length_903_cov_3.660241_g955_i0	PRJNA1078753	1105	903	3.660241	33.05197623	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	306	6.95e-91	NR	XBH24011.1	RQ13	g955	i0	53.4	3.9734219269103	296	130	97.7	6	3	884	1951	2240	XBH24011.1 MAG: polyprotein [Coleura bat picornavirus]	diamond	3588	306	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Zebrafish jaw picornavirus
28457213	28457213	PRJNA1078753_P_NODE_66_length_2497_cov_2.203795_g48_i0	PRJNA1078753	66	2497	2.203795	55.02876115	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	58.2	2.33e-4	NR	YP_010797608.1	RQ13	g48	i0	25.7	0.331597917501001	276	169	29.7	10	766	26	274	542	YP_010797608.1 polyprotein [rajidapivirus A1]	diamond	828	58.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Rajidapivirus	Zebrafish jaw picornavirus
30509804	30509804	PRJNA1078753_P_NODE_93_length_2222_cov_3.143788_g66_i0	PRJNA1078753	93	2222	3.143788	69.85496936	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	110	1.12e-20	NR	ADG03747.2	RQ13	g66	i0	23.9	1.01800180018002	754	408	88.3	25	22	1983	644	1331	ADG03747.2 polyprotein [aichivirus B3]	diamond	2262	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
30857302	30857302	PRJNA1078753_P_NODE_4034_length_512_cov_6.168565_g3840_i0	PRJNA1078753	4034	512	6.168565	31.5830528	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	60.1	5.84e-7	NR	QJX58422.1	RQ13	g3840	i0	41.9	2.16796875	74	42	42.8	1	3	221	2286	2359	QJX58422.1 polyprotein [Salivirus A]	diamond	1110	60.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Salivirus	Zebrafish jaw picornavirus

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