metadata: contig_metadata: 11 rows where bioproject = "PRJNA312615" and tax

11 rows where bioproject = "PRJNA312615" 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
2929458	2929458	PRJNA312615_P_NODE_7583_length_446_cov_1.410579_g7433_i0	PRJNA312615	7583	446	1.410579	6.29118234	Campylobacter phage CJLB-4	2781358	Viruses	Viruses	56.2	1.31e-7	NR	QPB10331.1	2781358	g7433	i0	66.7	0.302690582959641	45	15	30.3	0	290	156	10	54	QPB10331.1 hypothetical protein [Campylobacter phage CJLB-4]	diamond	135	56.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Lambdavirus	Campylobacter phage CJLB-4
5482033	5482033	PRJNA312615_P_NODE_50045_length_169_cov_0.866667_g49894_i0	PRJNA312615	50045	169	0.866667	1.46466723	Cutibacterium phage vB_CacS-HV1	3236917	Viruses	Viruses	307	2.73e-79	NTclustered	gi\|2780182484\|gb\|PQ037195.1\|	3236917	g49894	i0	99.408	99.7041420118343	169	1	100	0	1	169	192	360	Cutibacterium phage vB_CacS-HV1, complete genome	blastn	16850	307	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pahexavirus	Cutibacterium phage vB_CacS-HV1
13132033	13132033	PRJNA312615_P_NODE_37611_length_200_cov_1.350993_g37460_i0	PRJNA312615	37611	200	1.350993	2.701986	Caudoviricetes sp.	2832643	Viruses	Viruses	220	4.5e-53	NTclustered	gi\|2914775648\|gb\|OR222112.1\|	2832643	g37460	i0	91.772	30.48	158	13	79	0	3	160	12602	12445	MAG: Caudoviricetes sp. isolate MSP0869 genomic sequence	blastn	6096	220	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
22741020	22741020	PRJNA312615_P_NODE_58938_length_155_cov_2.896226_g58787_i0	PRJNA312615	58938	155	2.896226	4.4891503	Viruses	10239	Viruses	Viruses	287	3.21e-73	NTclustered	gi\|1631923064\|ref\|NC_041928.1\|	1340769	g58787	i0	100	17	155	0	100	0	1	155	12348	12502	Staphylococcus phage phiIBB-SEP1, complete genome	blastn	2635	287	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Herelleviridae	Sepunavirus	Sepunavirus SEP1
23330576	23330576	PRJNA312615_P_NODE_48799_length_171_cov_2.122951_g48648_i0	PRJNA312615	48799	171	2.122951	3.63024621	Caudoviricetes sp.	2832643	Viruses	Viruses	316	4.6e-82	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g48648	i0	100	1	171	0	100	0	1	171	25627	25457	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	171	316	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23330620	23330620	PRJNA312615_P_NODE_50639_length_168_cov_0.873950_g50488_i0	PRJNA312615	50639	168	0.87395	1.468236	Caudoviricetes sp.	2832643	Viruses	Viruses	87.9	3.87e-13	NTclustered	gi\|2914888655\|gb\|OR222597.1\|	2832643	g50488	i0	80	10.6130952380952	130	16	74	8	37	161	87859	87735	MAG: Caudoviricetes sp. isolate MSP0337 genomic sequence	blastn	1783	87.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28779468	28779468	PRJNA312615_P_NODE_6387_length_482_cov_1.279446_g6239_i0	PRJNA312615	6387	482	1.279446	6.16692972	Enterobacteria phage IME1	1090133	Viruses	Viruses	117	4.56e-29	NR	YP_007004316.1	1090133	g6239	i0	46.5	0.79045643153527	127	68	79	0	480	100	27	153	YP_007004316.1 regulatory protein Q [Enterobacteria phage IME10]	diamond	381	117	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Lederbergvirus	Enterobacteria phage IME10
28937567	28937567	PRJNA312615_P_NODE_14148_length_327_cov_1.107914_g13997_i0	PRJNA312615	14148	327	1.107914	3.62287878	Escherichia phage Lambda	2681611	Viruses	Viruses	71.2	6.81e-14	NR	NP_040643.1	2681611	g13997	i0	46.9	0.587155963302752	64	34	58.7	0	120	311	1	64	NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda]	diamond	192	71.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Lambdavirus	Lambdavirus lambda
29726543	29726543	PRJNA312615_P_NODE_17690_length_291_cov_1.140496_g17539_i0	PRJNA312615	17690	291	1.140496	3.31884336	Caudoviricetes sp.	2832643	Viruses	Viruses	91.7	1.48e-21	NR	DAH93386.1	2832643	g17539	i0	69.7	1.36082474226804	66	20	68	0	290	93	48	113	DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.]	diamond	396	91.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30737663	30737663	PRJNA312615_P_NODE_56954_length_163_cov_0.894737_g56803_i0	PRJNA312615	56954	163	0.894737	1.45842131	uncultured Caudovirales phage	2100421	Viruses	Viruses	94.7	3.78e-21	NR	CAB4147586.1	2100421	g56803	i0	81.1	3.92024539877301	53	10	97.5	0	5	163	269	321	CAB4147586.1 phage_term_2, phage terminase, large subunit, PBSX family [uncultured Caudovirales phage]	diamond	639	94.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
32729466	32729466	PRJNA312615_P_NODE_19580_length_275_cov_2.030973_g19429_i0	PRJNA312615	19580	275	2.030973	5.58517575	Caudoviricetes sp.	2832643	Viruses	Viruses	64.3	2.52e-11	NR	DAI56203.1	2832643	g19429	i0	66.7	0.523636363636364	48	16	52.4	0	192	49	24	71	DAI56203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	144	64.3	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);;