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

9 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
1494300	1494300	PRJNA1112809_P_NODE_157562_length_256_cov_2.437158_g154287_i0	PRJNA1112809	157562	256	2.437158	6.23912448	Geomonas paludis	2740185	Bacteria	Bacteria	272	1.64e-68	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g154287	i0	85.938	89.48828125	256	34	99	2	1	255	553862	553608	Geomonas paludis strain RG22 chromosome, complete genome	blastn	22909	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
9147830	9147830	PRJNA1112809_P_NODE_189088_length_242_cov_1.544379_g185813_i0	PRJNA1112809	189088	242	1.544379	3.73739718	Desulfomicrobium baculatum	899	Bacteria	Bacteria	196	9.52e-46	NTclustered	gi\|256576994\|gb\|CP001629.1\|	525897	g185813	i0	82.379	2.73140495867769	227	38	93	2	1	226	2829180	2829405	Desulfomicrobium baculatum DSM 4028, complete genome	blastn	661	196	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
10422845	10422845	PRJNA1112809_P_NODE_141569_length_272_cov_1.306533_g138294_i0	PRJNA1112809	141569	272	1.306533	3.5537697600000002	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	331	2.86e-86	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g138294	i0	88.603	3.82352941176471	272	31	100	0	1	272	3131627	3131356	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	1040	331	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
11697796	11697796	PRJNA1112809_P_NODE_127310_length_287_cov_2.799065_g124035_i0	PRJNA1112809	127310	287	2.799065	8.03331655	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	108	5.58e-19	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g124035	i0	79.47	20.9268292682927	151	31	53	0	10	160	1979492	1979342	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	6006	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
16796381	16796381	PRJNA1112809_P_NODE_137174_length_276_cov_2.773399_g133899_i0	PRJNA1112809	137174	276	2.773399	7.65458124	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	472	1.64e-128	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g133899	i0	97.464	344.445652173913	276	7	100	0	1	276	2625547	2625272	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	95067	472	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
17601323	17601323	PRJNA1112809_P_NODE_77194_length_392_cov_2.539185_g73919_i0	PRJNA1112809	77194	392	2.539185	9.9536052	Desulfomicrobium	898	Bacteria	Bacteria	438	2.459999999999999e-118	NTclustered	gi\|470484403\|ref\|NR_076646.1\|	899	g73919	i0	90.881	185.566326530612	329	27	99	3	63	390	43	369	Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence	blastn	72742	438	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
20620547	20620547	PRJNA1112809_P_NODE_147437_length_266_cov_1.450777_g144162_i0	PRJNA1112809	147437	266	1.450777	3.85906682	Geoalkalibacter halelectricus	2847045	Bacteria	Bacteria	165	2.99e-36	NTclustered	gi\|2304895958\|gb\|CP092109.1\|	2847045	g144162	i0	78.03	50.4624060150376	264	56	99	2	1	263	2573890	2574152	Geoalkalibacter halelectricus strain SAP-1 chromosome	blastn	13423	165	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
22700089	22700089	PRJNA1112809_P_NODE_130278_length_284_cov_1.459716_g127003_i0	PRJNA1112809	130278	284	1.459716	4.14559344	Geomonas	2651583	Bacteria	Bacteria	58.4	5.64e-4	NTclustered	gi\|2060227305\|gb\|CP077683.1\|	2847989	g127003	i0	100	0.327464788732394	31	0	11	0	219	249	822686	822716	Geomonas subterranea strain RG2 chromosome, complete genome	blastn	93	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas subterranea
24444991	24444991	PRJNA1112809_P_NODE_118740_length_299_cov_1.283186_g115465_i0	PRJNA1112809	118740	299	1.283186	3.83672614	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	174	5.69e-39	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g115465	i0	79.07	1.87290969899666	258	50	86	4	24	279	396139	395884	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	560	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS

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