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

5 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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
7376737	7376737	PRJNA1000943_P_NODE_4926_length_358_cov_1.477193_g4789_i0	PRJNA1000943	4926	358	1.477193	5.28835094	Thermodesulfobacteriota	200940	Bacteria	Bacteria	640	5.689999999999999e-179	NTclustered	gi\|393704040\|gb\|JQ919704.1\|	34034	g4789	i0	98.883	99.5391061452514	358	4	100	0	1	358	8	365	Uncultured delta proteobacterium clone GC0AA5ZH07PP1 16S ribosomal RNA gene, partial sequence	blastn	35635	640	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
8652368	8652368	PRJNA1000943_P_NODE_13947_length_245_cov_2.720930_g13809_i0	PRJNA1000943	13947	245	2.72093	6.6662785	root	1	Root_unresolved	Root_unresolved	403	5.299999999999998e-108	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g13809	i0	96.327	163.857142857143	245	9	100	0	1	245	14641	14397	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	40145	403	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
10348281	10348281	PRJNA1000943_P_NODE_349_length_1140_cov_3.850047_g287_i0	PRJNA1000943	349	1140	3.850047	43.8905358	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1197	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g287	i0	86.908	161.674561403509	1077	130	94	10	69	1140	13900	12830	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	184309	1197	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
14173728	14173728	PRJNA1000943_P_NODE_13612_length_246_cov_1.595376_g13474_i0	PRJNA1000943	13612	246	1.595376	3.92462496	uncultured delta proteobacterium	34034	Bacteria	Bacteria	372	1.5e-98	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g13474	i0	93.902	136.560975609756	246	15	100	0	1	246	13316	13071	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	33594	372	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16721929	16721929	PRJNA1000943_P_NODE_10414_length_259_cov_4.784946_g10276_i0	PRJNA1000943	10414	259	4.784946	12.39301014	uncultured delta proteobacterium	34034	Bacteria	Bacteria	244	3.63e-60	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g10276	i0	83.908	182.054054054054	261	37	100	4	1	259	14811	15068	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	47152	244	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);;