metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJDB14274" and tax

9 rows where analysis = "blastn", bioproject = "PRJDB14274" 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
8580	8580	PRJDB14274_S_NODE_6901_length_241_cov_1.233333_g6823_i0	PRJDB14274	6901	241	1.233333	2.97233253	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	351	1.91e-92	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6823	i0	92.946	1	241	17	100	0	1	241	6666	6426	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	241	351	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
8590	8590	PRJDB14274_S_NODE_8801_length_214_cov_1.248366_g8723_i0	PRJDB14274	8801	214	1.248366	2.67150324	Skokie dicistro-like virus	2789443	Viruses	Viruses	396	7.559999999999996e-106	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g8723	i0	100	1.98598130841122	214	0	100	0	1	214	5323	5110	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	425	396	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
1282782	1282782	PRJDB14274_S_NODE_2102_length_421_cov_1.500000_g2024_i0	PRJDB14274	2102	421	1.5	6.315	Betacoronavirus pandemicum	3418604	Viruses	Viruses	91.6	8.59e-14	NTclustered	gi\|2165833299\|emb\|OV195597.1\|	2697049	g2024	i0	93.651	17.2256532066508	63	1	15	3	360	421	121	61	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	7252	91.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
1282801	1282801	PRJDB14274_S_NODE_4302_length_297_cov_156.110169_g4224_i0	PRJDB14274	4302	297	156.110169	463.64720193	Betacoronavirus pandemicum	3418604	Viruses	Viruses	91.6	5.85e-14	NTclustered	gi\|2560502367\|emb\|OY629453.1\|	2697049	g4224	i0	95	23.7070707070707	60	0	20	3	1	58	5976	5918	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	7041	91.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
2558415	2558415	PRJDB14274_S_NODE_4083_length_305_cov_1.331967_g4005_i0	PRJDB14274	4083	305	1.331967	4.06249935	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	536	6.439999999999998e-148	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4005	i0	98.361	1	305	5	100	0	1	305	6451	6147	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	305	536	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15310668	15310668	PRJDB14274_S_NODE_9733_length_206_cov_0.896552_g9655_i0	PRJDB14274	9733	206	0.896552	1.84689712	Skokie dicistro-like virus	2789443	Viruses	Viruses	326	9.61e-85	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g9655	i0	95.567	1.97087378640777	203	9	99	0	1	203	5004	4802	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	406	326	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
20409171	20409171	PRJDB14274_S_NODE_4777_length_284_cov_1.062780_g4699_i0	PRJDB14274	4777	284	1.06278	3.0182952	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	215	3.16e-51	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4699	i0	92.105	0.535211267605634	152	12	54	0	133	284	4915	5066	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	152	215	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
21685125	21685125	PRJDB14274_S_NODE_3078_length_348_cov_2.567944_g3000_i0	PRJDB14274	3078	348	2.567944	8.93644512	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	604	2.0199999999999992e-168	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g3000	i0	97.989	1	348	7	100	0	1	348	6767	6420	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	348	604	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
21685139	21685139	PRJDB14274_S_NODE_4998_length_278_cov_1.838710_g4920_i0	PRJDB14274	4998	278	1.83871	5.1116138	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	420	6.09e-113	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4920	i0	93.885	1	278	17	100	0	1	278	6174	6451	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	278	420	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2

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