metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
3345179	3345179	PRJNA799842_P_NODE_177823_length_243_cov_0.905882_g176250_i0	PRJNA799842	177823	243	0.905882	2.20129326	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	265	2.58e-66	NTclustered	gi\|2381092847\|gb\|CP113000.1\|	2202153	g176250	i0	87.045	1.25514403292181	247	17	96	5	9	241	947876	947631	MAG: Thermodesulfobacteriota bacterium isolate ORM2a chromosome, complete genome	blastn	305	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
5046855	5046855	PRJNA799842_P_NODE_133084_length_253_cov_0.850000_g131511_i0	PRJNA799842	133084	253	0.85	2.1505	Megalodesulfovibrio	2910978	Bacteria	Bacteria	209	1.29e-49	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g131511	i0	82.213	227.391304347826	253	36	97	7	1	245	2058	2309	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	57530	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
12273296	12273296	PRJNA799842_P_NODE_166310_length_245_cov_0.895349_g164737_i0	PRJNA799842	166310	245	0.895349	2.19360505	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	156	1.64e-33	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g164737	i0	90.678	39.530612244898	118	10	48	1	112	229	4028407	4028291	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	9685	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
14824286	14824286	PRJNA799842_P_NODE_90912_length_304_cov_1.333333_g89339_i0	PRJNA799842	90912	304	1.333333	4.05333232	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	268	2.58e-67	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g89339	i0	83.113	140.259868421053	302	43	98	7	6	303	2626642	2626345	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	42639	268	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
21196284	21196284	PRJNA799842_P_NODE_164137_length_246_cov_0.890173_g162564_i0	PRJNA799842	164137	246	0.890173	2.18982558	Geobacter metallireducens	28232	Bacteria	Bacteria	113	1e-20	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g162564	i0	86.408	0.719512195121951	103	14	42	0	127	229	693741	693843	Geobacter metallireducens GS-15, complete genome	blastn	177	113	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
24170428	24170428	PRJNA799842_P_NODE_149059_length_249_cov_0.875000_g147486_i0	PRJNA799842	149059	249	0.875	2.17875	Thermodesulfobacterium	1740	Bacteria	Bacteria	126	1.31e-24	NTclustered	gi\|668351138\|gb\|CP008796.1\|	289377	g147486	i0	97.297	43.8995983935743	74	2	30	0	1	74	942730	942657	Thermodesulfobacterium commune DSM 2178, complete genome	blastn	10931	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermodesulfobacterium	Thermodesulfobacterium commune

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