metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA474911" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA474911" 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
6825211	6825211	PRJNA474911_P_NODE_5746_length_235_cov_1.839080_g5619_i0	PRJNA474911	5746	235	1.83908	4.321838	Cripavirus drosophilae	3047809	Viruses	Viruses	429	8.33e-116	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g5619	i0	99.574	20.0893617021277	235	1	100	0	1	235	6598	6364	Drosophila C virus isolate SMN, complete genome	blastn	4721	429	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
6825212	6825212	PRJNA474911_P_NODE_5986_length_229_cov_2.619048_g5859_i0	PRJNA474911	5986	229	2.619048	5.99761992	Cripavirus drosophilae	3047809	Viruses	Viruses	412	8.13e-111	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g5859	i0	99.127	10.1834061135371	229	2	100	0	1	229	7106	6878	Drosophila C virus isolate SMN, complete genome	blastn	2332	412	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
6825223	6825223	PRJNA474911_P_NODE_866_length_689_cov_2.452229_g752_i0	PRJNA474911	866	689	2.452229	16.89585781	Cripavirus drosophilae	3047809	Viruses	Viruses	1234	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g752	i0	98.984	8.99564586357039	689	7	100	0	1	689	3377	4065	Drosophila C virus isolate SMN, complete genome	blastn	6198	1234	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
8100710	8100710	PRJNA474911_P_NODE_1287_length_561_cov_1.814000_g1165_i0	PRJNA474911	1287	561	1.814	10.17654	Cripavirus drosophilae	3047809	Viruses	Viruses	970	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1165	i0	97.861	8.99286987522282	561	12	100	0	1	561	2770	3330	Drosophila C virus isolate CYG, complete genome	blastn	5045	970	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
9375441	9375441	PRJNA474911_P_NODE_3588_length_314_cov_3.114625_g3462_i0	PRJNA474911	3588	314	3.114625	9.7799225	Cripavirus drosophilae	3047809	Viruses	Viruses	544	3.98e-150	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g3462	i0	98.077	7.94585987261147	312	6	99	0	3	314	1701	2012	Drosophila C virus isolate CYG, complete genome	blastn	2495	544	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
9375445	9375445	PRJNA474911_P_NODE_7028_length_209_cov_0.864865_g6901_i0	PRJNA474911	7028	209	0.864865	1.80756785	Eriocheir sinensis alphatetra-like virus	3022104	Viruses	Viruses	274	3.59e-69	NTclustered	gi\|2430285571\|gb\|OP019089.1\|	3022104	g6901	i0	90.385	0.995215311004785	208	20	99	0	1	208	9785	9578	MAG: Eriocheir sinensis alphatetra-like virus isolate Tangshan, Hebei genomic sequence	blastn	208	274	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Alphatetraviridae		Eriocheir sinensis alphatetra-like virus
10651315	10651315	PRJNA474911_P_NODE_4309_length_280_cov_1.598174_g4182_i0	PRJNA474911	4309	280	1.598174	4.4748872	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	433	7.89e-117	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4182	i0	94.624	0.996428571428571	279	15	99	0	1	279	4419	4697	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	279	433	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
11926282	11926282	PRJNA474911_P_NODE_3590_length_314_cov_2.996047_g3464_i0	PRJNA474911	3590	314	2.996047	9.40758758	Cripavirus drosophilae	3047809	Viruses	Viruses	568	2.3599999999999998e-157	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g3464	i0	99.361	8.97133757961783	313	2	99	0	2	314	6823	6511	Drosophila C virus isolate EB, complete genome	blastn	2817	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
13201276	13201276	PRJNA474911_P_NODE_8131_length_202_cov_0.907801_g8004_i0	PRJNA474911	8131	202	0.907801	1.83375802	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	124	3.669999999999999e-24	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8004	i0	92.045	0.435643564356436	88	7	44	0	2	89	1529	1442	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	88	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14476188	14476188	PRJNA474911_P_NODE_2132_length_427_cov_1.822404_g2007_i0	PRJNA474911	2132	427	1.822404	7.78166508	Cripavirus drosophilae	3047809	Viruses	Viruses	619	8.999999999999999e-173	NTclustered	gi\|300871977\|gb\|GU983899.2\|	64279	g2007	i0	98.3	24.8524590163934	353	6	83	0	75	427	99	451	Drosophila C virus isolate AkGB1 polyprotein gene, partial cds	blastn	10612	619	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
15750266	15750266	PRJNA474911_P_NODE_1093_length_613_cov_3.798913_g975_i0	PRJNA474911	1093	613	3.798913	23.28733669	Cripavirus drosophilae	3047809	Viruses	Viruses	1088	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g975	i0	98.695	12.8238172920065	613	8	100	0	1	613	7030	7642	Drosophila C virus isolate CYG, complete genome	blastn	7861	1088	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
15750267	15750267	PRJNA474911_P_NODE_173_length_1424_cov_2.596478_g129_i0	PRJNA474911	173	1424	2.596478	36.97384672	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2025	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g129	i0	92.281	1.00070224719101	1425	108	100	2	1	1424	5512	6935	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	1425	2025	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15750277	15750277	PRJNA474911_P_NODE_553_length_871_cov_2.664198_g459_i0	PRJNA474911	553	871	2.664198	23.20516458	Cripavirus drosophilae	3047809	Viruses	Viruses	1554	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g459	i0	98.852	21.5430539609644	871	10	100	0	1	871	6367	5497	Drosophila C virus isolate SMN, complete genome	blastn	18764	1554	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
17024902	17024902	PRJNA474911_P_NODE_6054_length_228_cov_1.149701_g5927_i0	PRJNA474911	6054	228	1.149701	2.62131828	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	399	6.299999999999999e-107	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5927	i0	98.246	1	228	4	100	0	1	228	258	485	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	228	399	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
18299185	18299185	PRJNA474911_P_NODE_1775_length_475_cov_2.777778_g1651_i0	PRJNA474911	1775	475	2.777778	13.1944455	Cripavirus drosophilae	3047809	Viruses	Viruses	813	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g1651	i0	97.674	12.0947368421053	473	11	99	0	1	473	9098	8626	Drosophila C virus isolate Davidson2006, complete genome	blastn	5745	813	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
20849251	20849251	PRJNA474911_P_NODE_1237_length_577_cov_3.465116_g1115_i0	PRJNA474911	1237	577	3.465116	19.99371932	Cripavirus drosophilae	3047809	Viruses	Viruses	521	3.609999999999999e-143	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1115	i0	97.69	9.59965337954939	303	7	100	0	1	303	8397	8095	Drosophila C virus isolate CYG, complete genome	blastn	5539	521	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
22124078	22124078	PRJNA474911_P_NODE_2038_length_436_cov_2.445333_g1913_i0	PRJNA474911	2038	436	2.445333	10.66165188	Cripavirus drosophilae	3047809	Viruses	Viruses	752	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1913	i0	97.706	8.54128440366972	436	10	100	0	1	436	2228	2663	Drosophila C virus isolate CYG, complete genome	blastn	3724	752	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
24673744	24673744	PRJNA474911_P_NODE_760_length_738_cov_1.666174_g650_i0	PRJNA474911	760	738	1.666174	12.29636412	Cripavirus drosophilae	3047809	Viruses	Viruses	1284	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g650	i0	98.1	11.0460704607046	737	14	99	0	1	737	4563	5299	Drosophila C virus isolate Davidson2006, complete genome	blastn	8152	1284	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae

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