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

9 rows where analysis = "blastn", bioproject = "PRJNA642647" 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
3168792	3168792	PRJNA642647_P_NODE_1123_length_333_cov_4.854730_g1073_i0	PRJNA642647	1123	333	4.85473	16.1662509	Labilithrix luteola	1391654	Bacteria	Bacteria	516	9.26e-142	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1073	i0	94.848	142.621621621622	330	17	99	0	4	333	3942534	3942863	Labilithrix luteola strain DSM 27648, complete genome	blastn	47493	516	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4445696	4445696	PRJNA642647_P_NODE_5364_length_164_cov_1.929134_g5314_i0	PRJNA642647	5364	164	1.929134	3.16377976	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	158	2.82e-34	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g5314	i0	88.148	315.341463414634	135	13	81	3	31	163	8617341	8617474	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	51716	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
10822208	10822208	PRJNA642647_P_NODE_2869_length_206_cov_1.792899_g2819_i0	PRJNA642647	2869	206	1.792899	3.69337194	Labilithrix luteola	1391654	Bacteria	Bacteria	309	9.68e-80	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2819	i0	94.089	238.461165048544	203	12	99	0	1	203	3942258	3942056	Labilithrix luteola strain DSM 27648, complete genome	blastn	49123	309	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12097424	12097424	PRJNA642647_P_NODE_4290_length_175_cov_1.072464_g4240_i0	PRJNA642647	4290	175	1.072464	1.876812	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	279	6.21e-71	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g4240	i0	95.93	76.8057142857143	172	7	98	0	1	172	8615902	8616073	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	13441	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13372000	13372000	PRJNA642647_P_NODE_1651_length_270_cov_2.051502_g1601_i0	PRJNA642647	1651	270	2.051502	5.5390554	Stigmatella aurantiaca	41	Bacteria	Bacteria	246	1.06e-60	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g1601	i0	84.706	215.307407407407	255	29	93	7	14	265	322	75	S.aurantiaca 23S rRNA gene	blastn	58133	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
13372040	13372040	PRJNA642647_P_NODE_5611_length_161_cov_0.862903_g5561_i0	PRJNA642647	5611	161	0.862903	1.38927383	Myxococcales bacterium	2026763	Bacteria	Bacteria	215	1.61e-51	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g5561	i0	91.139	191.354037267081	158	14	98	0	1	158	1309887	1309730	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	30808	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
13912545	13912545	PRJNA642647_P_NODE_3971_length_180_cov_3.545455_g3921_i0	PRJNA642647	3971	180	3.545455	6.381819	Pendulispora	3375062	Bacteria	Bacteria	161	2.43e-35	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3921	i0	92.174	158.783333333333	115	7	63	1	1	113	7287283	7287169	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	28581	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21020390	21020390	PRJNA642647_P_NODE_3757_length_184_cov_2.802721_g3707_i0	PRJNA642647	3757	184	2.802721	5.15700664	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	217	5.26e-52	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g3707	i0	88.398	100.527173913043	181	19	97	2	6	184	8616426	8616246	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	18497	217	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
22295099	22295099	PRJNA642647_P_NODE_5998_length_156_cov_1.100840_g5948_i0	PRJNA642647	5998	156	1.10084	1.7173104	Chondromyces crocatus	52	Bacteria	Bacteria	209	7.2e-50	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g5948	i0	91.503	259.820512820513	153	12	98	1	4	156	1404	1253	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	40532	209	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);;