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

8 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Thermodesulfobacteriota"

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
881931	881931	PRJNA902848_P_NODE_13221_length_253_cov_0.866667_g13171_i0	PRJNA902848	13221	253	0.866667	2.19266751	Syntrophales bacterium	2928017	Bacteria	Bacteria	100	8.08e-17	NTclustered	gi\|2621703594\|emb\|OY761459.1\|	2928017	g13171	i0	82.114	0.486166007905138	123	16	47	6	85	204	1389111	1388992	MAG: Syntrophales bacterium isolate c6a0f7f3-880d-44d6-9c5f-266f97196533 genome assembly, chromosome: 1	blastn	123	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
3432540	3432540	PRJNA902848_P_NODE_13183_length_253_cov_0.866667_g13133_i0	PRJNA902848	13183	253	0.866667	2.19266751	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	278	3.48e-70	NTclustered	gi\|1109565244\|gb\|CP015455.1\|	29542	g13133	i0	86.508	1.99209486166008	252	34	99	0	1	252	2377246	2377497	Syntrophotalea acetylenica strain DSM 3246 chromosome, complete genome	blastn	504	278	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
11085543	11085543	PRJNA902848_P_NODE_14609_length_251_cov_0.876404_g14559_i0	PRJNA902848	14609	251	0.876404	2.19977404	Citrifermentans bremense	60035	Bacteria	Bacteria	102	2.23e-17	NTclustered	gi\|1886376207\|dbj\|AP023213.1\|	60035	g14559	i0	92.857	0.693227091633466	70	5	28	0	182	251	283066	282997	Geobacter bremensis R4 DNA, complete genome	blastn	174	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
11085560	11085560	PRJNA902848_P_NODE_15549_length_249_cov_0.886364_g15499_i0	PRJNA902848	15549	249	0.886364	2.20704636	Syntrophales bacterium	2928017	Bacteria	Bacteria	135	2.18e-27	NTclustered	gi\|2621706256\|emb\|OY764159.1\|	2928017	g15499	i0	96.386	50.0963855421687	83	2	33	1	130	212	4347796	4347877	MAG: Syntrophales bacterium isolate 28fc5764-0b9a-428c-a12f-8ca866e14e1d genome assembly, chromosome: 1	blastn	12474	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
11085632	11085632	PRJNA902848_P_NODE_18449_length_245_cov_0.906977_g18399_i0	PRJNA902848	18449	245	0.906977	2.22209365	Desulfobacca acetoxidans	60893	Bacteria	Bacteria	108	4.65e-19	NTclustered	gi\|328452070\|gb\|CP002629.1\|	880072	g18399	i0	98.361	0.248979591836735	61	1	25	0	101	161	2267280	2267340	Desulfobacca acetoxidans DSM 11109, complete genome	blastn	61	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
12360947	12360947	PRJNA902848_P_NODE_17010_length_247_cov_0.896552_g16960_i0	PRJNA902848	17010	247	0.896552	2.21448344	Desulfosarcina ovata	83564	Bacteria	Bacteria	93.5	1.32e-14	NTclustered	gi\|1774952549\|dbj\|AP021879.1\|	2752305	g16960	i0	79.389	0.672064777327935	131	27	53	0	116	246	1449553	1449683	Desulfosarcina ovata subsp. ovata oXyS1 DNA, complete genome	blastn	166	93.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina ovata
14000984	14000984	PRJNA902848_P_NODE_20651_length_206_cov_6.436090_g20601_i0	PRJNA902848	20651	206	6.43609	13.2583454	Desulfosudis	2904716	Bacteria	Bacteria	60.2	1.08e-4	NTclustered	gi\|158508843\|gb\|CP000859.1\|	96561	g20601	i0	91.111	0.436893203883495	45	2	21	2	153	196	684766	684809	Desulfococcus oleovorans Hxd3, complete genome	blastn	90	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosudaceae	Desulfosudis	Desulfosudis oleivorans
14001104	14001104	PRJNA902848_P_NODE_8571_length_303_cov_2.317391_g8521_i0	PRJNA902848	8571	303	2.317391	7.02169473	Pseudomonadati	3379134	Bacteria	Bacteria	460	3.959999999999999e-125	NTclustered	gi\|2891482193\|emb\|OZ219926.1\|	2202153	g8521	i0	94.059	275.151815181518	303	18	100	0	1	303	773862	773560	MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3	blastn	83371	460	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota 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);;