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

8 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
954423	954423	PRJNA980585_P_NODE_14481_length_364_cov_2.484536_g14227_i0	PRJNA980585	14481	364	2.484536	9.04371104	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	2.45e-63	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g14227	i0	84.291	72.6483516483516	261	41	72	0	102	362	508041	507781	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	26444	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3505041	3505041	PRJNA980585_P_NODE_1683_length_897_cov_8.383495_g1469_i0	PRJNA980585	1683	897	8.383495	75.19995015	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1572	0	NTclustered	gi\|281313248\|gb\|GU214149.1\|	166587	g1469	i0	98.326	100.667781493868	896	15	99	0	2	897	1	896	Uncultured Chloroflexi bacterium clone IAFpp7227 16S ribosomal RNA gene, partial sequence	blastn	90299	1572	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7332862	7332862	PRJNA980585_P_NODE_53386_length_245_cov_0.895349_g53132_i0	PRJNA980585	53386	245	0.895349	2.19360505	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	91.6	4.69e-14	NTclustered	gi\|2530748470\|gb\|CP128399.1\|	3003348	g53132	i0	92.308	83.3183673469388	65	4	26	1	6	69	2074781	2074717	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 1, complete sequence	blastn	20413	91.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
7333040	7333040	PRJNA980585_P_NODE_7406_length_478_cov_2.955556_g7152_i0	PRJNA980585	7406	478	2.955556	14.12755768	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	473	8.379999999999999e-129	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g7152	i0	90.529	133.194560669456	359	32	75	2	121	478	276015	275658	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	63667	473	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14982303	14982303	PRJNA980585_P_NODE_13812_length_371_cov_2.385906_g13558_i0	PRJNA980585	13812	371	2.385906	8.85171126	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	398	3.929999999999998e-106	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g13558	i0	87.429	207.048517520216	350	39	93	5	26	371	2201741	2201393	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	76815	398	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
14983086	14983086	PRJNA980585_P_NODE_61172_length_241_cov_0.916667_g60918_i0	PRJNA980585	61172	241	0.916667	2.20916747	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	195	3.41e-45	NTclustered	gi\|2621713652\|emb\|OY771913.1\|	2024896	g60918	i0	83.412	75.6307053941909	211	33	87	2	32	241	157766	157557	MAG: Anaerolineaceae bacterium isolate c74f872c-e933-4053-8305-e1536b6d7914 genome assembly, chromosome: 1	blastn	18227	195	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
16571905	16571905	PRJNA980585_P_NODE_40053_length_251_cov_2.404494_g39799_i0	PRJNA980585	40053	251	2.404494	6.03527994	FCB group	1783270	Bacteria	Bacteria	224	4.5599999999999996e-54	NTclustered	gi\|2893358456\|emb\|OZ220748.1\|	2026734	g39799	i0	83.468	94.8565737051793	248	33	97	7	8	251	628785	629028	MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1	blastn	23809	224	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
21356602	21356602	PRJNA980585_P_NODE_23117_length_305_cov_2.163793_g22863_i0	PRJNA980585	23117	305	2.163793	6.59956865	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	298	3.31e-76	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g22863	i0	84.314	211.69836065573801	306	46	100	2	1	305	2829674	2829370	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	64568	298	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis

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