metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
8291316	8291316	PRJNA670521_P_NODE_27_length_5661_cov_8.548318_g18_i0	PRJNA670521	27	5661	8.548318	483.92028198	Potexvirus marmormanihotis	3433851	Viruses	Viruses	8421	0	NTclustered	gi\|1847771809\|gb\|KT002435.2\|	39046	g18	i0	93.52	20.0823176117294	5664	361	100	6	1	5661	705	6365	Cassava common mosaic virus isolate Mcol22_1, complete genome	blastn	113686	8421	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
8291606	8291606	PRJNA670521_P_NODE_8007_length_628_cov_4.540541_g7282_i0	PRJNA670521	8007	628	4.540541	28.51459748	Potexvirus marmormanihotis	3433851	Viruses	Viruses	1022	0	NTclustered	gi\|1847771809\|gb\|KT002435.2\|	39046	g7282	i0	96.019	14.937898089172	628	25	100	0	1	628	652	25	Cassava common mosaic virus isolate Mcol22_1, complete genome	blastn	9381	1022	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
14667023	14667023	PRJNA670521_P_NODE_12_length_7224_cov_32.693609_g8_i0	PRJNA670521	12	7224	32.693609	2361.78631416	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2926	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8	i0	96.298	0.666112956810631	1783	61	67	5	13	1793	7108	5329	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4812	2926	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15940838	15940838	PRJNA670521_P_NODE_13_length_7224_cov_29.761851_g8_i1	PRJNA670521	13	7224	29.761851	2149.99611624	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2915	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8	i1	96.186	0.66625138427464	1783	63	67	5	5432	7212	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4813	2915	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
22315417	22315417	PRJNA670521_P_NODE_18_length_6376_cov_44.189116_g12_i0	PRJNA670521	18	6376	44.189116	2817.49803616	Potexvirus marmormanihotis	3433851	Viruses	Viruses	10008	0	NTclustered	gi\|2851473175\|gb\|PQ497977.1\|	39046	g12	i0	94.997	20.7964240903388	6376	319	100	0	1	6376	17	6392	Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome	blastn	132598	10008	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
23590907	23590907	PRJNA670521_P_NODE_19_length_6373_cov_16.364127_g12_i1	PRJNA670521	19	6373	16.364127	1042.88581371	Potexvirus marmormanihotis	3433851	Viruses	Viruses	9915	0	NTclustered	gi\|2018315478\|gb\|MT279196.1\|	39046	g12	i1	94.771	19.8562686332967	6368	333	99	0	6	6373	1	6368	Cassava common mosaic virus isolate BR, complete genome	blastn	126544	9915	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
24864208	24864208	PRJNA670521_P_NODE_20_length_6357_cov_38.469446_g12_i2	PRJNA670521	20	6357	38.469446	2445.50268222	Potexvirus marmormanihotis	3433851	Viruses	Viruses	9718	0	NTclustered	gi\|2851473175\|gb\|PQ497977.1\|	39046	g12	i2	94.258	20.6005977662419	6357	365	100	0	1	6357	17	6373	Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome	blastn	130958	9718	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
24864244	24864244	PRJNA670521_P_NODE_27640_length_372_cov_1.030100_g26896_i0	PRJNA670521	27640	372	1.0301	3.831972	Zebrafish picornavirus 1	2304617	Viruses	Viruses	569	7.899999999999997e-158	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g26896	i0	94.34	2.98387096774194	371	21	99	0	2	372	5563	5193	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1110	569	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1

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