metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
1716759	1716759	PRJNA453567_P_NODE_33202_length_152_cov_1.356522_g32965_i0	PRJNA453567	33202	152	1.356522	2.06191344	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2814788355\|emb\|OY776212.2\|	2073117	g32965	i0	96.875	0.210526315789474	32	1	21	0	94	125	4275117	4275148	MAG: Anaerolineales bacterium isolate db28be52-e32f-4f71-9c49-3cbd2ddbe7d1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
6819450	6819450	PRJNA453567_P_NODE_13646_length_248_cov_1.293839_g13409_i0	PRJNA453567	13646	248	1.293839	3.20872072	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2575820107\|emb\|OY730226.1\|	2026734	g13409	i0	100	0.112903225806452	28	0	11	0	135	162	544451	544424	MAG: Dehalococcoidia bacterium isolate c007961a-0c0c-4106-a690-a869d044ef0b genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
6819577	6819577	PRJNA453567_P_NODE_3326_length_597_cov_2.239286_g3109_i0	PRJNA453567	3326	597	2.239286	13.36853742	Tepidiforma flava	3004094	Bacteria	Bacteria	383	1.8399999999999996e-101	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g3109	i0	82.207	71.1825795644891	444	79	74	0	12	455	1949184	1948741	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	42496	383	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
8094942	8094942	PRJNA453567_P_NODE_20747_length_194_cov_1.242038_g20510_i0	PRJNA453567	20747	194	1.242038	2.40955372	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	100	5.9e-17	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g20510	i0	91.667	4.43814432989691	72	6	37	0	8	79	2429435	2429364	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	861	100	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13195394	13195394	PRJNA453567_P_NODE_15711_length_227_cov_2.052632_g15474_i0	PRJNA453567	15711	227	2.052632	4.65947464	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2814788337\|emb\|OY760908.2\|	2026734	g15474	i0	100	0.127753303964758	29	0	13	0	163	191	1040625	1040597	MAG: Dehalococcoidia bacterium isolate 99511b8e-fdeb-40b8-a9fc-769d5cc020c2 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
18293450	18293450	PRJNA453567_P_NODE_19375_length_201_cov_1.646341_g19138_i0	PRJNA453567	19375	201	1.646341	3.30914541	uncultured Anaerolineaceae bacterium	310067	Bacteria	Bacteria	97.1	7.96e-16	NTclustered	gi\|310390358\|gb\|HQ084030.1\|	310067	g19138	i0	77.711	42.8606965174129	166	32	81	5	1	163	113	276	Uncultured Anaerolinaceae bacterium clone F5OHPNU07H9CRV 16S ribosomal RNA gene, partial sequence	blastn	8615	97.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		uncultured Anaerolineaceae bacterium
20843455	20843455	PRJNA453567_P_NODE_13237_length_252_cov_2.720930_g13000_i0	PRJNA453567	13237	252	2.72093	6.8567436	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621705270\|emb\|OY763410.1\|	2026734	g13000	i0	90.476	0.166666666666667	42	2	16	2	162	201	3167076	3167035	MAG: Dehalococcoidia bacterium isolate 8eeee495-67cd-41f6-86a6-ff8f0dc0d692 genome assembly, chromosome: 1	blastn	42	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20843493	20843493	PRJNA453567_P_NODE_19517_length_200_cov_2.257669_g19280_i0	PRJNA453567	19517	200	2.257669	4.515338	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	99	2.2e-16	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g19280	i0	87.209	2.25	86	11	43	0	83	168	1470572	1470487	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	450	99	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium

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