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

5 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
4007376	4007376	PRJNA1067370_P_NODE_49364_length_298_cov_1.244444_g48816_i0	PRJNA1067370	49364	298	1.244444	3.70844312	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	422	1.83e-113	NTclustered	gi\|2621785158\|emb\|OY781616.1\|	2795000	g48816	i0	92.282	290.852348993289	298	21	99	2	1	297	627482	627186	MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1	blastn	86674	422	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
5283867	5283867	PRJNA1067370_P_NODE_74245_length_258_cov_1.664865_g73696_i0	PRJNA1067370	74245	258	1.664865	4.2953517	Desulfovibrio mangrovi	2976983	Bacteria	Bacteria	398	2.62e-106	NTclustered	gi\|2330538096\|gb\|CP104208.1\|	2976983	g73696	i0	97.826	230.562015503876	230	5	89	0	29	258	1675691	1675920	Desulfovibrio mangrovi strain FT415 chromosome, complete genome	blastn	59485	398	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio mangrovi
7390864	7390864	PRJNA1067370_P_NODE_107766_length_243_cov_0.905882_g107217_i0	PRJNA1067370	107766	243	0.905882	2.20129326	Geobacter	28231	Bacteria	Bacteria	272	1.5399999999999998e-68	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g107217	i0	86.831	357.777777777778	243	32	100	0	1	243	2784467	2784709	Geobacter sulfurreducens strain AM-1 genome	blastn	86940	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
11659295	11659295	PRJNA1067370_P_NODE_19630_length_423_cov_3.988571_g19082_i0	PRJNA1067370	19630	423	3.988571	16.87165533	Desulfuromonas acetoxidans	891	Bacteria	Bacteria	351	3.59e-92	NTclustered	gi\|662020026\|ref\|NR_121913.1\|	891	g19082	i0	83.206	187.730496453901	393	56	91	9	37	423	1218	830	Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence	blastn	79410	351	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas acetoxidans
25239470	25239470	PRJNA1067370_P_NODE_16180_length_461_cov_2.141753_g15632_i0	PRJNA1067370	16180	461	2.141753	9.87348133	Pseudodesulfovibrio	2035811	Bacteria	Bacteria	545	1.68e-150	NTclustered	gi\|485099208\|ref\|NR_102600.1\|	879567	g15632	i0	88.121	446.1431670282	463	49	99	4	1	459	1339	1799	Desulfovibrio piezophilus strain C1TLV30 23S ribosomal RNA gene, complete sequence	blastn	205672	545	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio piezophilus

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