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

11 rows where analysis = "blastn", bioproject = "PRJNA674050" 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
3194674	3194674	PRJNA674050_P_NODE_26663_length_249_cov_1.664773_g26460_i0	PRJNA674050	26663	249	1.664773	4.14528477	Anaerolineales bacterium	2073117	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g26460	i0	95.582	184.911646586345	249	11	100	0	1	249	2030127	2029879	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	46043	399	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
4472486	4472486	PRJNA674050_P_NODE_8744_length_309_cov_2.631356_g8541_i0	PRJNA674050	8744	309	2.631356	8.13089004	Anaerolineales bacterium	2073117	Bacteria	Bacteria	462	1.12e-125	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g8541	i0	93.831	272.11003236246	308	17	99	2	2	309	2029552	2029857	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	84082	462	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
5747605	5747605	PRJNA674050_P_NODE_3565_length_385_cov_2.394231_g3362_i0	PRJNA674050	3565	385	2.394231	9.21778935	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	390	6.86e-104	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g3362	i0	86.517	618.875324675325	356	47	92	1	29	384	2827800	2827446	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	238267	390	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
7544175	7544175	PRJNA674050_P_NODE_12066_length_288_cov_1.395349_g11863_i0	PRJNA674050	12066	288	1.395349	4.01860512	Tepidiforma	2682228	Bacteria	Bacteria	449	8.090000000000001e-122	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g11863	i0	94.792	240.555555555556	288	15	100	0	1	288	2204644	2204931	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	69280	449	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
8296981	8296981	PRJNA674050_P_NODE_2307_length_448_cov_2.528000_g2104_i0	PRJNA674050	2307	448	2.528	11.32544	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	497	4.64e-136	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g2104	i0	86.83	394	448	56	99	3	2	448	10391	10836	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	176512	497	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
8297793	8297793	PRJNA674050_P_NODE_7027_length_324_cov_4.394422_g6824_i0	PRJNA674050	7027	324	4.394422	14.23792728	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	279	1.28e-70	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g6824	i0	83.077	63.2654320987654	325	37	97	13	1	315	2203450	2203766	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	20498	279	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
9571752	9571752	PRJNA674050_P_NODE_10688_length_295_cov_4.918919_g10485_i0	PRJNA674050	10688	295	4.918919	14.51081105	Anaerolineales bacterium	2073117	Bacteria	Bacteria	379	1.11e-100	NTclustered	gi\|2108400823\|gb\|CP070639.1\|	2073117	g10485	i0	89.933	116.959322033898	298	24	100	6	1	295	3337161	3336867	MAG: Anaerolineales bacterium isolate bin917 chromosome	blastn	34503	379	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
9571832	9571832	PRJNA674050_P_NODE_13128_length_283_cov_1.842857_g12925_i0	PRJNA674050	13128	283	1.842857	5.21528531	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	444	3.69e-120	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g12925	i0	95.035	433.611307420495	282	14	99	0	1	282	2202816	2203097	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	122712	444	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
13397725	13397725	PRJNA674050_P_NODE_2251_length_452_cov_3.889182_g2048_i0	PRJNA674050	2251	452	3.889182	17.57910264	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	460	6.14e-125	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g2048	i0	85.333	215.564159292035	450	60	99	5	5	452	2828273	2827828	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	97435	460	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
22321757	22321757	PRJNA674050_P_NODE_6558_length_329_cov_2.109375_g6355_i0	PRJNA674050	6558	329	2.109375	6.93984375	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	534	2.52e-147	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g6355	i0	96.049	466.188449848024	329	11	100	2	1	329	1028689	1028363	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	153376	534	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23597195	23597195	PRJNA674050_P_NODE_4139_length_368_cov_1.935593_g3936_i0	PRJNA674050	4139	368	1.935593	7.12298224	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	571	2.17e-158	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g3936	i0	94.624	144.489130434783	372	14	100	6	1	368	1858944	1858575	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	53172	571	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);;