metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1167252" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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
2865451	2865451	PRJNA1167252_P_NODE_27183_length_246_cov_0.901734_g26910_i0	PRJNA1167252	27183	246	0.901734	2.21826564	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	333	7.089999999999999e-87	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g26910	i0	91.057	23.9430894308943	246	22	100	0	1	246	8530	8775	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	5890	333	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
5417639	5417639	PRJNA1167252_P_NODE_24065_length_251_cov_0.876404_g23792_i0	PRJNA1167252	24065	251	0.876404	2.19977404	Desulfosarcina widdelii	947919	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|1773416083\|dbj\|AP021875.1\|	947919	g23792	i0	93.227	1.95219123505976	251	17	100	0	1	251	5520102	5520352	Desulfosarcina widdelii PP31 DNA, complete genome	blastn	490	370	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
6142771	6142771	PRJNA1167252_P_NODE_21945_length_258_cov_0.929730_g21672_i0	PRJNA1167252	21945	258	0.92973	2.3987034	Thermodesulfobacteriota	200940	Bacteria	Bacteria	455	1.53e-123	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g21672	i0	98.45	15.9031007751938	258	4	100	0	1	258	3971907	3971650	Geobacter sulfurreducens strain AM-1 genome	blastn	4103	455	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
6692550	6692550	PRJNA1167252_P_NODE_28146_length_244_cov_0.912281_g27873_i0	PRJNA1167252	28146	244	0.912281	2.22596564	Desulfobulbus propionicus	894	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g27873	i0	100	1	244	0	100	0	1	244	2175259	2175016	Desulfobulbus propionicus DSM 2032, complete genome	blastn	244	451	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
7417700	7417700	PRJNA1167252_P_NODE_18386_length_284_cov_2.156398_g18113_i0	PRJNA1167252	18386	284	2.156398	6.12417032	Thermodesulfobacteriota	200940	Bacteria	Bacteria	272	1.8499999999999998e-68	NTclustered	gi\|470488362\|ref\|NR_076865.1\|	60893	g18113	i0	86.207	219.700704225352	261	25	90	10	1	257	28	281	Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence	blastn	62395	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
9968084	9968084	PRJNA1167252_P_NODE_26968_length_246_cov_0.901734_g26695_i0	PRJNA1167252	26968	246	0.901734	2.21826564	Geomonas	2651583	Bacteria	Bacteria	167	7.61e-37	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g26695	i0	79.116	12.7967479674797	249	46	100	6	1	246	376199	376444	Geomonas paludis strain RG22 chromosome, complete genome	blastn	3148	167	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
13068235	13068235	PRJNA1167252_P_NODE_26551_length_247_cov_0.896552_g26278_i0	PRJNA1167252	26551	247	0.896552	2.21448344	Desulfobulbus propionicus	894	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g26278	i0	100	2.34008097165992	247	0	100	0	1	247	1252181	1252427	Desulfobulbus propionicus DSM 2032, complete genome	blastn	578	457	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
16891619	16891619	PRJNA1167252_P_NODE_22974_length_253_cov_0.866667_g22701_i0	PRJNA1167252	22974	253	0.866667	2.19266751	Syntrophus buswellii	43774	Bacteria	Bacteria	433	7.02e-117	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g22701	i0	97.619	2.75098814229249	252	6	99	0	1	252	146523	146272	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	696	433	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
18166257	18166257	PRJNA1167252_P_NODE_27215_length_246_cov_0.867052_g26942_i0	PRJNA1167252	27215	246	0.867052	2.13294792	Desulfoglaeba alkanexedens	361111	Bacteria	Bacteria	353	5.44e-93	NTclustered	gi\|1649181537\|gb\|CP040098.1\|	980445	g26942	i0	92.713	1.00406504065041	247	14	100	2	1	246	210173	210416	Desulfoglaeba alkanexedens ALDC chromosome, complete genome	blastn	247	353	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulfoglaeba	Desulfoglaeba alkanexedens
19440488	19440488	PRJNA1167252_P_NODE_23876_length_251_cov_0.876404_g23603_i0	PRJNA1167252	23876	251	0.876404	2.19977404	Citrifermentans bemidjiense	225194	Bacteria	Bacteria	147	1.01e-30	NTclustered	gi\|197085762\|gb\|CP001124.1\|	404380	g23603	i0	78.571	3.32669322709163	224	47	89	1	29	251	2952236	2952459	Geobacter bemidjiensis Bem, complete genome	blastn	835	147	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bemidjiense
21991278	21991278	PRJNA1167252_P_NODE_26598_length_247_cov_0.896552_g26325_i0	PRJNA1167252	26598	247	0.896552	2.21448344	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g26325	i0	97.26	89.5101214574899	73	2	30	0	175	247	1573209	1573137	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	22109	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus

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