metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA745553" 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
3275354	3275354	PRJNA745553_S_NODE_1163_length_742_cov_2.520179_g1042_i0	PRJNA745553	1163	742	2.520179	18.69972818	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	579	2.759999999999999e-160	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g1042	i0	81.395	37.6320754716981	731	116	97	12	22	739	8439226	8439949	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	27923	579	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4552707	4552707	PRJNA745553_S_NODE_2064_length_650_cov_6.084922_g1892_i0	PRJNA745553	2064	650	6.084922	39.551993	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	412	2.5699999999999994e-110	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g1892	i0	82.114	3.90615384615385	492	79	75	8	1	487	5154792	5155279	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	2539	412	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4552919	4552919	PRJNA745553_S_NODE_6144_length_468_cov_7.969620_g5950_i0	PRJNA745553	6144	468	7.96962	37.2978216	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	536	1.0299999999999999e-147	NTclustered	gi\|2891482216\|emb\|OZ219949.1\|	2026734	g5950	i0	89.786	79.8525641025641	421	40	90	3	25	445	161063	160646	MAG: Dehalococcoidia bacterium isolate 99137651-b1e7-4859-9a90-ab3a7f48d20f genome assembly, chromosome: 5	blastn	37371	536	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7103047	7103047	PRJNA745553_S_NODE_3806_length_550_cov_4.679245_g3619_i0	PRJNA745553	3806	550	4.679245	25.7358475	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	654	0	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g3619	i0	88.342	375.098181818182	549	58	99	6	1	544	2092326	2091779	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	206304	654	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7103113	7103113	PRJNA745553_S_NODE_6906_length_449_cov_4.646277_g6712_i0	PRJNA745553	6906	449	4.646277	20.86178373	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	501	3.589999999999999e-137	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g6712	i0	87.33	107.438752783964	442	50	97	6	1	437	566853	566413	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	48240	501	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7576697	7576697	PRJNA745553_S_NODE_766_length_825_cov_50.996011_g663_i0	PRJNA745553	766	825	50.996011	420.71709075	Chloroflexus	1107	Bacteria	Bacteria	579	3.079999999999999e-160	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g663	i0	81.127	59.769696969697	763	108	90	29	17	758	748	1	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	49310	579	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14753382	14753382	PRJNA745553_S_NODE_9332_length_396_cov_1.668731_g9137_i0	PRJNA745553	9332	396	1.668731	6.60817476	Chloroflexota bacterium	2026724	Bacteria	Bacteria	148	4.7e-31	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g9137	i0	76.221	141.69696969697	307	58	76	14	97	396	1474600	1474898	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	56112	148	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
15227135	15227135	PRJNA745553_S_NODE_15172_length_316_cov_3.975309_g14977_i0	PRJNA745553	15172	316	3.975309	12.56197644	Chloroflexota	200795	Bacteria	Bacteria	148	3.67e-31	NTclustered	gi\|2893356054\|emb\|OZ220477.1\|	2026734	g14977	i0	83.333	45.6740506329114	162	25	51	2	134	294	457975	457815	MAG: Dehalococcoidia bacterium isolate 4182ea2c-2fba-40db-a838-49949f89881d genome assembly, chromosome: 1	blastn	14433	148	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16026792	16026792	PRJNA745553_S_NODE_20293_length_274_cov_5.815920_g20098_i0	PRJNA745553	20293	274	5.81592	15.9356208	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	217	8.43e-52	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g20098	i0	83.691	92.7335766423358	233	34	84	4	22	252	3567853	3568083	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	25409	217	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
21600788	21600788	PRJNA745553_S_NODE_13617_length_333_cov_4.096154_g13422_i0	PRJNA745553	13617	333	4.096154	13.64019282	Chloroflexus	1107	Bacteria	Bacteria	154	8.36e-33	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g13422	i0	91.15	57.006006006006	113	10	34	0	2	114	1765	1653	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	18983	154	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
24150241	24150241	PRJNA745553_S_NODE_14759_length_320_cov_6.834008_g14564_i0	PRJNA745553	14759	320	6.834008	21.8688256	Chloroflexus	1107	Bacteria	Bacteria	401	2.5899999999999993e-107	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g14564	i0	91.497	158.53125	294	22	92	3	22	314	770	1061	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	50730	401	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans

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