metadata: contig_metadata: 10 rows where bioproject = "PRJNA896554" and tax

10 rows where bioproject = "PRJNA896554" 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
17448754	17448754	PRJNA896554_P_NODE_152594_length_250_cov_0.870056_g145054_i0	PRJNA896554	152594	250	0.870056	2.17514	Pelobacter propionicus	29543	Bacteria	Bacteria	104	6.16e-18	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g145054	i0	80.69	0.58	145	18	56	6	80	219	1952419	1952280	Pelobacter propionicus DSM 2379, complete genome	blastn	145	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
27971635	27971635	PRJNA896554_P_NODE_87905_length_368_cov_1.457627_g80365_i0	PRJNA896554	87905	368	1.457627	5.36406736	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	89.4	5.97e-19	NR	MBK5275779.1	2099678	g80365	i0	42.2	0.888586956521739	109	62	88	1	7	330	108	216	MBK5275779.1 hypothetical protein [Desulfuromonadales bacterium]	diamond	327	89.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
28453162	28453162	PRJNA896554_P_NODE_63926_length_502_cov_1.435897_g56392_i0	PRJNA896554	63926	502	1.435897	7.20820294	Desulfatibacillum	218207	Bacteria	Bacteria	112	1.92e-25	NR	WP_015947357.1	218208	g56392	i0	42.1	2.91035856573705	159	80	95	6	7	483	361	507	WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans]	diamond	1461	112	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
28800074	28800074	PRJNA896554_P_NODE_110927_length_307_cov_2.594017_g103387_i0	PRJNA896554	110927	307	2.594017	7.96363219	Thermodesulfobacteriota	200940	Bacteria	Bacteria	52	4.15e-5	NR	WCB48089.1	881	g103387	i0	31.4	1.98371335504886	102	64	96.7	2	303	7	18	116	WCB48089.1 hypothetical protein PH214_16200 [Nitratidesulfovibrio vulgaris]	diamond	609	52	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
28823853	28823853	PRJNA896554_P_NODE_118288_length_294_cov_1.099548_g110748_i0	PRJNA896554	118288	294	1.099548	3.23267112	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	58.2	2.58e-7	NR	MCG8550427.1	2044940	g110748	i0	42.6	1.24489795918367	61	34	61.2	1	9	188	140	200	MCG8550427.1 molybdopterin-dependent oxidoreductase [Desulfobacterales bacterium]	diamond	366	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30411270	30411270	PRJNA896554_P_NODE_137433_length_266_cov_1.419689_g129893_i0	PRJNA896554	137433	266	1.419689	3.77637274	Pseudomonadati	3379134	Bacteria	Bacteria	107	1.2e-24	NR	WP_214186582.1	40983	g129893	i0	58	31.4436090225564	88	37	99.2	0	3	266	578	665	WP_214186582.1 5-histidylcysteine sulfoxide synthase [Geobacter hydrogenophilus]	diamond	8364	108	0.990740740740741	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter hydrogenophilus
30877144	30877144	PRJNA896554_P_NODE_92654_length_352_cov_1.379928_g85114_i0	PRJNA896554	92654	352	1.379928	4.85734656	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	57.8	6.04e-7	NR	NTV49089.1	2282154	g85114	i0	39.8	5.07954545454545	88	50	75	1	265	2	114	198	NTV49089.1 OmpA family protein [Geobacteraceae bacterium]	diamond	1788	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
31098154	31098154	PRJNA896554_P_NODE_177155_length_234_cov_2.229814_g169615_i0	PRJNA896554	177155	234	2.229814	5.21776476	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	55.8	8.15e-7	NR	MEA2115293.1	2202153	g169615	i0	34.6	1.92307692307692	78	51	100	0	234	1	373	450	MEA2115293.1 M13 family metallopeptidase [Thermodesulfobacteriota bacterium]	diamond	450	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31137349	31137349	PRJNA896554_P_NODE_99535_length_333_cov_1.680769_g91995_i0	PRJNA896554	99535	333	1.680769	5.59696077	Pseudomonadati	3379134	Bacteria	Bacteria	184	2.39e-51	NR	MDY0227850.1	52560	g91995	i0	78.9	14.7387387387387	109	23	98.2	0	328	2	757	865	MDY0227850.1 hypothetical protein [Desulfomicrobium apsheronum]	diamond	4908	184	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium apsheronum
31833228	31833228	PRJNA896554_P_NODE_147677_length_253_cov_1.711111_g140137_i0	PRJNA896554	147677	253	1.711111	4.32911083	PVC group	1783257	Bacteria	Bacteria	107	7.67e-25	NR	MDY0222597.1	2067988	g140137	i0	59.5	5.84584980237154	84	34	99.6	0	2	253	687	770	MDY0222597.1 hypothetical protein [Desulfobacterium sp.]	diamond	1479	107	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	Desulfobacterium sp.

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