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

11 rows where analysis = "blastn", bioproject = "PRJNA853203" 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
3392016	3392016	PRJNA853203_P_NODE_14263_length_279_cov_1.174757_g14114_i0	PRJNA853203	14263	279	1.174757	3.27757203	Smithellaceae bacterium	2964540	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2626216295\|emb\|OY821638.1\|	2964540	g14114	i0	100	0.100358422939068	28	0	10	0	165	192	1245808	1245781	MAG: Smithellaceae bacterium isolate 7d888188-1d27-4603-a379-950c855845c6 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
3392275	3392275	PRJNA853203_P_NODE_8083_length_296_cov_1.372197_g7934_i0	PRJNA853203	8083	296	1.3721969999999999	4.06170312	Desulfomicrobium baculatum	899	Bacteria	Bacteria	62.1	4.57e-5	NTclustered	gi\|256576994\|gb\|CP001629.1\|	525897	g7934	i0	92.857	0.141891891891892	42	3	14	0	14	55	2783390	2783431	Desulfomicrobium baculatum DSM 4028, complete genome	blastn	42	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
4670035	4670035	PRJNA853203_P_NODE_48884_length_236_cov_2.582822_g48735_i0	PRJNA853203	48884	236	2.582822	6.09545992	Oceanidesulfovibrio marinus	370038	Bacteria	Bacteria	176	1.1999999999999999e-39	NTclustered	gi\|1841667704\|gb\|CP039543.1\|	370038	g48735	i0	84.971	6.78389830508475	173	26	73	0	46	218	1915962	1915790	Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome	blastn	1601	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oceanidesulfovibrio	Oceanidesulfovibrio marinus
9769660	9769660	PRJNA853203_P_NODE_9548_length_290_cov_1.437788_g9399_i0	PRJNA853203	9548	290	1.437788	4.1695852	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	246	1.1499999999999999e-60	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g9399	i0	85.654	2.13793103448276	237	30	81	3	2	236	1364698	1364932	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	620	246	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
12320722	12320722	PRJNA853203_P_NODE_37910_length_247_cov_0.896552_g37761_i0	PRJNA853203	37910	247	0.896552	2.21448344	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	113	1.01e-20	NTclustered	gi\|2108019731\|gb\|CP070768.1\|	2044940	g37761	i0	87.755	2.17004048582996	98	10	40	1	67	164	974187	974092	MAG: Desulfobacterales bacterium isolate bin239 chromosome	blastn	536	113	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
16144163	16144163	PRJNA853203_P_NODE_25413_length_255_cov_1.417582_g25264_i0	PRJNA853203	25413	255	1.417582	3.6148341	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	111	3.77e-20	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g25264	i0	81.955	3.83529411764706	133	22	52	2	111	242	2576509	2576378	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	978	111	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
17419512	17419512	PRJNA853203_P_NODE_10094_length_289_cov_1.143519_g9945_i0	PRJNA853203	10094	289	1.143519	3.30476991	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	228	4.139999999999999e-55	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g9945	i0	81.655	2.75432525951557	278	47	96	4	4	279	4795990	4796265	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	796	228	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
17812221	17812221	PRJNA853203_P_NODE_5714_length_323_cov_1.916000_g5565_i0	PRJNA853203	5714	323	1.916	6.18868	Pseudomonadati	3379134	Bacteria	Bacteria	475	1.52e-129	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g5565	i0	93.189	145.532507739938	323	22	100	0	1	323	1710708	1711030	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	47007	475	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
22518061	22518061	PRJNA853203_P_NODE_1558_length_486_cov_4.719128_g1411_i0	PRJNA853203	1558	486	4.719128	22.93496208	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	243	2.62e-59	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g1411	i0	76.342	83.2222222222222	503	89	99	21	4	486	887043	886551	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	40446	243	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
22912272	22912272	PRJNA853203_P_NODE_17458_length_271_cov_2.888889_g17309_i0	PRJNA853203	17458	271	2.888889	7.82888919	Desulfosudis	2904716	Bacteria	Bacteria	206	1.7999999999999998e-48	NTclustered	gi\|158508843\|gb\|CP000859.1\|	96561	g17309	i0	80.952	122.538745387454	273	41	99	11	1	268	683135	683401	Desulfococcus oleovorans Hxd3, complete genome	blastn	33208	206	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosudaceae	Desulfosudis	Desulfosudis oleivorans
23793682	23793682	PRJNA853203_P_NODE_33819_length_249_cov_0.886364_g33670_i0	PRJNA853203	33819	249	0.886364	2.20704636	Desulfobulbus oligotrophicus	1909699	Bacteria	Bacteria	102	2.21e-17	NTclustered	gi\|1951276582\|gb\|CP054140.1\|	1909699	g33670	i0	74.797	1.96385542168675	246	52	97	10	7	248	162574	162813	Desulfobulbus oligotrophicus strain Prop6 chromosome, complete genome	blastn	489	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oligotrophicus

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