metadata: contig_metadata: 12 rows where bioproject = "PRJNA193544", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA193544", tax_kingdom = "Pseudomonadati" 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
6157965	6157965	PRJNA193544_S_NODE_2345_length_179_cov_25.766667_g2330_i0	PRJNA193544	2345	179	25.766667	46.12233393	Megalodesulfovibrio	2910978	Bacteria	Bacteria	220	3.93e-53	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g2330	i0	89.714	277.061452513966	175	15	97	3	1	174	662	834	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	49594	220	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
6743538	6743538	PRJNA193544_S_NODE_1206_length_233_cov_29.661765_g1191_i0	PRJNA193544	1206	233	29.661765	69.11191245	Desulfarculia bacterium	3065862	Bacteria	Bacteria	117	7.290000000000001e-22	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g1191	i0	97.101	275.918454935622	69	2	30	0	164	232	336960	336892	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	64289	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
8019291	8019291	PRJNA193544_S_NODE_827_length_269_cov_43.854167_g812_i0	PRJNA193544	827	269	43.854167	117.96770923	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	241	4.900000000000001e-59	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g812	i0	83.026	430.553903345725	271	41	100	5	1	269	222382	222115	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	115819	241	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
8707969	8707969	PRJNA193544_S_NODE_1827_length_199_cov_12.823529_g1812_i0	PRJNA193544	1827	199	12.823529	25.51882271	Desulfovibrionaceae	194924	Bacteria	Bacteria	250	5.71e-62	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g1812	i0	90.206	238.537688442211	194	15	96	4	2	192	806	998	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	47469	250	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
11844473	11844473	PRJNA193544_S_NODE_390_length_337_cov_12687.214286_g375_i0	PRJNA193544	390	337	12687.214286	42755.91214382	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	433	9.72e-117	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g375	i0	92.409	204.017804154303	303	23	90	0	2	304	613881	614183	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	68754	433	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
13119701	13119701	PRJNA193544_S_NODE_851_length_266_cov_10.092827_g836_i0	PRJNA193544	851	266	10.092827	26.84691982	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	464	2.64e-126	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g836	i0	98.12	113.890977443609	266	5	100	0	1	266	494447	494712	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	30295	464	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
14394953	14394953	PRJNA193544_S_NODE_1332_length_223_cov_3.484536_g1317_i0	PRJNA193544	1332	223	3.484536	7.77051528	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	86.1	1.95e-12	NTclustered	gi\|2621705002\|emb\|OY762289.1\|	2049043	g1317	i0	94.545	41.390134529148	55	3	25	0	1	55	714057	714003	MAG: Desulfovibrionaceae bacterium isolate 1e2121d5-5174-4668-bae3-9852897706ae genome assembly, chromosome: 1	blastn	9230	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
15668700	15668700	PRJNA193544_S_NODE_3153_length_157_cov_3.820312_g3138_i0	PRJNA193544	3153	157	3.820312	5.99788984	uncultured Desulfovibrio sp.	167968	Bacteria	Bacteria	252	1.19e-62	NTclustered	gi\|1206269521\|emb\|LT841588.1\|	167968	g3138	i0	95.541	99.8980891719745	157	7	100	0	1	157	30	186	Uncultured Desulfovibrio sp. partial 16S rRNA gene, isolate BACT_OTU_2389	blastn	15684	252	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	uncultured Desulfovibrio sp.
16357652	16357652	PRJNA193544_S_NODE_1673_length_204_cov_22859.611429_g1658_i0	PRJNA193544	1673	204	22859.611429	46633.60731516	Thermodesulfobacteriota	200940	Bacteria	Bacteria	311	2.66e-80	NTclustered	gi\|2418936308\|gb\|OQ154933.1\|	876	g1658	i0	99.415	83.8235294117647	171	1	84	0	1	171	286	456	Desulfovibrio desulfuricans strain JN-38 16S ribosomal RNA gene, partial sequence	blastn	17100	311	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
16943156	16943156	PRJNA193544_S_NODE_2074_length_188_cov_23091.484277_g2059_i0	PRJNA193544	2074	188	23091.484277	43411.99044076	Pseudodesulfovibrio tunisiensis	463192	Bacteria	Bacteria	141	3.34e-29	NTclustered	gi\|2215688239\|gb\|CP094380.1\|	463192	g2059	i0	83.333	36.8829787234043	156	23	82	3	35	188	1160691	1160845	Pseudodesulfovibrio tunisiensis strain RB22 chromosome, complete genome	blastn	6934	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio tunisiensis
18217603	18217603	PRJNA193544_S_NODE_375_length_342_cov_7.958466_g360_i0	PRJNA193544	375	342	7.958466	27.21795372	Desulfolutivibrio sulfodismutans	63561	Bacteria	Bacteria	307	6.250000000000001e-79	NTclustered	gi\|1863422180\|gb\|CP045504.1\|	1121464	g360	i0	85.714	169.891812865497	301	32	86	9	41	334	1153466	1153762	Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome	blastn	58103	307	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfodismutans
22042495	22042495	PRJNA193544_S_NODE_1378_length_220_cov_14.434555_g1363_i0	PRJNA193544	1378	220	14.434555	31.756021	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	180	8.57e-41	NTclustered	gi\|2621704922\|emb\|OY762209.1\|	2660714	g1363	i0	87.421	104.868181818182	159	16	71	4	64	220	3510072	3510228	MAG: Syntrophorhabdaceae bacterium isolate b67c53bf-795e-48b1-b0c8-2f1cb1e3683a genome assembly, chromosome: 1	blastn	23071	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae 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);;