metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA859990" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA859990" 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
11049582	11049582	PRJNA859990_S_NODE_22209_length_241_cov_0.916667_g21948_i0	PRJNA859990	22209	241	0.916667	2.20916747	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	300	7.02e-77	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g21948	i0	97.175	1.46887966804979	177	5	73	0	65	241	710465	710641	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	354	300	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
12325043	12325043	PRJNA859990_S_NODE_16530_length_258_cov_2.972973_g16269_i0	PRJNA859990	16530	258	2.972973	7.67027034	Geobacter sulfurreducens	35554	Bacteria	Bacteria	355	1.6e-93	NTclustered	gi\|2045533567\|gb\|CP074693.1\|	35554	g16269	i0	91.506	9.0077519379845	259	20	100	2	1	258	1181636	1181893	Geobacter sulfurreducens strain YM35 chromosome, complete genome	blastn	2324	355	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
12715705	12715705	PRJNA859990_S_NODE_23670_length_213_cov_5.014286_g23409_i0	PRJNA859990	23670	213	5.014286	10.68042918	Geobacter	28231	Bacteria	Bacteria	357	3.55e-94	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g23409	i0	97.156	28.6572769953052	211	6	99	0	1	211	1478828	1478618	Geobacter sulfurreducens strain AM-1 genome	blastn	6104	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
17813703	17813703	PRJNA859990_S_NODE_7534_length_363_cov_2.165517_g7273_i0	PRJNA859990	7534	363	2.165517	7.86082671	Solidesulfovibrio	2910984	Bacteria	Bacteria	593	4.559999999999998e-165	NTclustered	gi\|470475467\|ref\|NR_076282.1\|	184917	g7273	i0	96.154	287.796143250689	364	13	100	1	1	363	1461	1098	Desulfovibrio magneticus strain RS-1 23S ribosomal RNA gene, complete sequence	blastn	104470	593	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
19087507	19087507	PRJNA859990_S_NODE_12795_length_289_cov_1.893519_g12534_i0	PRJNA859990	12795	289	1.893519	5.47226991	Geobacter	28231	Bacteria	Bacteria	435	2.27e-117	NTclustered	gi\|1373812086\|dbj\|AP017912.1\|	35554	g12534	i0	93.793	9.03114186851211	290	16	100	2	1	289	3664247	3663959	Geobacter sulfurreducens DNA, complete genome	blastn	2610	435	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
21638311	21638311	PRJNA859990_S_NODE_9417_length_330_cov_0.887160_g9156_i0	PRJNA859990	9417	330	0.88716	2.927628	Geobacter	28231	Bacteria	Bacteria	351	2.74e-92	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g9156	i0	90.11	7.43636363636364	273	23	82	4	59	330	2234588	2234857	Geobacter sulfurreducens strain AM-1 genome	blastn	2454	351	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
23798048	23798048	PRJNA859990_S_NODE_15379_length_267_cov_1.190722_g15118_i0	PRJNA859990	15379	267	1.190722	3.17922774	Geobacter sulfurreducens	35554	Bacteria	Bacteria	427	3.47e-115	NTclustered	gi\|1373812086\|dbj\|AP017912.1\|	35554	g15118	i0	95.506	9	267	12	100	0	1	267	3664403	3664137	Geobacter sulfurreducens DNA, complete genome	blastn	2403	427	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
25462781	25462781	PRJNA859990_S_NODE_19640_length_246_cov_1.826590_g19379_i0	PRJNA859990	19640	246	1.82659	4.4934114	Solidesulfovibrio	2910984	Bacteria	Bacteria	394	3.2e-105	NTclustered	gi\|470475467\|ref\|NR_076282.1\|	184917	g19379	i0	95.528	214.878048780488	246	11	100	0	1	246	1073	828	Desulfovibrio magneticus strain RS-1 23S ribosomal RNA gene, complete sequence	blastn	52860	394	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
25462872	25462872	PRJNA859990_S_NODE_6520_length_387_cov_49.079618_g6259_i0	PRJNA859990	6520	387	49.079618	189.93812166	Geobacter	28231	Bacteria	Bacteria	627	4.829999999999999e-175	NTclustered	gi\|2499315885\|dbj\|AP028061.1\|	1260928	g6259	i0	99.422	14.2273901808786	346	1	89	1	2	347	2127805	2128149	Geobacter sulfurreducens subsp. ethanolicus OSK2A DNA, complete genome	blastn	5506	627	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens

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