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

9 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
1936711	1936711	PRJNA682078_P_NODE_227842_length_250_cov_1.429379_g226065_i0	PRJNA682078	227842	250	1.429379	3.5734475	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g226065	i0	82.283	82.552	254	37	100	8	1	250	96021	95772	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	20638	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
5762167	5762167	PRJNA682078_P_NODE_141665_length_302_cov_1.930131_g139888_i0	PRJNA682078	141665	302	1.930131	5.82899562	Geobacter pickeringii	345632	Bacteria	Bacteria	132	3.5100000000000004e-26	NTclustered	gi\|747129828\|gb\|CP009788.1\|	345632	g139888	i0	78.788	1.23509933774834	198	40	65	2	58	254	864837	865033	Geobacter pickeringii strain G13, complete genome	blastn	373	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
13414692	13414692	PRJNA682078_P_NODE_229771_length_250_cov_0.870056_g227994_i0	PRJNA682078	229771	250	0.870056	2.17514	Taurinivorans muris	2787751	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g227994	i0	100	1	250	0	100	0	1	250	1405648	1405399	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	250	462	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
15962104	15962104	PRJNA682078_P_NODE_171133_length_280_cov_1.289855_g169356_i0	PRJNA682078	171133	280	1.289855	3.611594	Smithellaceae bacterium	2964540	Bacteria	Bacteria	351	2.27e-92	NTclustered	gi\|2626214512\|emb\|OY820932.1\|	2964540	g169356	i0	89.855	0.985714285714286	276	24	98	4	3	276	4423132	4423405	MAG: Smithellaceae bacterium isolate 90efb5c7-b315-4df1-98b9-9b59cc098579 genome assembly, chromosome: 1	blastn	276	351	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
15962502	15962502	PRJNA682078_P_NODE_187973_length_270_cov_1.365482_g186196_i0	PRJNA682078	187973	270	1.365482	3.6868014	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	213	1.07e-50	NTclustered	gi\|2891482193\|emb\|OZ219926.1\|	2202153	g186196	i0	82.171	93.5740740740741	258	36	95	8	1	257	776370	776122	MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3	blastn	25265	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
15965234	15965234	PRJNA682078_P_NODE_297913_length_227_cov_2.376623_g296136_i0	PRJNA682078	297913	227	2.376623	5.39493421	uncultured Desulfuromonas sp.	181013	Bacteria	Bacteria	193	1.14e-44	NTclustered	gi\|2621704006\|emb\|OY762961.1\|	181013	g296136	i0	83.333	0.92511013215859	210	33	92	2	19	227	802610	802402	MAG: uncultured Desulfuromonas sp. isolate cad01da2-5f99-43ef-8b90-e7e0a75d6a39 genome assembly, chromosome: 1	blastn	210	193	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	uncultured Desulfuromonas sp.
18514547	18514547	PRJNA682078_P_NODE_298515_length_226_cov_2.013072_g296738_i0	PRJNA682078	298515	226	2.013072	4.54954272	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	346	8.24e-91	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g296738	i0	98.469	4.75221238938053	196	3	87	0	31	226	152387	152582	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	1074	346	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
21064555	21064555	PRJNA682078_P_NODE_280917_length_242_cov_1.366864_g279140_i0	PRJNA682078	280917	242	1.366864	3.30781088	Taurinivorans muris	2787751	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g279140	i0	99.174	1	242	2	100	0	1	242	1605349	1605108	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	242	436	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
24124885	24124885	PRJNA682078_P_NODE_226759_length_250_cov_2.819209_g224982_i0	PRJNA682078	226759	250	2.819209	7.0480225	Desulfovibrio	872	Bacteria	Bacteria	407	4.1899999999999994e-109	NTclustered	gi\|470484020\|ref\|NR_076625.1\|	876	g224982	i0	96	211.54	250	10	100	0	1	250	248	497	Desulfovibrio desulfuricans subsp. desulfuricans strain ATCC 27774 23S ribosomal RNA gene, complete sequence	blastn	52885	407	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans

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