metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Synergistota"

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
1568061	1568061	PRJNA1148190_P_NODE_286722_length_325_cov_2.158730_g275551_i0	PRJNA1148190	286722	325	2.15873	7.0158725	Synergistota bacterium	2268202	Bacteria	Bacteria	147	1.36e-30	NTclustered	gi\|2041259188\|gb\|CP074691.1\|	2268202	g275551	i0	84.564	26.1938461538462	149	21	46	2	178	325	760388	760535	Synergistota bacterium strain L-13 chromosome, complete genome	blastn	8513	147	1	Bacteria	Thermotogati	Synergistota					Synergistota bacterium
2849114	2849114	PRJNA1148190_P_NODE_625003_length_249_cov_0.875000_g613830_i0	PRJNA1148190	625003	249	0.875	2.17875	Synergistaceae bacterium	2053624	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g613830	i0	97.581	0.995983935742972	248	6	99	0	2	249	604611	604858	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	248	425	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
4124475	4124475	PRJNA1148190_P_NODE_575504_length_252_cov_1.480447_g564331_i0	PRJNA1148190	575504	252	1.480447	3.73072644	Synergistaceae bacterium	2053624	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g564331	i0	97.619	1	252	6	100	0	1	252	945736	945485	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	252	433	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
9226886	9226886	PRJNA1148190_P_NODE_680488_length_246_cov_0.890173_g669315_i0	PRJNA1148190	680488	246	0.890173	2.18982558	Synergistaceae bacterium	2053624	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g669315	i0	90.909	0.983739837398374	242	22	98	0	1	242	697570	697811	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	242	326	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
9962472	9962472	PRJNA1148190_P_NODE_225908_length_358_cov_0.754386_g214738_i0	PRJNA1148190	225908	358	0.754386	2.70070188	Bacteria	2	Bacteria	Bacteria	115	4.26e-21	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g214738	i0	94.667	27.0391061452514	75	3	21	1	144	217	1452631	1452705	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	9680	115	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
10502108	10502108	PRJNA1148190_P_NODE_633309_length_249_cov_0.875000_g622136_i0	PRJNA1148190	633309	249	0.875	2.17875	Pyramidobacter piscolens	638849	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2188906985\|dbj\|AP025585.1\|	638849	g622136	i0	84.906	0.325301204819277	53	8	21	0	197	249	2417746	2417798	Pyramidobacter piscolens CE91-St28 DNA, complete genome	blastn	81	54.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
11774112	11774112	PRJNA1148190_P_NODE_419570_length_282_cov_1.818182_g408397_i0	PRJNA1148190	419570	282	1.818182	5.12727324	Thermovirga lienii	336261	Bacteria	Bacteria	82.4	3.32e-11	NTclustered	gi\|355396317\|gb\|CP003096.1\|	580340	g408397	i0	84.337	0.294326241134752	83	13	29	0	200	282	1670257	1670175	Thermovirga lienii DSM 17291, complete genome	blastn	83	82.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii

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