metadata: contig_metadata: 9 rows where bioproject = "PRJNA1264536" and tax

9 rows where bioproject = "PRJNA1264536" 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
363900	363900	PRJNA1264536_P_NODE_5021_length_247_cov_0.896552_g4947_i0	PRJNA1264536	5021	247	0.896552	2.21448344	Zebrafish picornavirus 1	2304617	Viruses	Viruses	433	6.82e-117	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4947	i0	98.374	2.98785425101215	246	4	99	0	2	247	6003	5758	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	738	433	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1638767	1638767	PRJNA1264536_P_NODE_4482_length_252_cov_0.871508_g4408_i0	PRJNA1264536	4482	252	0.871508	2.19620016	brine shrimp yue-like virus 3	2900455	Viruses	Viruses	453	5.36e-123	NTclustered	gi\|2209094277\|gb\|OL472813.1\|	2900455	g4408	i0	99.203	0.996031746031746	251	2	99	0	1	251	120	370	MAG: Brine shrimp yue-like virus 3 isolate 01/QH/92-02 segment 2 hypothetical protein gene, complete cds	blastn	251	453	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 3
13117730	13117730	PRJNA1264536_P_NODE_3911_length_274_cov_1.034826_g3837_i0	PRJNA1264536	3911	274	1.034826	2.83542324	brine shrimp yue-like virus 3	2900455	Viruses	Viruses	496	9.67e-136	NTclustered	gi\|2209095234\|gb\|OL472819.1\|	2900455	g3837	i0	99.27	10.9233576642336	274	2	100	0	1	274	193	466	MAG: Brine shrimp yue-like virus 3 isolate SH/98 segment 2 hypothetical protein gene, complete cds	blastn	2993	496	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 3
18215641	18215641	PRJNA1264536_P_NODE_4215_length_258_cov_1.264865_g4141_i0	PRJNA1264536	4215	258	1.264865	3.2633517	Zebrafish picornavirus 1	2304617	Viruses	Viruses	394	3.39e-105	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4141	i0	94.186	2.86046511627907	258	15	100	0	1	258	5182	4925	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	738	394	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23316036	23316036	PRJNA1264536_P_NODE_2239_length_378_cov_0.973770_g2165_i0	PRJNA1264536	2239	378	0.97377	3.6808506	Zebrafish picornavirus 1	2304617	Viruses	Viruses	649	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2165	i0	98.118	2.97354497354497	372	7	98	0	5	376	7639	8010	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1124	649	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
28463654	28463654	PRJNA1264536_P_NODE_726_length_683_cov_1.106557_g657_i0	PRJNA1264536	726	683	1.106557	7.55778431	brine shrimp arlivirus 5	2900380	Viruses	Viruses	154	4.53e-40	NR	UNI74091.1	2900380	g657	i0	43.8	0.98389458272328	224	126	98.4	0	682	11	61	284	UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	672	154	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
28842241	28842241	PRJNA1264536_P_NODE_3888_length_275_cov_1.158416_g3814_i0	PRJNA1264536	3888	275	1.158416	3.185644	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	112	2.48e-26	NR	AVM87439.1	3063761	g3814	i0	60.2	1.01454545454545	93	34	98.2	1	275	6	467	559	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	279	112	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
31591071	31591071	PRJNA1264536_P_NODE_1076_length_561_cov_1.526639_g1003_i0	PRJNA1264536	1076	561	1.526639	8.56444479	brine shrimp arlivirus 5	2900380	Viruses	Viruses	303	2.1599999999999997e-99	NR	UNI74090.1	2900380	g1003	i0	79.6	0.994652406417112	186	38	99.5	0	3	560	209	394	UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	558	303	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
32318850	32318850	PRJNA1264536_P_NODE_2699_length_341_cov_0.858209_g2625_i0	PRJNA1264536	2699	341	0.858209	2.92649269	Qianjiang picorna-like virus 6	3348787	Viruses	Viruses	127	2.4499999999999997e-31	NR	XHA88449.1	3348787	g2625	i0	54.9	0.994134897360704	113	51	99.4	0	339	1	1946	2058	XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6]	diamond	339	127	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 6

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