metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
1473710	1473710	PRJNA1093380_P_NODE_17842_length_228_cov_2.451613_g17736_i0	PRJNA1093380	17842	228	2.451613	5.58967764	Iflavirus sacbroodi	3048309	Viruses	Viruses	387	4.91e-103	NTclustered	gi\|2753027973\|gb\|PP830626.1\|	3048309	g17736	i0	97.368	90.6754385964912	228	5	100	1	1	228	8497	8723	MAG: Iflavirus sacbroodi isolate BB_UH12_000002 genomic sequence	blastn	20674	387	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sacbroodi
1473745	1473745	PRJNA1093380_P_NODE_42_length_2003_cov_4.419689_g28_i0	PRJNA1093380	42	2003	4.419689	88.52637067	Zebrafish picornavirus 1	2304617	Viruses	Viruses	3422	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g28	i0	97.504	3.00049925112332	2003	50	100	0	1	2003	4548	6550	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	6010	3422	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4025799	4025799	PRJNA1093380_P_NODE_184_length_1286_cov_3.976917_g136_i0	PRJNA1093380	184	1286	3.976917	51.14315262	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2204	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g136	i0	97.589	3	1286	31	100	0	1	1286	7848	6563	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	3858	2204	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7851930	7851930	PRJNA1093380_P_NODE_607_length_712_cov_1.435055_g508_i0	PRJNA1093380	607	712	1.435055	10.2175916	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	1282	0	NTclustered	gi\|1503203675\|gb\|MH267694.1\|	92395	g508	i0	99.157	94.6137640449438	712	6	100	0	1	712	5838	6549	Black queen cell virus isolate BQCV_MS, complete genome	blastn	67365	1282	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae
10402354	10402354	PRJNA1093380_P_NODE_12709_length_249_cov_3.318182_g12603_i0	PRJNA1093380	12709	249	3.318182	8.26227318	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	409	1.16e-109	NTclustered	gi\|2753027985\|gb\|PP830638.1\|	3047684	g12603	i0	96.386	70.8112449799197	249	8	99	1	2	249	4053	4301	MAG: Triatovirus nigereginacellulae isolate BB_UH12_000004 genomic sequence	blastn	17632	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae
12952844	12952844	PRJNA1093380_P_NODE_13331_length_248_cov_1.760000_g13225_i0	PRJNA1093380	13331	248	1.76	4.3648	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	453	5.2600000000000005e-123	NTclustered	gi\|1139737733\|gb\|KY243932.1\|	92395	g13225	i0	99.597	78.8548387096774	248	1	100	0	1	248	298	545	Black queen cell virus strain PP, complete genome	blastn	19556	453	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae
14227755	14227755	PRJNA1093380_P_NODE_10832_length_257_cov_1.500000_g10726_i0	PRJNA1093380	10832	257	1.5	3.855	Zebrafish picornavirus 1	2304617	Viruses	Viruses	383	7.299999999999998e-102	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10726	i0	93.75	3.00389105058366	256	15	99	1	1	255	3325	3070	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	772	383	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15501877	15501877	PRJNA1093380_P_NODE_593_length_725_cov_2.030675_g495_i0	PRJNA1093380	593	725	2.030675	14.72239375	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1136	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g495	i0	95.021	2.99724137931034	723	36	99	0	3	725	2468	1746	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2173	1136	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16776168	16776168	PRJNA1093380_P_NODE_1294_length_488_cov_1.139759_g1190_i0	PRJNA1093380	1294	488	1.139759	5.56202392	Zebrafish picornavirus 1	2304617	Viruses	Viruses	688	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1190	i0	92.181	2.98360655737705	486	38	99	0	1	486	3118	2633	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1456	688	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19324871	19324871	PRJNA1093380_P_NODE_2316_length_380_cov_2.579805_g2210_i0	PRJNA1093380	2316	380	2.579805	9.803259	Zebrafish picornavirus 1	2304617	Viruses	Viruses	641	1.69e-179	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g2210	i0	97.105	3	380	11	100	0	1	380	4581	4202	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1140	641	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20600230	20600230	PRJNA1093380_P_NODE_457_length_835_cov_5.413386_g366_i0	PRJNA1093380	457	835	5.413386	45.2017731	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1432	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g366	i0	97.605	3	835	20	100	0	1	835	4220	3386	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2505	1432	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21876061	21876061	PRJNA1093380_P_NODE_778_length_632_cov_2.357782_g676_i0	PRJNA1093380	778	632	2.357782	14.90118224	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1013	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g676	i0	95.57	2.99841772151899	632	28	100	0	1	632	1639	1008	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1895	1013	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21876089	21876089	PRJNA1093380_P_NODE_998_length_551_cov_2.424686_g895_i0	PRJNA1093380	998	551	2.424686	13.36001986	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	996	0	NTclustered	gi\|2111847192\|gb\|MZ821816.1\|	92395	g895	i0	99.274	98.8693284936479	551	4	100	0	1	551	7738	8288	Black queen cell virus isolate BQCV_No17_Am059-TJ2019, complete genome	blastn	54477	996	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae
24425067	24425067	PRJNA1093380_P_NODE_2520_length_368_cov_2.088136_g2414_i0	PRJNA1093380	2520	368	2.088136	7.68434048	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	656	0	NTclustered	gi\|2672389520\|gb\|PP216854.1\|	92395	g2414	i0	99.176	94.6902173913043	364	3	99	0	1	364	6443	6080	Black queen cell virus non-structural polyprotein gene, partial cds; and structural polyprotein gene, complete cds	blastn	34846	656	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae
24425144	24425144	PRJNA1093380_P_NODE_8140_length_272_cov_2.040201_g8034_i0	PRJNA1093380	8140	272	2.040201	5.54934672	Triatovirus nigereginacellulae	3047684	Viruses	Viruses	492	1.24e-134	NTclustered	gi\|2164969232\|gb\|MT636341.1\|	92395	g8034	i0	99.265	83.4080882352941	272	2	100	0	1	272	5357	5086	MAG: Black queen cell virus isolate BQCV-MR-OCT15, complete genome	blastn	22687	492	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Triatovirus	Triatovirus nigereginacellulae

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