metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA772154" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA772154" and tax_phylum = "Uroviricota"

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
3298523	3298523	PRJNA772154_P_NODE_17663_length_253_cov_0.866667_g17478_i0	PRJNA772154	17663	253	0.866667	2.19266751	Caudoviricetes sp.	2832643	Viruses	Viruses	372	1.55e-98	NTclustered	gi\|2054506791\|tpg\|BK032457.1\|	2832643	g17478	i0	93.254	9.90118577075099	252	17	99	0	1	252	2752	3003	MAG TPA_asm: Caudoviricetes sp. isolate ctsSr14, partial genome	blastn	2505	372	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5851094	5851094	PRJNA772154_P_NODE_5565_length_537_cov_1.114224_g5381_i0	PRJNA772154	5565	537	1.114224	5.98338288	Caudoviricetes sp.	2832643	Viruses	Viruses	948	0	NTclustered	gi\|2060073041\|tpg\|BK025900.1\|	2832643	g5381	i0	98.51	15.8584729981378	537	8	100	0	1	537	8143	8679	MAG TPA_asm: Caudoviricetes sp. isolate cth0r12, partial genome	blastn	8516	948	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8859987	8859987	PRJNA772154_P_NODE_19047_length_250_cov_0.881356_g18862_i0	PRJNA772154	19047	250	0.881356	2.20339	Straboviridae	2946170	Viruses	Viruses	124	4.729999999999999e-24	NTclustered	gi\|1955695353\|gb\|MW388003.1\|	2801814	g18862	i0	97.297	72.332	74	1	29	1	1	73	75058	75131	Acinetobacter phage Melin, complete genome	blastn	18083	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Hadassahvirus	Acinetobacter phage Melin
9675626	9675626	PRJNA772154_P_NODE_12708_length_311_cov_0.983193_g12523_i0	PRJNA772154	12708	311	0.983193	3.05773023	Caudoviricetes sp.	2832643	Viruses	Viruses	564	3.02e-156	NTclustered	gi\|2052269804\|tpg\|BK019919.1\|	2832643	g12523	i0	99.357	1	311	2	100	0	1	311	22841	23151	MAG TPA_asm: Caudoviricetes sp. isolate ct64l1, partial genome	blastn	311	564	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9676059	9676059	PRJNA772154_P_NODE_7788_length_423_cov_1.685714_g7603_i0	PRJNA772154	7788	423	1.685714	7.13057022	Caudoviricetes sp.	2832643	Viruses	Viruses	497	4.35e-136	NTclustered	gi\|2054429973\|tpg\|BK035919.1\|	2832643	g7603	i0	88.095	18.2127659574468	420	48	99	2	5	423	20293	19875	MAG TPA_asm: Caudoviricetes sp. isolate ctKzm4, partial genome	blastn	7704	497	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12227065	12227065	PRJNA772154_P_NODE_18910_length_250_cov_0.881356_g18725_i0	PRJNA772154	18910	250	0.881356	2.20339	Caudoviricetes sp.	2832643	Viruses	Viruses	462	8.83e-126	NTclustered	gi\|2060081391\|tpg\|BK026569.1\|	2832643	g18725	i0	100	1	250	0	100	0	1	250	34538	34787	MAG TPA_asm: Caudoviricetes sp. isolate ctlrH8, partial genome	blastn	250	462	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13501109	13501109	PRJNA772154_P_NODE_18511_length_251_cov_0.876404_g18326_i0	PRJNA772154	18511	251	0.876404	2.19977404	Caudoviricetes sp.	2832643	Viruses	Viruses	403	5.45e-108	NTclustered	gi\|2057832470\|tpg\|BK055568.1\|	2832643	g18326	i0	95.618	9.44621513944223	251	11	100	0	1	251	410	660	MAG TPA_asm: Caudoviricetes sp. isolate ct1QZ18, partial genome	blastn	2371	403	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13501167	13501167	PRJNA772154_P_NODE_20511_length_247_cov_0.896552_g20326_i0	PRJNA772154	20511	247	0.896552	2.21448344	Maltschvirus maltsch	2956182	Viruses	Viruses	307	4.32e-79	NTclustered	gi\|2488156068\|emb\|OX383124.1\|	2100421	g20326	i0	89.2	4.04858299595142	250	21	100	6	1	247	36311	36557	MAG: uncultured Caudovirales phage genome assembly, chromosome: HRSG-H13-C1178	blastn	1000	307	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
16050069	16050069	PRJNA772154_P_NODE_22633_length_242_cov_0.923077_g22448_i0	PRJNA772154	22633	242	0.923077	2.23384634	Caudoviricetes sp.	2832643	Viruses	Viruses	448	2.3799999999999995e-121	NTclustered	gi\|2052210494\|tpg\|BK056294.1\|	2832643	g22448	i0	100	1.97933884297521	242	0	100	0	1	242	5137	4896	MAG TPA_asm: Caudoviricetes sp. isolate ctGoW5, partial genome	blastn	479	448	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16509760	16509760	PRJNA772154_P_NODE_5753_length_525_cov_1.362832_g5569_i0	PRJNA772154	5753	525	1.362832	7.154868	root	1	Root_unresolved	Root_unresolved	953	0	NTclustered	gi\|2059946847\|tpg\|BK024967.1\|	2832643	g5569	i0	99.429	100.011428571429	525	3	100	0	1	525	4598	4074	MAG TPA_asm: Caudoviricetes sp. isolate ctuI618, partial genome	blastn	52506	959	0.993743482794578	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17325437	17325437	PRJNA772154_P_NODE_10214_length_357_cov_1.098592_g10029_i0	PRJNA772154	10214	357	1.098592	3.92197344	Caudoviricetes sp.	2832643	Viruses	Viruses	660	0	NTclustered	gi\|2057012140\|tpg\|BK048698.1\|	2832643	g10029	i0	100	3.99159663865546	357	0	100	0	1	357	20586	20230	MAG TPA_asm: Caudoviricetes sp. isolate ctyFh1, partial genome	blastn	1425	660	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18599188	18599188	PRJNA772154_P_NODE_20415_length_247_cov_0.896552_g20230_i0	PRJNA772154	20415	247	0.896552	2.21448344	Caudoviricetes sp.	2832643	Viruses	Viruses	446	8.759999999999998e-121	NTclustered	gi\|2059690643\|tpg\|BK029444.1\|	2832643	g20230	i0	99.19	1	247	2	100	0	1	247	4524	4770	MAG TPA_asm: Caudoviricetes sp. isolate ctpMy2, partial genome	blastn	247	446	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19874097	19874097	PRJNA772154_P_NODE_17896_length_252_cov_1.351955_g17711_i0	PRJNA772154	17896	252	1.351955	3.4069266	Caudoviricetes sp.	2832643	Viruses	Viruses	460	3.2e-125	NTclustered	gi\|2054548281\|tpg\|BK047993.1\|	2832643	g17711	i0	99.603	13.2936507936508	252	1	100	0	1	252	22085	21834	MAG TPA_asm: Caudoviricetes sp. isolate ctYDy2, partial genome	blastn	3350	460	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21149966	21149966	PRJNA772154_P_NODE_20277_length_247_cov_0.896552_g20092_i0	PRJNA772154	20277	247	0.896552	2.21448344	Caudoviricetes sp.	2832643	Viruses	Viruses	446	8.759999999999998e-121	NTclustered	gi\|2059738469\|tpg\|BK026166.1\|	2832643	g20092	i0	99.19	2.95546558704453	247	2	100	0	1	247	44975	45221	MAG TPA_asm: Caudoviricetes sp. isolate ctX6x2, partial genome	blastn	730	446	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24158493	24158493	PRJNA772154_P_NODE_8799_length_391_cov_1.226415_g8614_i0	PRJNA772154	8799	391	1.226415	4.79528265	root	1	Root_unresolved	Root_unresolved	701	0	NTclustered	gi\|2054781069\|tpg\|BK049728.1\|	2832643	g8614	i0	98.977	99.9641943734015	391	4	100	0	1	391	790	1180	MAG TPA_asm: Caudoviricetes sp. isolate ctQaT6, partial genome	blastn	39086	701	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);;