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

10 rows where analysis = "blastn", bioproject = "PRJNA800053" 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_family	tax_genus	tax_species
2072078	2072078	PRJNA800053_P_NODE_9862_length_310_cov_0.932489_g9698_i0	PRJNA800053	9862	310	0.932489	2.8907159	Maltschvirus maltsch	2956182	Viruses	Viruses	416	8.91e-112	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g9698	i0	91.447	0.980645161290323	304	25	98	1	4	307	8245	8547	uncultured Caudovirales phage genome assembly	blastn	304	416	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
4624580	4624580	PRJNA800053_P_NODE_11864_length_288_cov_1.637209_g11700_i0	PRJNA800053	11864	288	1.637209	4.71516192	Maltschvirus maltsch	2956182	Viruses	Viruses	267	8.74e-67	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g11700	i0	84.848	0.916666666666667	264	40	92	0	7	270	28039	28302	uncultured Caudovirales phage genome assembly	blastn	264	267	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
11000159	11000159	PRJNA800053_P_NODE_5469_length_391_cov_2.993711_g5306_i0	PRJNA800053	5469	391	2.993711	11.70541001	Maltschvirus maltsch	2956182	Viruses	Viruses	420	8.89e-113	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g5306	i0	86.579	0.971867007672634	380	51	97	0	11	390	10085	9706	uncultured Caudovirales phage genome assembly	blastn	380	420	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
12275695	12275695	PRJNA800053_P_NODE_21830_length_244_cov_0.900585_g21666_i0	PRJNA800053	21830	244	0.900585	2.1974274	Maltschvirus maltsch	2956182	Viruses	Viruses	231	2.63e-56	NTclustered	gi\|2488155926\|emb\|OX383070.1\|	2100421	g21666	i0	84.426	9.79508196721311	244	28	99	6	1	242	11132	10897	MAG: uncultured Caudovirales phage genome assembly, chromosome: HRS-HS9-C631	blastn	2390	231	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
13549772	13549772	PRJNA800053_P_NODE_16711_length_254_cov_2.795580_g16547_i0	PRJNA800053	16711	254	2.79558	7.1007732	Maltschvirus maltsch	2956182	Viruses	Viruses	265	2.7199999999999996e-66	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g16547	i0	85.887	0.976377952755906	248	35	98	0	7	254	1685	1438	uncultured Caudovirales phage genome assembly	blastn	248	265	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
16098667	16098667	PRJNA800053_P_NODE_11113_length_295_cov_1.207207_g10949_i0	PRJNA800053	11113	295	1.207207	3.56126065	Caudoviricetes sp.	2832643	Viruses	Viruses	372	1.8499999999999998e-98	NTclustered	gi\|1995156296\|gb\|MW346795.1\|	2832643	g10949	i0	99.034	2.15254237288136	207	2	70	0	86	292	906	1112	MAG: Caudoviricetes sp. isolate 1aq-TERL-27 terminase large subunit gene, complete cds	blastn	635	372	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
21198601	21198601	PRJNA800053_P_NODE_16297_length_257_cov_1.597826_g16133_i0	PRJNA800053	16297	257	1.597826	4.10641282	Caudoviricetes sp.	2832643	Viruses	Viruses	281	2.74e-71	NTclustered	gi\|2915004039\|gb\|OR222348.1\|	2832643	g16133	i0	86.667	4.31906614785992	255	33	99	1	4	257	34607	34353	MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence	blastn	1110	281	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23748952	23748952	PRJNA800053_P_NODE_25159_length_210_cov_4.036496_g24995_i0	PRJNA800053	25159	210	4.036496	8.4766416	Maltschvirus maltsch	2956182	Viruses	Viruses	291	3.59e-74	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g24995	i0	93	0.952380952380952	200	12	94	1	4	201	5530	5729	uncultured Caudovirales phage genome assembly	blastn	200	291	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
23748961	23748961	PRJNA800053_P_NODE_4959_length_407_cov_2.392216_g4796_i0	PRJNA800053	4959	407	2.392216	9.73631912	Maltschvirus maltsch	2956182	Viruses	Viruses	604	2.39e-168	NTclustered	gi\|1839167580\|emb\|LR796595.1\|	2100421	g4796	i0	93.58	0.995085995085995	405	26	99	0	3	407	18657	18253	uncultured Caudovirales phage genome assembly	blastn	405	604	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
25022789	25022789	PRJNA800053_P_NODE_16760_length_254_cov_1.696133_g16596_i0	PRJNA800053	16760	254	1.696133	4.30817782	Caudoviricetes sp.	2832643	Viruses	Viruses	108	4.85e-19	NTclustered	gi\|2052958437\|tpg\|BK030157.1\|	2832643	g16596	i0	81.343	2.03543307086614	134	23	52	2	122	254	29968	29836	MAG TPA_asm: Caudoviricetes sp. isolate ct6gw7, partial genome	blastn	517	108	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);;