metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_phylum = "Cossaviricota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6701509	6701509	PRJNA1196438_P_NODE_79866_length_234_cov_2.869565_g79439_i0	PRJNA1196438	79866	234	2.869565	6.7147821	Betapapillomavirus 1	337051	Viruses	Viruses	431	2.3e-116	NTclustered	gi\|1200175664\|gb\|KY969593.1\|	31547	g79439	i0	100	5.4017094017094	233	0	99	0	2	234	7512	7280	Human papillomavirus 20 strain HPV-20/Lancaster/2015, complete genome	blastn	1264	431	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 1
13076998	13076998	PRJNA1196438_P_NODE_63451_length_253_cov_2.177778_g63024_i0	PRJNA1196438	63451	253	2.177778	5.50977834	Betapolyomavirus macacae	1891767	Viruses	Viruses	152	2.1999999999999994e-32	NTclustered	gi\|156598992\|gb\|EF579658.1\|	1891767	g63024	i0	80.882	0.806324110671937	204	30	81	5	1	204	2491	2685	Simian virus 40 isolate SV40(Ad)191, complete genome	blastn	204	152	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
20724722	20724722	PRJNA1196438_P_NODE_61877_length_255_cov_2.714286_g61450_i0	PRJNA1196438	61877	255	2.714286	6.9214293	Alphapolyomavirus quintihominis	1891726	Viruses	Viruses	472	1.5e-128	NTclustered	gi\|293595984\|gb\|HM011552.1\|	493803	g61450	i0	100	100	255	0	100	0	1	255	1655	1909	Merkel cell polyomavirus isolate 25b, complete genome	blastn	25500	472	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Alphapolyomavirus	Alphapolyomavirus quintihominis
22720109	22720109	PRJNA1196438_P_NODE_27198_length_301_cov_4.614035_g26772_i0	PRJNA1196438	27198	301	4.614035	13.88824535	Gammapapillomavirus	325455	Viruses	Viruses	279	1.18e-70	NTclustered	gi\|1559669533\|gb\|MH777373.2\|	10566	g26772	i0	100	2.97009966777409	151	0	99	0	2	152	2856	3006	MAG: Human papillomavirus isolate HPV-mSK_234, complete genome	blastn	894	279	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
22720364	22720364	PRJNA1196438_P_NODE_84198_length_222_cov_6.302013_g83771_i0	PRJNA1196438	84198	222	6.302013	13.99046886	Betapapillomavirus	333922	Viruses	Viruses	411	2.8199999999999996e-110	NTclustered	gi\|1273499018\|gb\|MF588680.1\|	333924	g83771	i0	100	10.009009009009	222	0	100	0	1	222	748	527	Betapapillomavirus 2 isolate Beta02_LCOSOc207, complete genome	blastn	2222	411	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 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);;