metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA274362" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA274362" and tax_superkingdom = "Viruses"

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
4198056	4198056	PRJNA274362_S_NODE_8604_length_293_cov_1.491803_g8484_i0	PRJNA274362	8604	293	1.491803	4.37098279	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	444	3.84e-120	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8484	i0	94.158	0.993174061433447	291	17	99	0	1	291	5524	5814	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	291	444	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
5473893	5473893	PRJNA274362_S_NODE_21825_length_199_cov_1.206667_g21705_i0	PRJNA274362	21825	199	1.206667	2.40126733	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	244	2.65e-60	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g21705	i0	92.857	0.844221105527638	168	12	84	0	4	171	5082	4915	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	168	244	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
5474246	5474246	PRJNA274362_S_NODE_38025_length_158_cov_2.862385_g37905_i0	PRJNA274362	38025	158	2.862385	4.5225683	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	226	7.269999999999999e-55	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g37905	i0	92.405	1	158	12	100	0	1	158	6376	6219	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	158	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
9298324	9298324	PRJNA274362_S_NODE_10028_length_274_cov_3251.888889_g9908_i0	PRJNA274362	10028	274	3251.888889	8910.17555586	Andhravirus andhra	2732591	Viruses	Viruses	100	8.86e-17	NTclustered	gi\|1842001608\|ref\|NC_047813.1\|	1958907	g9908	i0	100	25.6605839416058	54	0	20	0	217	270	18493	18546	Staphylococcus phage Andhra, complete genome	blastn	7031	100	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Rountreeviridae	Andhravirus	Andhravirus andhra
13124694	13124694	PRJNA274362_S_NODE_4171_length_407_cov_2.812849_g4051_i0	PRJNA274362	4171	407	2.812849	11.44829543	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	592	1.86e-164	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4051	i0	92.875	1	407	29	100	0	1	407	6362	6768	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	407	592	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14399482	14399482	PRJNA274362_S_NODE_19552_length_208_cov_1.257862_g19432_i0	PRJNA274362	19552	208	1.257862	2.61635296	Mus musculus mobilized endogenous polytropic provirus	590745	Viruses	Viruses	353	4.46e-93	NTclustered	gi\|221326511\|gb\|FJ544576.1\|	590745	g19432	i0	97.573	147.586538461538	206	5	99	0	2	207	379	174	Mus musculus mobilized endogenous polytropic provirus clone 5 truncated gag-pol polyprotein (gag) gene, complete cds	blastn	30698	353	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Mus musculus mobilized endogenous polytropic provirus
14399934	14399934	PRJNA274362_S_NODE_9072_length_286_cov_2.177215_g8952_i0	PRJNA274362	9072	286	2.177215	6.2268349	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	381	2.9699999999999986e-101	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8952	i0	91.398	0.975524475524476	279	22	97	2	2	279	5830	6107	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	279	381	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15086227	15086227	PRJNA274362_S_NODE_37592_length_162_cov_0.920354_g37472_i0	PRJNA274362	37592	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	272	9.51e-69	NTclustered	gi\|2914842066\|gb\|OR222894.1\|	2832643	g37472	i0	96.914	32.2962962962963	162	5	100	0	1	162	15143	15304	MAG: Caudoviricetes sp. isolate MSP0452 genomic sequence	blastn	5232	272	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16947664	16947664	PRJNA274362_S_NODE_10854_length_266_cov_0.889401_g10734_i0	PRJNA274362	10854	266	0.889401	2.36580666	Sopamon virus	3131721	Viruses	Viruses	313	1.01e-80	NTclustered	gi\|2717323235\|gb\|PP174022.1\|	3131721	g10734	i0	93.427	201.116541353383	213	11	80	2	1	212	330	120	MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence	blastn	53497	313	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopamon virus
16948027	16948027	PRJNA274362_S_NODE_27434_length_181_cov_0.886364_g27314_i0	PRJNA274362	27434	181	0.886364	1.60431884	Caudoviricetes sp.	2832643	Viruses	Viruses	58.4	3.3e-4	NTclustered	gi\|2059768599\|tpg\|BK039092.1\|	2832643	g27314	i0	90.909	18.3867403314917	44	2	24	2	139	181	48648	48690	MAG TPA_asm: Caudoviricetes sp. isolate ctnV51, partial genome	blastn	3328	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19496524	19496524	PRJNA274362_S_NODE_24016_length_191_cov_1.612676_g23896_i0	PRJNA274362	24016	191	1.612676	3.08021116	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	257	3.2400000000000005e-64	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g23896	i0	90.576	1	191	18	100	0	1	191	6918	6728	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	191	257	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
20771763	20771763	PRJNA274362_S_NODE_10957_length_265_cov_1.166667_g10837_i0	PRJNA274362	10957	265	1.166667	3.09166755	Gammaretrovirus murleu	3428959	Viruses	Viruses	477	3.369999999999999e-130	NTclustered	gi\|2228757\|gb\|U94692.1\|RMU94692	11938	g10837	i0	99.617	98.4830188679245	261	1	98	0	5	265	2356	2616	Rauscher murine leukemia virus, complete genome	blastn	26098	477	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
20771920	20771920	PRJNA274362_S_NODE_19157_length_210_cov_0.956522_g19037_i0	PRJNA274362	19157	210	0.956522	2.0086962	Caudoviricetes sp.	2832643	Viruses	Viruses	388	1.24e-103	NTclustered	gi\|2915034053\|gb\|OR222678.1\|	2832643	g19037	i0	100	52.2190476190476	210	0	100	0	1	210	102050	101841	MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence	blastn	10966	388	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23322516	23322516	PRJNA274362_S_NODE_20999_length_202_cov_1.359477_g20879_i0	PRJNA274362	20999	202	1.359477	2.74614354	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	320	4.37e-83	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g20879	i0	95.5	0.99009900990099	200	9	99	0	3	202	4440	4639	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	200	320	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
23322566	23322566	PRJNA274362_S_NODE_23159_length_194_cov_1.296552_g23039_i0	PRJNA274362	23159	194	1.296552	2.51531088	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	254	4.28e-63	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g23039	i0	90.206	1	194	19	100	0	1	194	4447	4254	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	194	254	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
25284753	25284753	PRJNA274362_S_NODE_6220_length_339_cov_7.827586_g6100_i0	PRJNA274362	6220	339	7.827586	26.53551654	root	1	Root_unresolved	Root_unresolved	621	1.95e-173	NTclustered	gi\|2915034053\|gb\|OR222678.1\|	2832643	g6100	i0	99.705	71.2772861356932	339	1	100	0	1	339	30536	30198	MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence	blastn	24163	621	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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