metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax

10 rows where analysis = "blastn", bioproject = "PRJDB4941" 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
3532272	3532272	PRJDB4941_P_NODE_33523_length_170_cov_1.719008_g32755_i0	PRJDB4941	33523	170	1.719008	2.9223136	Pseudomonadati	3379134	Bacteria	Bacteria	58.4	3.06e-4	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g32755	i0	97.059	0.9	34	1	20	0	126	159	1374482	1374449	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	153	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
3836614	3836614	PRJDB4941_P_NODE_33424_length_170_cov_2.363636_g32656_i0	PRJDB4941	33424	170	2.363636	4.0181812	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	141	2.95e-29	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g32656	i0	86.364	28.4529411764706	132	14	76	4	41	170	1735533	1735404	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	4837	141	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7359243	7359243	PRJDB4941_P_NODE_21866_length_217_cov_1.523810_g21098_i0	PRJDB4941	21866	217	1.52381	3.3066677	Anaeromyxobacter	161492	Bacteria	Bacteria	167	6.56e-37	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g21098	i0	84.524	4.64516129032258	168	26	77	0	45	212	2938822	2938989	Anaeromyxobacter sp. K, complete genome	blastn	1008	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
10213275	10213275	PRJDB4941_P_NODE_33209_length_171_cov_1.696721_g32441_i0	PRJDB4941	33209	171	1.696721	2.90139291	Sorangium cellulosum	56	Bacteria	Bacteria	122	1.0799999999999999e-23	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g32441	i0	81.169	0.900584795321637	154	27	89	2	5	157	11576940	11577092	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	154	122	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16284289	16284289	PRJDB4941_P_NODE_31373_length_177_cov_1.492188_g30605_i0	PRJDB4941	31373	177	1.492188	2.64117276	Myxococcus	32	Bacteria	Bacteria	147	6.669999999999999e-31	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g30605	i0	82.353	23.4406779661017	170	28	95	2	6	174	8195320	8195488	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4149	147	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
16587337	16587337	PRJDB4941_P_NODE_33534_length_170_cov_1.719008_g32766_i0	PRJDB4941	33534	170	1.719008	2.9223136	Sorangium cellulosum	56	Bacteria	Bacteria	104	3.87e-18	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g32766	i0	77.647	1	170	38	100	0	1	170	9977539	9977708	Sorangium cellulosum 'So ce 56' complete genome	blastn	170	104	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19135565	19135565	PRJDB4941_P_NODE_12216_length_315_cov_1.447368_g11448_i0	PRJDB4941	12216	315	1.447368	4.5592092	Nannocystis punicea	2995304	Bacteria	Bacteria	141	6.12e-29	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g11448	i0	85.926	0.428571428571429	135	15	42	3	79	211	207038	207170	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	135	141	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
19135832	19135832	PRJDB4941_P_NODE_24696_length_203_cov_0.863636_g23928_i0	PRJDB4941	24696	203	0.863636	1.75318108	Labilithrix luteola	1391654	Bacteria	Bacteria	200	5.97e-47	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23928	i0	84.729	29.576354679803	203	28	100	1	1	203	7540577	7540776	Labilithrix luteola strain DSM 27648, complete genome	blastn	6004	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20411186	20411186	PRJDB4941_P_NODE_38677_length_164_cov_0.904348_g37909_i0	PRJDB4941	38677	164	0.904348	1.48313072	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	122	1.03e-23	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g37909	i0	87.619	1.28048780487805	105	13	64	0	48	152	458749	458853	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	210	122	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
24236543	24236543	PRJDB4941_P_NODE_7340_length_449_cov_2.532500_g6572_i0	PRJDB4941	7340	449	2.5325	11.370925	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	279	1.83e-70	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g6572	i0	80.769	6.03118040089087	364	64	80	6	89	449	2136370	2136730	Corallococcus sp. EGB chromosome, complete genome	blastn	2708	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB

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