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

8 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
635518	635518	PRJNA669701_P_NODE_140321_length_241_cov_1.744048_g139926_i0	PRJNA669701	140321	241	1.744048	4.20315568	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	145	3.48e-30	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g139926	i0	79.803	6.02904564315353	203	37	83	4	1	201	451706	451906	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	1453	145	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
3186888	3186888	PRJNA669701_P_NODE_62103_length_310_cov_3.729958_g61708_i0	PRJNA669701	62103	310	3.729958	11.5628698	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	303	7.24e-78	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g61708	i0	84.936	110.216129032258	312	34	100	4	1	310	273996	273696	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	34167	303	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7015006	7015006	PRJNA669701_P_NODE_90406_length_269_cov_3.081633_g90011_i0	PRJNA669701	90406	269	3.081633	8.28959277	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	145	3.95e-30	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g90011	i0	93.814	73.7918215613383	97	4	36	2	101	196	2202260	2202165	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	19850	145	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
12114373	12114373	PRJNA669701_P_NODE_115930_length_249_cov_0.875000_g115535_i0	PRJNA669701	115930	249	0.875	2.17875	Caldilinea aerophila	133453	Bacteria	Bacteria	200	7.61e-47	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g115535	i0	81.933	5.93172690763052	238	41	95	2	3	239	3123155	3122919	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	1477	200	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
13918679	13918679	PRJNA669701_P_NODE_90691_length_269_cov_1.571429_g90296_i0	PRJNA669701	90691	269	1.571429	4.22714401	Roseiflexus	120961	Bacteria	Bacteria	281	2.89e-71	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g90296	i0	85.609	17.4684014869888	271	35	100	3	1	269	2918	2650	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	4699	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
20290761	20290761	PRJNA669701_P_NODE_45316_length_354_cov_3.637011_g44921_i0	PRJNA669701	45316	354	3.637011	12.87501894	Caldilinea	233191	Bacteria	Bacteria	381	3.759999999999999e-101	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g44921	i0	86.389	96.2033898305085	360	36	100	9	1	354	1142	1494	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	34056	381	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
21037618	21037618	PRJNA669701_P_NODE_121077_length_247_cov_0.885057_g120682_i0	PRJNA669701	121077	247	0.885057	2.18609079	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	444	3.15e-120	NTclustered	gi\|331271596\|gb\|JF776960.1\|	166587	g120682	i0	99.187	99.5748987854251	246	2	99	0	2	247	346	101	Uncultured Chloroflexi bacterium clone QZ-J95 16S ribosomal RNA gene, partial sequence	blastn	24595	444	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
21038023	21038023	PRJNA669701_P_NODE_149197_length_206_cov_6.150376_g148802_i0	PRJNA669701	149197	206	6.150376	12.66977456	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	176	1.02e-39	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g148802	i0	84.831	133.509708737864	178	24	86	2	9	186	926	752	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	27503	176	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1

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