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

6 rows where analysis = "blastn", bioproject = "PRJNA849822" 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
7216794	7216794	PRJNA849822_P_NODE_34286_length_252_cov_0.871508_g34112_i0	PRJNA849822	34286	252	0.871508	2.19620016	Desulfomicrobium baculatum	899	Bacteria	Bacteria	316	7.34e-82	NTclustered	gi\|256576994\|gb\|CP001629.1\|	525897	g34112	i0	89.558	2.17063492063492	249	26	99	0	2	250	1098091	1098339	Desulfomicrobium baculatum DSM 4028, complete genome	blastn	547	316	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
12317866	12317866	PRJNA849822_P_NODE_3810_length_824_cov_1.448735_g3651_i0	PRJNA849822	3810	824	1.448735	11.9375764	Desulfomonile tiedjei	2358	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|390621545\|gb\|CP003360.1\|	706587	g3651	i0	96.97	0.0400485436893204	33	1	4	0	782	814	643474	643442	Desulfomonile tiedjei DSM 6799, complete genome	blastn	33	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
15261550	15261550	PRJNA849822_P_NODE_43032_length_242_cov_0.923077_g42858_i0	PRJNA849822	43032	242	0.923077	2.23384634	Desulfovibrio	872	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|1894914451\|emb\|LT984798.1\|	631220	g42858	i0	99.174	4	242	2	100	0	1	242	103144	102903	Desulfovibrio sp. G11 isolate G11PacBio genome assembly, chromosome: 1	blastn	968	436	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. G11
18690025	18690025	PRJNA849822_P_NODE_38595_length_247_cov_0.896552_g38421_i0	PRJNA849822	38595	247	0.896552	2.21448344	Desulfoferula mesophila	3058419	Bacteria	Bacteria	207	4.4999999999999994e-49	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g38421	i0	86.702	0.991902834008097	188	23	76	2	1	187	1424788	1424974	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	245	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
19085055	19085055	PRJNA849822_P_NODE_37275_length_249_cov_0.886364_g37101_i0	PRJNA849822	37275	249	0.886364	2.20704636	Desulfovibrionales	213115	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g37101	i0	87.55	34.3453815261044	249	31	100	0	1	249	549402	549650	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	8552	289	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
23790947	23790947	PRJNA849822_P_NODE_38579_length_247_cov_0.896552_g38405_i0	PRJNA849822	38579	247	0.896552	2.21448344	Desulfomicrobium baculatum	899	Bacteria	Bacteria	270	5.659999999999999e-68	NTclustered	gi\|256576994\|gb\|CP001629.1\|	525897	g38405	i0	86.992	0.995951417004049	246	25	98	7	6	247	3511453	3511211	Desulfomicrobium baculatum DSM 4028, complete genome	blastn	246	270	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum

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