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

5 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_order	tax_family	tax_genus	tax_species
2212008	2212008	PRJNA951810_P_NODE_185022_length_226_cov_2.816993_g184677_i0	PRJNA951810	185022	226	2.816993	6.36640418	Persicimonas caeni	2292766	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g184677	i0	96.875	0.283185840707965	32	0	14	1	124	155	2713122	2713092	Persicimonas caeni strain YN101 chromosome	blastn	64	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
13690752	13690752	PRJNA951810_P_NODE_27291_length_385_cov_4.217949_g26949_i0	PRJNA951810	27291	385	4.217949	16.23910365	uncultured delta proteobacterium	34034	Bacteria	Bacteria	163	1.6299999999999998e-35	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g26949	i0	77.739	0.735064935064935	283	51	71	8	8	280	3170501	3170781	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	283	163	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13691343	13691343	PRJNA951810_P_NODE_59551_length_310_cov_3.637131_g59208_i0	PRJNA951810	59551	310	3.637131	11.2751061	Bradymonas sediminis	1548548	Bacteria	Bacteria	121	7.83e-23	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g59208	i0	84.553	0.525806451612903	123	18	39	1	16	137	4434837	4434959	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	163	121	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
17514174	17514174	PRJNA951810_P_NODE_145414_length_261_cov_6.765957_g145069_i0	PRJNA951810	145414	261	6.765957	17.65914777	uncultured delta proteobacterium Rifle_16ft_4_minimus_1997	1665176	Bacteria	Bacteria	154	6.34e-33	NTclustered	gi\|874574400\|gb\|KT006970.1\|	1665176	g145069	i0	81.967	3.24137931034483	183	31	70	2	59	240	53040	52859	Uncultured delta proteobacterium Rifle_16ft_4_minimus_1997 genomic sequence	blastn	846	154	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium Rifle_16ft_4_minimus_1997
22612751	22612751	PRJNA951810_P_NODE_123418_length_277_cov_9.176471_g123073_i0	PRJNA951810	123418	277	9.176471	25.41882467	Persicimonas caeni	2292766	Bacteria	Bacteria	126	1.48e-24	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g123073	i0	83.582	13.7870036101083	134	22	48	0	143	276	6381799	6381666	Persicimonas caeni strain YN101 chromosome	blastn	3819	126	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni

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