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

9 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
2264535	2264535	PRJEB39269_P_NODE_37942_length_223_cov_2.831522_g37537_i0	PRJEB39269	37942	223	2.831522	6.31429406	root	1	Root_unresolved	Root_unresolved	228	3.0599999999999992e-55	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g37537	i0	85.398	232.991031390135	226	26	100	6	1	223	1181	1402	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	51957	230	0.991304347826087	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7366847	7366847	PRJEB39269_P_NODE_75966_length_162_cov_1.284553_g75561_i0	PRJEB39269	75966	162	1.284553	2.08097586	Archangium	47	Bacteria	Bacteria	261	2.06e-65	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g75561	i0	95.679	228.456790123457	162	7	100	0	1	162	5101532	5101371	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	37010	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
11535232	11535232	PRJEB39269_P_NODE_31730_length_245_cov_5.645631_g31325_i0	PRJEB39269	31730	245	5.645631	13.83179595	Sorangium cellulosum	56	Bacteria	Bacteria	231	2.65e-56	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g31325	i0	84.064	56.2897959183673	251	28	99	11	2	245	4849444	4849689	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	13791	231	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16633913	16633913	PRJEB39269_P_NODE_51434_length_191_cov_2.756579_g51029_i0	PRJEB39269	51434	191	2.756579	5.26506589	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	176	9.34e-40	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g51029	i0	84.324	96.8848167539267	185	23	96	4	1	183	1549577	1549397	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	18505	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
16633922	16633922	PRJEB39269_P_NODE_64534_length_172_cov_1.827068_g64129_i0	PRJEB39269	64534	172	1.827068	3.14255696	Nannocystis sp.	1962667	Bacteria	Bacteria	248	1.71e-61	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g64129	i0	92.529	2.01744186046512	174	11	100	2	1	172	18	191	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	347	248	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
17567129	17567129	PRJEB39269_P_NODE_8874_length_465_cov_3.826291_g8476_i0	PRJEB39269	8874	465	3.826291	17.79225315	Polyangiaceae	49	Bacteria	Bacteria	616	1.2799999999999996e-171	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g8476	i0	90.538	162.387096774194	465	44	100	0	1	465	11965039	11964575	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	75510	621	0.99194847020934	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17908658	17908658	PRJEB39269_P_NODE_15395_length_357_cov_8.069182_g14990_i0	PRJEB39269	15395	357	8.069182	28.80697974	Sorangium cellulosum	56	Bacteria	Bacteria	361	4.94e-95	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g14990	i0	85.165	74.7114845938375	364	40	99	12	1	356	4849801	4849444	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	26672	361	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23009153	23009153	PRJEB39269_P_NODE_85439_length_154_cov_2.991304_g85034_i0	PRJEB39269	85439	154	2.991304	4.60660816	Labilithrix luteola	1391654	Bacteria	Bacteria	119	1.23e-22	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g85034	i0	82.353	0.883116883116883	136	24	88	0	19	154	8372064	8371929	Labilithrix luteola strain DSM 27648, complete genome	blastn	136	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24282840	24282840	PRJEB39269_P_NODE_46160_length_202_cov_1.141104_g45755_i0	PRJEB39269	46160	202	1.141104	2.30503008	Chondromyces crocatus	52	Bacteria	Bacteria	178	2.7799999999999993e-40	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g45755	i0	89.437	97.0148514851485	142	14	70	1	1	141	2685	2826	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	19597	178	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus

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