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

6 rows where analysis = "blastn", bioproject = "PRJEB10140" 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
982411	982411	PRJEB10140_P_NODE_98721_length_371_cov_1.394410_g81424_i0	PRJEB10140	98721	371	1.39441	5.1732611	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2007129425\|gb\|CP061799.1\|	45656	g81424	i0	100	0.159029649595687	28	0	8	0	36	63	2882761	2882788	Desulfonema limicola strain 5ac10 chromosome, complete genome	blastn	59	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema limicola
3838625	3838625	PRJEB10140_P_NODE_251584_length_168_cov_0.873950_g234275_i0	PRJEB10140	251584	168	0.87395	1.468236	Desulfobulbus oralis	1986146	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g234275	i0	100	2.08333333333333	168	0	100	0	1	168	244955	244788	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	350	311	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis
4809936	4809936	PRJEB10140_P_NODE_122984_length_298_cov_1.044177_g105677_i0	PRJEB10140	122984	298	1.044177	3.11164746	Desulfovibrio	872	Bacteria	Bacteria	67.6	9.89e-7	NTclustered	gi\|2419088003\|gb\|CP087381.1\|	2718620	g105677	i0	81.395	1.16778523489933	86	12	28	3	160	242	3376095	3376011	Desulfovibrio subterraneus strain ND17 chromosome, complete genome	blastn	348	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio subterraneus
5115288	5115288	PRJEB10140_P_NODE_285365_length_163_cov_0.868421_g268056_i0	PRJEB10140	285365	163	0.868421	1.41552623	Desulfarculia bacterium	3065862	Bacteria	Bacteria	178	2.1499999999999993e-40	NTclustered	gi\|2621701822\|emb\|OY759352.1\|	3065862	g268056	i0	88.435	3.96932515337423	147	17	90	0	9	155	1428377	1428231	MAG: Desulfarculia bacterium isolate c1361fd1-6016-418c-9b2d-a8e9625d1ec5 genome assembly, chromosome: 2	blastn	647	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
11489686	11489686	PRJEB10140_P_NODE_151230_length_245_cov_3.030612_g133922_i0	PRJEB10140	151230	245	3.030612	7.4249994	Pseudodesulfovibrio sediminis	2810563	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2105309617\|dbj\|AP024485.1\|	2810563	g133922	i0	100	0.114285714285714	28	0	11	0	30	57	184852	184879	Pseudodesulfovibrio sediminis SF6 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sediminis
19137240	19137240	PRJEB10140_P_NODE_162316_length_231_cov_1.835165_g145008_i0	PRJEB10140	162316	231	1.835165	4.23923115	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2621704594\|emb\|OY762999.1\|	2795000	g145008	i0	100	0.121212121212121	28	0	12	0	108	135	2072136	2072109	MAG: Maridesulfovibrio sp. isolate 1888eafc-ae4b-4acd-80f7-aa433ab4c246 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.

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