metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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_species
284820	284820	PRJNA1137393_P_NODE_6901_length_323_cov_3.142336_g6385_i0	PRJNA1137393	6901	323	3.142336	10.14974528	uncultured delta proteobacterium	34034	Bacteria	Bacteria	346	1.24e-90	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g6385	i0	86.111	114.941176470588	324	42	100	3	1	323	12654	12333	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	37126	346	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
2307363	2307363	PRJNA1137393_P_NODE_21502_length_197_cov_24.729730_g20986_i0	PRJNA1137393	21502	197	24.72973	48.7175681	Pseudomonadota	1224	Bacteria	Bacteria	363	6.939999999999998e-96	NTclustered	gi\|396083920\|gb\|JX114435.1\|	34034	g20986	i0	100	98.746192893401	196	0	99	0	2	197	531	336	Uncultured delta proteobacterium clone SNNP_2012-102 16S ribosomal RNA gene, partial sequence	blastn	19453	363	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
2835492	2835492	PRJNA1137393_P_NODE_6103_length_348_cov_3.026756_g5587_i0	PRJNA1137393	6103	348	3.026756	10.53311088	uncultured delta proteobacterium	34034	Bacteria	Bacteria	337	8.13e-88	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g5587	i0	84.659	109.801724137931	352	39	99	10	5	348	13641	13985	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	38211	337	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
6134924	6134924	PRJNA1137393_P_NODE_38285_length_170_cov_1.446281_g37769_i0	PRJNA1137393	38285	170	1.446281	2.4586777	Bacteria	2	Bacteria	Bacteria	303	3.55e-78	NTclustered	gi\|219962810\|gb\|FJ570350.1\|	34034	g37769	i0	98.824	100.035294117647	170	2	100	0	1	170	336	505	Uncultured delta proteobacterium clone A6YG18RM small subunit ribosomal RNA gene, partial sequence	blastn	17006	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
6134940	6134940	PRJNA1137393_P_NODE_4625_length_415_cov_11.183060_g4110_i0	PRJNA1137393	4625	415	11.18306	46.409699	Nannocystis	53	Bacteria	Bacteria	619	8.719999999999999e-173	NTclustered	gi\|430803017\|gb\|KC011126.1\|	34034	g4110	i0	93.932	98.5638554216868	412	21	99	4	6	415	740	331	Uncultured delta proteobacterium clone bsc27 16S ribosomal RNA gene, partial sequence	blastn	40904	625	0.9904	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
11763418	11763418	PRJNA1137393_P_NODE_5250_length_383_cov_3.739521_g4734_i0	PRJNA1137393	5250	383	3.739521	14.32236543	uncultured delta proteobacterium	34034	Bacteria	Bacteria	466	1.0999999999999999e-126	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g4734	i0	88.773	178.707571801567	383	40	99	3	2	383	13654	13274	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	68445	466	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
14313576	14313576	PRJNA1137393_P_NODE_10572_length_255_cov_3.048544_g10056_i0	PRJNA1137393	10572	255	3.048544	7.7737872	uncultured delta proteobacterium	34034	Bacteria	Bacteria	394	3.34e-105	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g10056	i0	94.51	139.254901960784	255	14	100	0	1	255	12911	13165	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	35510	394	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
14313654	14313654	PRJNA1137393_P_NODE_3692_length_482_cov_2.475751_g3180_i0	PRJNA1137393	3692	482	2.475751	11.93311982	uncultured delta proteobacterium	34034	Bacteria	Bacteria	555	2.939999999999999e-153	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g3180	i0	87.526	122.593360995851	481	59	99	1	3	482	13754	13274	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	59090	555	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
20158458	20158458	PRJNA1137393_P_NODE_11016_length_250_cov_2.820896_g10500_i0	PRJNA1137393	11016	250	2.820896	7.05224	Bacteria	2	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|927353730\|gb\|KT322264.1\|	34034	g10500	i0	100	99.448	250	0	100	0	1	250	253	4	Uncultured delta proteobacterium clone TGR_WLFZ-84 16S ribosomal RNA gene, partial sequence	blastn	24862	462	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium

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