metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1086823" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
9121276	9121276	PRJNA1086823_P_NODE_11428_length_258_cov_1.686486_g11311_i0	PRJNA1086823	11428	258	1.686486	4.35113388	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	172	1.73e-38	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g11311	i0	83.158	100.100775193798	190	30	73	2	62	249	2679265	2679454	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	25826	172	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
9121284	9121284	PRJNA1086823_P_NODE_11728_length_255_cov_2.126374_g11611_i0	PRJNA1086823	11728	255	2.126374	5.4222537	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g11611	i0	96.471	580.607843137255	255	9	100	0	1	255	1859430	1859176	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	148055	422	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9121515	9121515	PRJNA1086823_P_NODE_4968_length_357_cov_1.510563_g4851_i0	PRJNA1086823	4968	357	1.510563	5.39270991	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	527	4.6099999999999984e-145	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g4851	i0	93.277	87.4985994397759	357	24	100	0	1	357	1857471	1857827	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	31237	527	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10397083	10397083	PRJNA1086823_P_NODE_1629_length_584_cov_4.230920_g1514_i0	PRJNA1086823	1629	584	4.23092	24.7085728	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	222	4.16e-53	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g1514	i0	74.781	39.4554794520548	571	106	95	33	16	568	571	21	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	23042	222	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
10397105	10397105	PRJNA1086823_P_NODE_17129_length_245_cov_0.906977_g17012_i0	PRJNA1086823	17129	245	0.906977	2.22209365	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|338184653\|gb\|JF985161.1\|	166587	g17012	i0	96.341	99.469387755102	246	8	100	1	1	245	41	286	Uncultured Chloroflexi bacterium clone Paddy_8_4459 16S ribosomal RNA gene, partial sequence	blastn	24370	403	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
10397238	10397238	PRJNA1086823_P_NODE_6829_length_313_cov_1.950000_g6712_i0	PRJNA1086823	6829	313	1.95	6.1035	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	529	1.1099999999999996e-145	NTclustered	gi\|389546740\|gb\|JQ401668.1\|	166587	g6712	i0	97.125	99.4281150159744	313	9	100	0	1	313	323	11	Uncultured Chloroflexi bacterium clone CNY_01836 16S ribosomal RNA gene, partial sequence	blastn	31121	529	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
18045619	18045619	PRJNA1086823_P_NODE_6855_length_313_cov_1.075000_g6738_i0	PRJNA1086823	6855	313	1.075	3.36475	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	418	2.51e-112	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g6738	i0	90.735	644.258785942492	313	29	100	0	1	313	565862	566174	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	201653	418	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19319493	19319493	PRJNA1086823_P_NODE_16976_length_245_cov_0.906977_g16859_i0	PRJNA1086823	16976	245	0.906977	2.22209365	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	276	1.21e-69	NTclustered	gi\|2874254062\|emb\|OY970386.1\|	1672391	g16859	i0	87.449	66.6040816326531	247	21	99	9	3	245	1890453	1890693	MAG: uncultured Chloroflexia bacterium isolate MFD03726.bin.c.14 genome assembly, chromosome: 1	blastn	16318	276	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21870494	21870494	PRJNA1086823_P_NODE_12878_length_252_cov_0.871508_g12761_i0	PRJNA1086823	12878	252	0.871508	2.19620016	Anaerolineales bacterium	2073117	Bacteria	Bacteria	381	2.569999999999999e-101	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g12761	i0	94.694	1.21825396825397	245	13	97	0	8	252	1721863	1721619	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	307	381	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
21870785	21870785	PRJNA1086823_P_NODE_9458_length_278_cov_1.351220_g9341_i0	PRJNA1086823	9458	278	1.35122	3.7563916	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	331	2.9400000000000002e-86	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g9341	i0	89.695	382.881294964029	262	24	94	3	8	267	1857810	1857550	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	106441	331	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);;