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

9 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
1014361	1014361	PRJNA1068830_P_NODE_80321_length_247_cov_2.287356_g79618_i0	PRJNA1068830	80321	247	2.287356	5.64976932	Caldilinea	233191	Bacteria	Bacteria	335	1.9799999999999992e-87	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g79618	i0	91.093	192.651821862348	247	22	100	0	1	247	1324	1570	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	47585	335	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
4008807	4008807	PRJNA1068830_P_NODE_21904_length_506_cov_1.856813_g21203_i0	PRJNA1068830	21904	506	1.856813	9.39547378	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	839	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g21203	i0	96.64	312.04743083004	506	16	100	1	1	506	596586	596082	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	157896	839	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
4009945	4009945	PRJNA1068830_P_NODE_70844_length_256_cov_0.846995_g70141_i0	PRJNA1068830	70844	256	0.846995	2.1683072	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2893358448\|emb\|OZ220740.1\|	2614250	g70141	i0	90.244	0.16015625	41	3	16	1	43	82	1553719	1553679	MAG: Caldilineaceae bacterium isolate a9c3af8e-fa1b-4b3f-b938-3e58e5a69213 genome assembly, chromosome: 1	blastn	41	52.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
4842248	4842248	PRJNA1068830_P_NODE_47624_length_318_cov_1.706122_g46921_i0	PRJNA1068830	47624	318	1.706122	5.42546796	Caldilinea	233191	Bacteria	Bacteria	399	9.239999999999998e-107	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g46921	i0	89.308	247.955974842767	318	34	100	0	1	318	348	31	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	78850	399	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
6560181	6560181	PRJNA1068830_P_NODE_19926_length_535_cov_2.863636_g19227_i0	PRJNA1068830	19926	535	2.863636	15.3204526	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	531	5.54e-146	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g19227	i0	84.906	775.727102803738	530	74	99	6	1	528	2064399	2063874	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	415014	531	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16760070	16760070	PRJNA1068830_P_NODE_59734_length_281_cov_2.692308_g59031_i0	PRJNA1068830	59734	281	2.692308	7.56538548	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	481	2.79e-131	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g59031	i0	97.509	152.850533807829	281	7	100	0	1	281	597760	598040	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	42951	481	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
19308512	19308512	PRJNA1068830_P_NODE_49256_length_312_cov_2.435146_g48553_i0	PRJNA1068830	49256	312	2.435146	7.59765552	Chloroflexota bacterium	2026724	Bacteria	Bacteria	361	4.27e-95	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g48553	i0	87.742	175.115384615385	310	37	99	1	4	312	1474764	1474455	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	54636	361	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
22691156	22691156	PRJNA1068830_P_NODE_5978_length_1060_cov_3.828774_g5482_i0	PRJNA1068830	5978	1060	3.828774	40.5850044	Caldilinea	233191	Bacteria	Bacteria	1321	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g5482	i0	89.255	235.82641509434	1061	106	99	8	4	1060	1717	661	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	249976	1321	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
24409022	24409022	PRJNA1068830_P_NODE_56720_length_289_cov_1.384259_g56017_i0	PRJNA1068830	56720	289	1.384259	4.00050851	Pelolinea submarina	913107	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1446038753\|dbj\|AP018437.1\|	913107	g56017	i0	100	0.0968858131487889	28	0	10	0	97	124	1363565	1363592	Pelolinea submarina MO-CFX1 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Pelolinea	Pelolinea submarina

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