metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax_phylum = "Myxococcota"

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
319227	319227	PRJNA1182301_P_NODE_60461_length_243_cov_0.905882_g60336_i0	PRJNA1182301	60461	243	0.905882	2.20129326	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	226	1.2199999999999999e-54	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g60336	i0	84.649	94.7860082304527	228	33	93	2	2	228	7910062	7910288	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	23033	226	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
1592848	1592848	PRJNA1182301_P_NODE_19082_length_290_cov_1.728111_g18957_i0	PRJNA1182301	19082	290	1.728111	5.0115219	Sorangium cellulosum	56	Bacteria	Bacteria	163	1.19e-35	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g18957	i0	77.397	2.50689655172414	292	54	99	11	1	286	6390318	6390603	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	727	163	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3591871	3591871	PRJNA1182301_P_NODE_20763_length_288_cov_1.297674_g20638_i0	PRJNA1182301	20763	288	1.297674	3.73730112	Corallococcus	83461	Bacteria	Bacteria	505	1.7e-138	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g20638	i0	98.264	58.1631944444444	288	5	100	0	1	288	5437413	5437700	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	16751	510	0.990196078431373	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
6144657	6144657	PRJNA1182301_P_NODE_60945_length_242_cov_2.680473_g60820_i0	PRJNA1182301	60945	242	2.680473	6.48674466	Sorangium	39643	Bacteria	Bacteria	387	5.26e-103	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g60820	i0	95.455	6.09090909090909	242	11	100	0	1	242	7817925	7817684	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	1474	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6696186	6696186	PRJNA1182301_P_NODE_24646_length_282_cov_2.153110_g24521_i0	PRJNA1182301	24646	282	2.15311	6.0717702	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	104	7.08e-18	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g24521	i0	77.128	6.02482269503546	188	37	66	6	5	189	2503389	2503205	Anaeromyxobacter oryzae DNA, complete genome	blastn	1699	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
6696982	6696982	PRJNA1182301_P_NODE_57786_length_245_cov_0.895349_g57661_i0	PRJNA1182301	57786	245	0.895349	2.19360505	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	283	7.2e-72	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g57661	i0	87.805	22.8489795918367	246	24	99	5	3	245	3068756	3068998	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	5598	283	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
9969849	9969849	PRJNA1182301_P_NODE_53308_length_248_cov_0.880000_g53183_i0	PRJNA1182301	53308	248	0.88	2.1824	Archangium	47	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g53183	i0	96.774	9.92741935483871	248	8	100	0	1	248	6650223	6649976	Archangium gephyra strain DSM 2261, complete genome	blastn	2462	414	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
11797204	11797204	PRJNA1182301_P_NODE_36210_length_267_cov_1.453608_g36085_i0	PRJNA1182301	36210	267	1.453608	3.88113336	Pendulispora albinea	2741071	Bacteria	Bacteria	178	3.86e-40	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g36085	i0	83.077	53.6404494382022	195	33	73	0	7	201	8997151	8997345	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	14322	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15621692	15621692	PRJNA1182301_P_NODE_49753_length_250_cov_1.740113_g49628_i0	PRJNA1182301	49753	250	1.740113	4.3502825	Cystobacter fuscus	43	Bacteria	Bacteria	313	9.41e-81	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g49628	i0	89.243	36.976	251	25	100	2	1	250	5803572	5803323	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	9244	313	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
15622136	15622136	PRJNA1182301_P_NODE_68313_length_213_cov_4.671429_g68188_i0	PRJNA1182301	68313	213	4.671429	9.95014377	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	270	4.75e-68	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g68188	i0	89.623	4.76525821596244	212	22	99	0	2	213	2262995	2263206	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	1015	270	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
16896578	16896578	PRJNA1182301_P_NODE_9954_length_347_cov_2.160584_g9829_i0	PRJNA1182301	9954	347	2.160584	7.49722648	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	206	2.38e-48	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g9829	i0	84.951	69.2651296829971	206	27	59	4	19	222	6142703	6142500	Corallococcus sp. EGB chromosome, complete genome	blastn	24035	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
20719758	20719758	PRJNA1182301_P_NODE_28857_length_276_cov_3.339901_g28732_i0	PRJNA1182301	28857	276	3.339901	9.21812676	Labilithrix luteola	1391654	Bacteria	Bacteria	324	4.87e-84	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g28732	i0	88.087	127.79347826087	277	28	99	5	4	276	3943371	3943096	Labilithrix luteola strain DSM 27648, complete genome	blastn	35271	324	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21995266	21995266	PRJNA1182301_P_NODE_36158_length_267_cov_1.582474_g36033_i0	PRJNA1182301	36158	267	1.582474	4.22520558	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	348	2.78e-91	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g36033	i0	91.051	0.962546816479401	257	23	96	0	5	261	1071161	1071417	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	257	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5

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