metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

6 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
2560696	2560696	PRJDB9741_P_NODE_16843_length_183_cov_1.888060_g16526_i0	PRJDB9741	16843	183	1.88806	3.4551498	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	200	5.259999999999999e-47	NTclustered	gi\|2621704922\|emb\|OY762209.1\|	2660714	g16526	i0	86.486	165.852459016393	185	21	100	4	1	183	3508622	3508440	MAG: Syntrophorhabdaceae bacterium isolate b67c53bf-795e-48b1-b0c8-2f1cb1e3683a genome assembly, chromosome: 1	blastn	30351	200	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
6389085	6389085	PRJDB9741_P_NODE_20166_length_177_cov_3.625000_g19849_i0	PRJDB9741	20166	177	3.625	6.41625	Pelobacter propionicus	29543	Bacteria	Bacteria	152	1.43e-32	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g19849	i0	82.286	0.988700564971751	175	31	99	0	3	177	3478850	3478676	Pelobacter propionicus DSM 2379, complete genome	blastn	175	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
14039175	14039175	PRJDB9741_P_NODE_9512_length_210_cov_2.701863_g9195_i0	PRJDB9741	9512	210	2.701863	5.6739123	Syntrophales bacterium	2928017	Bacteria	Bacteria	104	5.02e-18	NTclustered	gi\|2621706256\|emb\|OY764159.1\|	2928017	g9195	i0	85.577	6.5	104	9	47	4	1	98	1469682	1469579	MAG: Syntrophales bacterium isolate 28fc5764-0b9a-428c-a12f-8ca866e14e1d genome assembly, chromosome: 1	blastn	1365	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
17862869	17862869	PRJDB9741_P_NODE_4555_length_302_cov_2.596838_g4239_i0	PRJDB9741	4555	302	2.596838	7.84245076	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	206	2.04e-48	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g4239	i0	79.605	76.205298013245	304	48	99	13	5	302	886541	886836	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	23014	206	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
20411426	20411426	PRJDB9741_P_NODE_10317_length_205_cov_1.564103_g10000_i0	PRJDB9741	10317	205	1.564103	3.20641115	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	58.4	3.85e-4	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g10000	i0	100	1.06829268292683	31	0	15	0	95	125	3214337	3214307	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	219	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
21687504	21687504	PRJDB9741_P_NODE_28118_length_167_cov_0.864407_g27801_i0	PRJDB9741	28118	167	0.864407	1.44355969	Geomonas subterranea	2847989	Bacteria	Bacteria	86.1	1.38e-12	NTclustered	gi\|2060227305\|gb\|CP077683.1\|	2847989	g27801	i0	93.103	0.694610778443114	58	4	35	0	109	166	473488	473545	Geomonas subterranea strain RG2 chromosome, complete genome	blastn	116	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas subterranea

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