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

10 rows where analysis = "blastn", bioproject = "PRJNA312615" 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
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
11857047	11857047	PRJNA312615_P_NODE_42770_length_187_cov_1.420290_g42619_i0	PRJNA312615	42770	187	1.42029	2.6559423	Pyongtaek Culex Ribovirus	2902618	Viruses	Viruses	307	3.09e-79	NTclustered	gi\|2163656929\|gb\|MT568536.1\|	2902618	g42619	i0	96.257	1.60427807486631	187	7	100	0	1	187	9047	8861	MAG: Pyongtaek Culex Ribovirus isolate A18.4517 genomic sequence, sequence	blastn	300	307	1	Viruses							Pyongtaek Culex Ribovirus
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.
20190020	20190020	PRJNA312615_P_NODE_35236_length_206_cov_51.191083_g35085_i0	PRJNA312615	35236	206	51.191083	105.45363098	root	1	Root_unresolved	Root_unresolved	267	5.91e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g35085	i0	100	69.9029126213592	144	0	70	0	7	150	11379	11236	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14400	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
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.
24015780	24015780	PRJNA312615_P_NODE_36379_length_203_cov_23.019481_g36228_i0	PRJNA312615	36379	203	23.019481	46.72954643	root	1	Root_unresolved	Root_unresolved	274	3.47e-69	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g36228	i0	100	92.2955665024631	148	0	93	0	1	148	28637	28490	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	18736	274	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
25289857	25289857	PRJNA312615_P_NODE_16240_length_304_cov_20.929412_g16089_i0	PRJNA312615	16240	304	20.929412	63.62541248	root	1	Root_unresolved	Root_unresolved	516	8.36e-142	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g16089	i0	98.962	95.0822368421053	289	1	95	2	6	293	14830	15117	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	28905	516	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
25290095	25290095	PRJNA312615_P_NODE_35980_length_204_cov_42.277419_g35829_i0	PRJNA312615	35980	204	42.277419	86.24593476	root	1	Root_unresolved	Root_unresolved	263	7.549999999999999e-66	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g35829	i0	98.658	73.0392156862745	149	1	73	1	1	148	11551	11403	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14900	263	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari

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