metadata: contig_metadata: 9 rows where bioproject = "PRJEB3181" and tax

9 rows where bioproject = "PRJEB3181" 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
1330209	1330209	PRJEB3181_P_NODE_1022_length_586_cov_61.590991_g888_i0	PRJEB3181	1022	586	61.590991	360.92320726	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	115	7.28e-21	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g888	i0	72.245	4.17235494880546	490	97	81	32	35	507	1926039	1925572	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	2445	115	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
2264127	2264127	PRJEB3181_P_NODE_4682_length_369_cov_36.384615_g4434_i0	PRJEB3181	4682	369	36.384615	134.25922935	Geobacter	28231	Bacteria	Bacteria	217	1.17e-51	NTclustered	gi\|470477521\|ref\|NR_076389.1\|	28232	g4434	i0	84.12	97.1680216802168	233	27	62	8	42	271	226	1	Geobacter metallireducens strain GS-15 23S ribosomal RNA gene, complete sequence	blastn	35855	219	0.990867579908676	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
6434290	6434290	PRJEB3181_S_NODE_1926_length_374_cov_18959.799410_g1634_i0	PRJEB3181	1926	374	18959.79941	70909.6497934	Desulfocarbo indianensis	1348163	Bacteria	Bacteria	83.6	3.59e-17	NR	KMY68640.1	1348163	g1634	i0	42.2	0.818181818181818	102	58	81	1	4	306	58	159	KMY68640.1 hypothetical protein AAU61_03170 [Desulfocarbo indianensis]	diamond	306	83.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfocarbo	Desulfocarbo indianensis
8983157	8983157	PRJEB3181_S_NODE_14508_length_170_cov_2.014815_g14215_i0	PRJEB3181	14508	170	2.014815	3.4251855	Desulfobulbus oralis	1986146	Bacteria	Bacteria	63.9	6.57e-6	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g14215	i0	95	7.58235294117647	40	2	24	0	1	40	1765204	1765243	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	1289	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis
19181607	19181607	PRJEB3181_S_NODE_6236_length_247_cov_9.575472_g5943_i0	PRJEB3181	6236	247	9.575472	23.65141584	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	86.1	2.2e-12	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g5943	i0	74.468	2.27125506072874	235	42	92	17	5	231	1925572	1925796	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	561	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
21732899	21732899	PRJEB3181_S_NODE_7398_length_229_cov_33297.278351_g7105_i0	PRJEB3181	7398	229	33297.278351	76250.76742379	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	196	8.92e-46	NTclustered	gi\|1109565244\|gb\|CP015455.1\|	29542	g7105	i0	88.485	106.947598253275	165	16	72	3	66	229	788739	788577	Syntrophotalea acetylenica strain DSM 3246 chromosome, complete genome	blastn	24491	196	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
28201701	28201701	PRJEB3181_P_NODE_10126_length_267_cov_3.364407_g9862_i0	PRJEB3181	10126	267	3.364407	8.98296669	Desulfocarbo indianensis	1348163	Bacteria	Bacteria	79.3	4.27e-16	NR	KMY68640.1	1348163	g9862	i0	43.8	1	89	49	98.9	1	265	2	71	159	KMY68640.1 hypothetical protein AAU61_03170 [Desulfocarbo indianensis]	diamond	267	79.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfocarbo	Desulfocarbo indianensis
29338657	29338657	PRJEB3181_P_NODE_18669_length_191_cov_3.800000_g18405_i0	PRJEB3181	18669	191	3.8	7.258	Hydrosulfovibrio ferrireducens	2934181	Bacteria	Bacteria	41.6	0.00864	NR	MFQ6757171.1	2934181	g18405	i0	53.1	0.50261780104712	32	10	50.3	1	49	144	48	74	MFQ6757171.1 hypothetical protein [Desulfovibrionaceae bacterium CB1MN]	diamond	96	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Hydrosulfovibrio	Hydrosulfovibrio ferrireducens
30286494	30286494	PRJEB3181_S_NODE_18132_length_153_cov_1.016949_g17839_i0	PRJEB3181	18132	153	1.016949	1.55593197	Salidesulfovibrio onnuriiensis	2583823	Bacteria	Bacteria	45.4	0.0012	NR	WP_147822621.1	2583823	g17839	i0	58.6	0.568627450980392	29	11	56.9	1	148	62	413	440	WP_147822621.1 thiamine pyridinylase [Salidesulfovibrio onnuriiensis]	diamond	87	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Salidesulfovibrio	Salidesulfovibrio onnuriiensis

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