metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax

5 rows where analysis = "blastn", 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
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

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