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

9 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
2992548	2992548	PRJNA453567_P_NODE_34083_length_150_cov_1.380531_g33846_i0	PRJNA453567	34083	150	1.380531	2.0707965	Nannocystis punicea	2995304	Bacteria	Bacteria	111	1.99e-20	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g33846	i0	80.263	1.01333333333333	152	26	100	4	1	150	5060368	5060517	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	152	111	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
6196466	6196466	PRJNA453567_P_NODE_8625_length_328_cov_1.859107_g8388_i0	PRJNA453567	8625	328	1.859107	6.09787096	Myxococcus	32	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g8388	i0	100	0.170731707317073	28	0	9	0	76	103	7766203	7766176	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
10645680	10645680	PRJNA453567_P_NODE_21129_length_192_cov_1.251613_g20892_i0	PRJNA453567	21129	192	1.251613	2.40309696	Myxococcus fulvus	33	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g20892	i0	94.286	0.182291666666667	35	1	18	1	26	60	2072095	2072128	Myxococcus fulvus 124B02, complete genome	blastn	35	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
10645787	10645787	PRJNA453567_P_NODE_5689_length_423_cov_4.989637_g5453_i0	PRJNA453567	5689	423	4.989637	21.10616451	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	281	4.77e-71	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g5453	i0	84.014	64.0212765957447	294	45	69	2	17	309	4197851	4198143	Anaeromyxobacter oryzae DNA, complete genome	blastn	27081	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
15744480	15744480	PRJNA453567_P_NODE_28173_length_165_cov_1.218750_g27936_i0	PRJNA453567	28173	165	1.21875	2.0109375	Archangium violaceum	83451	Bacteria	Bacteria	117	4.82e-22	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g27936	i0	83.594	6.4969696969697	128	17	76	3	40	165	1834723	1834848	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	1072	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
15744535	15744535	PRJNA453567_P_NODE_593_length_1446_cov_4.667140_g544_i0	PRJNA453567	593	1446	4.66714	67.4868444	Chondromyces crocatus	52	Bacteria	Bacteria	651	0	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g544	i0	76.667	51.8845089903181	1260	243	85	42	211	1446	2787231	2785999	Chondromyces crocatus strain Cm c5, complete genome	blastn	75025	651	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
19567737	19567737	PRJNA453567_P_NODE_8536_length_330_cov_2.003413_g8299_i0	PRJNA453567	8536	330	2.003413	6.6112629	Corallococcus exercitus	2316736	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g8299	i0	100	0.0909090909090909	30	0	9	0	247	276	9871371	9871400	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
24045287	24045287	PRJNA453567_P_NODE_29319_length_162_cov_1.072000_g29082_i0	PRJNA453567	29319	162	1.072	1.73664	Archangium	47	Bacteria	Bacteria	58.4	2.9e-4	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g29082	i0	92.5	0.851851851851852	40	3	25	0	86	125	10727889	10727850	Archangium gephyra strain DSM 2261, complete genome	blastn	138	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
25319647	25319647	PRJNA453567_P_NODE_4600_length_487_cov_1.726667_g4367_i0	PRJNA453567	4600	487	1.726667	8.40886829	Sorangium	39643	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g4367	i0	100	0.127310061601643	31	0	6	0	296	326	481512	481482	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	62	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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