metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax_kingdom = "Heunggongvirae"

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_family	tax_genus	tax_species
2056121	2056121	PRJNA795983_S_NODE_39582_length_245_cov_1.790698_g39457_i0	PRJNA795983	39582	245	1.790698	4.3872101	Shockervirus shocker	3432426	Viruses	Viruses	69.4	2.2e-7	NTclustered	gi\|2487592915\|ref\|NC_073470.1\|	2805839	g39457	i0	95.455	0.359183673469388	44	1	18	1	192	235	429	471	Microbacterium phage Shocker, complete genome	blastn	88	69.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Shockervirus	Shockervirus shocker
2491922	2491922	PRJNA795983_S_NODE_24322_length_288_cov_1.074419_g24197_i0	PRJNA795983	24322	288	1.074419	3.09432672	Christensenvirus	2732061	Viruses	Viruses	527	3.63e-145	NTclustered	gi\|1842038479\|ref\|NC_048208.1\|	2507711	g24197	i0	99.653	30.7881944444444	288	1	100	0	1	288	6480	6767	Enterobacteria phage vB_EcoS_IME542, complete genome	blastn	8867	532	0.990601503759398	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae	Christensenvirus	Christensenvirus IME542
3331163	3331163	PRJNA795983_S_NODE_23383_length_292_cov_1.031963_g23258_i0	PRJNA795983	23383	292	1.031963	3.01333196	Christensenvirus IME542	2734000	Viruses	Viruses	523	4.769999999999998e-144	NTclustered	gi\|1842038479\|ref\|NC_048208.1\|	2507711	g23258	i0	98.973	8.78767123287671	292	3	100	0	1	292	28047	28338	Enterobacteria phage vB_EcoS_IME542, complete genome	blastn	2566	523	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae	Christensenvirus	Christensenvirus IME542
8433227	8433227	PRJNA795983_S_NODE_29007_length_271_cov_1.398990_g28882_i0	PRJNA795983	29007	271	1.39899	3.7912629	Shockervirus shocker	3432426	Viruses	Viruses	385	2.16e-102	NTclustered	gi\|2487592915\|ref\|NC_073470.1\|	2805839	g28882	i0	92.565	0.992619926199262	269	18	99	2	1	267	11472	11204	Microbacterium phage Shocker, complete genome	blastn	269	385	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Shockervirus	Shockervirus shocker
12259832	12259832	PRJNA795983_S_NODE_9830_length_391_cov_1.210692_g9705_i0	PRJNA795983	9830	391	1.210692	4.73380572	Christensenvirus IME542	2734000	Viruses	Viruses	723	0	NTclustered	gi\|1842038479\|ref\|NC_048208.1\|	2507711	g9705	i0	100	35.8005115089514	391	0	100	0	1	391	7325	6935	Enterobacteria phage vB_EcoS_IME542, complete genome	blastn	13998	723	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae	Christensenvirus	Christensenvirus IME542
13970475	13970475	PRJNA795983_S_NODE_41091_length_243_cov_1.752941_g40966_i0	PRJNA795983	41091	243	1.752941	4.25964663	Christensenvirus	2732061	Viruses	Viruses	449	6.65e-122	NTclustered	gi\|1842038479\|ref\|NC_048208.1\|	2507711	g40966	i0	100	22.9135802469136	243	0	100	0	1	243	41460	41702	Enterobacteria phage vB_EcoS_IME542, complete genome	blastn	5568	449	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae	Christensenvirus	Christensenvirus IME542
21182513	21182513	PRJNA795983_S_NODE_21057_length_302_cov_1.746725_g20932_i0	PRJNA795983	21057	302	1.746725	5.2751095	Shockervirus shocker	3432426	Viruses	Viruses	451	2.37e-122	NTclustered	gi\|2487592915\|ref\|NC_073470.1\|	2805839	g20932	i0	93.688	1.99006622516556	301	19	99	0	1	301	21083	20783	Microbacterium phage Shocker, complete genome	blastn	601	451	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Shockervirus	Shockervirus shocker
21182764	21182764	PRJNA795983_S_NODE_7677_length_427_cov_5.937853_g7552_i0	PRJNA795983	7677	427	5.937853	25.35463231	Christensenvirus IME542	2734000	Viruses	Viruses	778	0	NTclustered	gi\|1842038479\|ref\|NC_048208.1\|	2507711	g7552	i0	99.532	1	427	2	100	0	1	427	20874	20448	Enterobacteria phage vB_EcoS_IME542, complete genome	blastn	427	778	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae	Christensenvirus	Christensenvirus IME542
22457155	22457155	PRJNA795983_S_NODE_14338_length_343_cov_1.000000_g14213_i0	PRJNA795983	14338	343	1	3.43	Shockervirus shocker	3432426	Viruses	Viruses	551	2.619999999999999e-152	NTclustered	gi\|2487592915\|ref\|NC_073470.1\|	2805839	g14213	i0	95.627	1	343	15	100	0	1	343	40177	40519	Microbacterium phage Shocker, complete genome	blastn	343	551	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Shockervirus	Shockervirus shocker
24168122	24168122	PRJNA795983_S_NODE_37279_length_249_cov_0.875000_g37154_i0	PRJNA795983	37279	249	0.875	2.17875	Viruses	10239	Viruses	Viruses	392	1.1699999999999999e-104	NTclustered	gi\|2583948011\|gb\|OR466728.1\|	3075444	g37154	i0	95.161	9.10441767068273	248	12	99	0	2	249	12329	12576	Escherichia phage ES, complete genome	blastn	2267	392	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Drexlerviridae		Escherichia phage ES

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