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

10 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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
1586630	1586630	PRJNA1164198_P_NODE_27342_length_248_cov_0.891429_g27073_i0	PRJNA1164198	27342	248	0.891429	2.21074392	Caudoviricetes sp.	2832643	Viruses	Viruses	436	5.3e-118	NTclustered	gi\|2914786054\|gb\|OR222556.1\|	2832643	g27073	i0	98.387	4.20564516129032	248	4	100	0	1	248	66396	66643	MAG: Caudoviricetes sp. isolate MSP0376 genomic sequence	blastn	1043	436	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4138870	4138870	PRJNA1164198_P_NODE_4204_length_614_cov_2.251386_g3956_i0	PRJNA1164198	4204	614	2.251386	13.82351004	Giant panda Iflaviridae	2903093	Viruses	Viruses	446	2.39e-120	NTclustered	gi\|2164966906\|gb\|MZ956593.1\|	2903093	g3956	i0	80.132	14.8192182410423	604	115	98	5	7	607	5113	4512	MAG: Giant panda Iflaviridae isolate PPLV1, partial genome	blastn	9099	446	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
5415090	5415090	PRJNA1164198_P_NODE_30525_length_242_cov_1.846154_g30256_i0	PRJNA1164198	30525	242	1.846154	4.46769268	Bacteriophage sp.	38018	Viruses	Viruses	440	3.9799999999999986e-119	NTclustered	gi\|2295308463\|gb\|OP075212.1\|	38018	g30256	i0	99.587	119.053719008264	242	0	100	1	1	242	351	111	MAG: Bacteriophage sp. isolate 3109_38181, partial genome	blastn	28811	440	1	Viruses							Bacteriophage sp.
13065512	13065512	PRJNA1164198_P_NODE_10611_length_382_cov_1.009709_g10343_i0	PRJNA1164198	10611	382	1.009709	3.85708838	Caudoviricetes sp.	2832643	Viruses	Viruses	279	1.5400000000000002e-70	NTclustered	gi\|2057855660\|tpg\|BK050442.1\|	2832643	g10343	i0	80.319	0.984293193717278	376	69	97	5	11	382	25808	26182	MAG TPA_asm: Caudoviricetes sp. isolate ctANV3, partial genome	blastn	376	279	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14340872	14340872	PRJNA1164198_P_NODE_10932_length_376_cov_1.521452_g10664_i0	PRJNA1164198	10932	376	1.521452	5.72065952	Caudoviricetes sp.	2832643	Viruses	Viruses	667	0	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g10664	i0	99.189	418.188829787234	370	3	98	0	7	376	18368	17999	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	157239	667	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18163614	18163614	PRJNA1164198_P_NODE_30055_length_243_cov_0.917647_g29786_i0	PRJNA1164198	30055	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	444	3.09e-120	NTclustered	gi\|2057879443\|tpg\|BK050812.1\|	2832643	g29786	i0	99.588	95.3909465020576	243	1	100	0	1	243	6673	6431	MAG TPA_asm: Caudoviricetes sp. isolate ctEG41, partial genome	blastn	23180	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19437968	19437968	PRJNA1164198_P_NODE_30076_length_243_cov_0.917647_g29807_i0	PRJNA1164198	30076	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	449	6.65e-122	NTclustered	gi\|2056961566\|tpg\|BK022926.1\|	2832643	g29807	i0	100	34.7901234567901	243	0	100	0	1	243	23187	23429	MAG TPA_asm: Caudoviricetes sp. isolate ctCkG11, partial genome	blastn	8454	449	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19437981	19437981	PRJNA1164198_P_NODE_31696_length_228_cov_3.019355_g31427_i0	PRJNA1164198	31696	228	3.019355	6.8841294	Catovirus CTV1	1977631	Viruses	Viruses	228	3.1499999999999988e-55	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g31427	i0	85.714	0.951754385964912	217	29	95	2	13	228	355783	355998	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	217	228	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
23264233	23264233	PRJNA1164198_P_NODE_28459_length_246_cov_0.901734_g28190_i0	PRJNA1164198	28459	246	0.901734	2.21826564	Caudoviricetes sp.	2832643	Viruses	Viruses	381	2.5e-101	NTclustered	gi\|2059941745\|tpg\|BK024795.1\|	2832643	g28190	i0	94.694	0.995934959349594	245	13	99	0	2	246	31866	32110	MAG TPA_asm: Caudoviricetes sp. isolate ctaYm21, partial genome	blastn	245	381	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24537917	24537917	PRJNA1164198_P_NODE_27720_length_247_cov_0.896552_g27451_i0	PRJNA1164198	27720	247	0.896552	2.21448344	Klebsiella phage vB_KM5a1-KLB28	3145203	Viruses	Viruses	433	6.82e-117	NTclustered	gi\|2899263775\|gb\|PP582755.1\|	3145203	g27451	i0	98.765	2.97570850202429	243	3	98	0	5	247	9765	9523	Klebsiella phage vB_KM5a1-KLB28, complete genome	blastn	735	433	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Klebsiella phage vB_KM5a1-KLB28

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