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

9 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax_phylum = "Chloroflexota"

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
445780	445780	PRJNA473799_P_NODE_36261_length_250_cov_1.305085_g35987_i0	PRJNA473799	36261	250	1.305085	3.2627125	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	161	3.61e-35	NTclustered	gi\|2621706240\|emb\|OY764155.1\|	2026734	g35987	i0	81.818	327.388	198	30	79	6	54	250	3052424	3052616	MAG: Dehalococcoidia bacterium isolate 8f8fc053-1767-4988-ba26-2aa978362f9c genome assembly, chromosome: 1	blastn	81847	161	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
1720258	1720258	PRJNA473799_P_NODE_14382_length_291_cov_1.307339_g14108_i0	PRJNA473799	14382	291	1.307339	3.80435649	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	228	4.1699999999999984e-55	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g14108	i0	82.051	7.76288659793814	273	43	93	6	12	282	1497	1229	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	2259	228	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
6823269	6823269	PRJNA473799_P_NODE_28966_length_261_cov_1.037234_g28692_i0	PRJNA473799	28966	261	1.037234	2.70718074	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	63.9	1.1e-5	NTclustered	gi\|2546137831\|emb\|OY282365.1\|	498747	g28692	i0	80.22	1.25670498084291	91	12	34	6	89	176	2512119	2512032	MAG: uncultured Dehalococcoidia bacterium isolate fd47c038-abb2-4c05-9cdb-6b11942eec52 genome assembly, chromosome: 1	blastn	328	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
7473673	7473673	PRJNA473799_P_NODE_27466_length_263_cov_3.168421_g27192_i0	PRJNA473799	27466	263	3.168421	8.33294723	Chloroflexus	1107	Bacteria	Bacteria	305	1.67e-78	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g27192	i0	87.739	31.9543726235741	261	32	99	0	3	263	2668	2928	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	8404	305	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
13849137	13849137	PRJNA473799_P_NODE_11431_length_311_cov_2.840336_g11157_i0	PRJNA473799	11431	311	2.840336	8.83344496	Chloroflexus	1107	Bacteria	Bacteria	361	4.25e-95	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g11157	i0	88.851	176.83922829582	296	30	95	3	18	311	976	682	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	54997	361	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14474006	14474006	PRJNA473799_P_NODE_13772_length_294_cov_2.140271_g13498_i0	PRJNA473799	13772	294	2.140271	6.29239674	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	224	5.459999999999999e-54	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g13498	i0	81.145	48.8945578231293	297	40	98	12	5	292	778441	778730	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	14375	224	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14474067	14474067	PRJNA473799_P_NODE_18072_length_282_cov_2.411483_g17798_i0	PRJNA473799	18072	282	2.411483	6.80038206	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	209	1.46e-49	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g17798	i0	80.515	3.0709219858156	272	53	96	0	11	282	5690623	5690352	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	866	209	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
14474611	14474611	PRJNA473799_P_NODE_6132_length_471_cov_2.165829_g5863_i0	PRJNA473799	6132	471	2.165829	10.20105459	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	566	1.32e-156	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g5863	i0	88.723	457.016985138004	470	43	99	8	1	464	1858490	1858955	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	215255	566	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14474623	14474623	PRJNA473799_P_NODE_7732_length_391_cov_2.267296_g7458_i0	PRJNA473799	7732	391	2.267296	8.86512736	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	322	2.58e-83	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g7458	i0	82.09	65.4424552429668	402	48	100	20	1	391	4902853	4903241	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	25588	322	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus

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