metadata: contig_metadata: 9 rows where bioproject = "PRJNA509429", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA509429", 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
3662044	3662044	PRJNA509429_P_NODE_42943_length_172_cov_1.277372_g42115_i0	PRJNA509429	42943	172	1.277372	2.19707984	Desulfobacca	60892	Bacteria	Bacteria	182	1.76e-41	NTclustered	gi\|470488362\|ref\|NR_076865.1\|	60893	g42115	i0	86.667	348.377906976744	165	20	95	2	9	172	395	558	Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence	blastn	59921	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
15138814	15138814	PRJNA509429_P_NODE_33912_length_205_cov_1.241176_g33084_i0	PRJNA509429	33912	205	1.241176	2.5444108	Pseudomonadati	3379134	Bacteria	Bacteria	135	1.7300000000000003e-27	NTclustered	gi\|470490011\|ref\|NR_076962.1\|	2358	g33084	i0	89.623	77.6878048780488	106	11	52	0	100	205	1468	1363	Desulfomonile tiedjei strain DCB-1 23S ribosomal RNA gene, complete sequence	blastn	15926	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
18962395	18962395	PRJNA509429_P_NODE_43895_length_169_cov_1.492537_g43067_i0	PRJNA509429	43895	169	1.492537	2.52238753	Desulfohalobium	45662	Bacteria	Bacteria	110	8.26e-20	NTclustered	gi\|470484951\|ref\|NR_076677.1\|	45663	g43067	i0	85.577	330.171597633136	104	15	62	0	1	104	509	406	Desulfohalobium retbaense strain DSM 5692 23S ribosomal RNA gene, complete sequence	blastn	55799	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfohalobium	Desulfohalobium retbaense
20887295	20887295	PRJNA509429_P_NODE_30777_length_220_cov_2.086486_g29949_i0	PRJNA509429	30777	220	2.086486	4.5902692	Geomonas nitrogeniifigens	2843197	Bacteria	Bacteria	139	1.45e-28	NTclustered	gi\|2060223057\|gb\|CP077684.1\|	2847991	g29949	i0	78.972	35.7409090909091	214	37	94	5	10	215	757894	757681	Geomonas nitrogeniifigens strain RF4 chromosome, complete genome	blastn	7863	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas nitrogeniifigens
22162043	22162043	PRJNA509429_P_NODE_41358_length_176_cov_4.645390_g40530_i0	PRJNA509429	41358	176	4.64539	8.1758864	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	222	1.0699999999999999e-53	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g40530	i0	92.308	352.011363636364	156	12	89	0	21	176	4511760	4511915	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	61954	222	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
28750894	28750894	PRJNA509429_P_NODE_22307_length_279_cov_3.954918_g21479_i0	PRJNA509429	22307	279	3.954918	11.03422122	Syntrophaceae bacterium CG2_3	2052184	Bacteria	Bacteria	46.2	0.00179	NR	OIP88326.1	1805378	g21479	i0	33.7	0.89247311827957	83	43	76.3	2	222	10	85	167	OIP88326.1 MAG: hypothetical protein AUK26_13940 [Syntrophaceae bacterium CG2_30_58_14]	diamond	249	46.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium CG2_30_58_14
29476802	29476802	PRJNA509429_P_NODE_13850_length_381_cov_10.971098_g13027_i0	PRJNA509429	13850	381	10.971098	41.79988338	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	45.1	0.0256	NR	MBQ4133630.1	2049043	g13027	i0	36.2	0.456692913385827	58	35	44.1	1	198	365	368	425	MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium]	diamond	174	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
30235094	30235094	PRJNA509429_P_NODE_32032_length_213_cov_6.578652_g31204_i0	PRJNA509429	32032	213	6.578652	14.01252876	Desulfobulbus sp. TB	1859132	Bacteria	Bacteria	43.1	0.0184	NR	MCW5213304.1	2821764	g31204	i0	34.8	0.929577464788732	66	36	83.1	2	35	211	553	618	MCW5213304.1 cobyric acid synthase [Desulfobulbus sp. TB]	diamond	198	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp. TB
30298783	30298783	PRJNA509429_P_NODE_12052_length_413_cov_8.809524_g11233_i0	PRJNA509429	12052	413	8.809524	36.38333412	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	45.1	0.0346	NR	MBQ4133630.1	2049043	g11233	i0	36.2	0.421307506053269	58	35	40.7	1	230	397	368	425	MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium]	diamond	174	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae 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);;