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

10 rows where analysis = "blastn", bioproject = "PRJNA603943" 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
576467	576467	PRJNA603943_P_NODE_14301_length_436_cov_2.683196_g14109_i0	PRJNA603943	14301	436	2.683196	11.69873456	Archangium violaceum	83451	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g14109	i0	100	0.0642201834862385	28	0	6	0	185	212	2601184	2601157	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
577937	577937	PRJNA603943_P_NODE_65581_length_244_cov_0.900585_g65389_i0	PRJNA603943	65581	244	0.900585	2.1974274	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	75	4.7e-9	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g65389	i0	92.308	0.758196721311475	52	4	21	0	193	244	700754	700703	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	185	75	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435
1143331	1143331	PRJNA603943_P_NODE_9361_length_519_cov_1.573991_g9172_i0	PRJNA603943	9361	519	1.573991	8.16901329	Pseudomonadati	3379134	Bacteria	Bacteria	409	2.62e-109	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g9172	i0	81.548	30.1541425818882	504	85	96	8	20	519	931149	931648	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	15650	411	0.995133819951338	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
1853828	1853828	PRJNA603943_P_NODE_68682_length_242_cov_0.911243_g68490_i0	PRJNA603943	68682	242	0.911243	2.20520806	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	121	5.889999999999999e-23	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g68490	i0	81.507	1.88842975206612	146	27	60	0	96	241	1435300	1435155	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	457	121	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
4404458	4404458	PRJNA603943_P_NODE_24804_length_353_cov_1.496429_g24612_i0	PRJNA603943	24804	353	1.496429	5.28239437	Myxococcus stipitatus	83455	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g24612	i0	100	0.0793201133144476	28	0	8	0	52	79	3341748	3341775	Myxococcus stipitatus DSM 14675, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
7520826	7520826	PRJNA603943_P_NODE_10846_length_489_cov_1.122596_g10655_i0	PRJNA603943	10846	489	1.122596	5.48949444	Myxococcia	32015	Bacteria	Bacteria	595	1.7599999999999994e-165	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10655	i0	88.664	113.552147239264	494	48	100	7	1	489	7915349	7915839	Labilithrix luteola strain DSM 27648, complete genome	blastn	55527	595	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17155811	17155811	PRJNA603943_P_NODE_69374_length_241_cov_0.916667_g69182_i0	PRJNA603943	69374	241	0.916667	2.20916747	Pendulispora albinea	2741071	Bacteria	Bacteria	248	2.58e-61	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g69182	i0	85.417	94.1991701244813	240	33	99	2	3	241	9539008	9538770	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	22702	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
18429257	18429257	PRJNA603943_P_NODE_41555_length_286_cov_1.446009_g41363_i0	PRJNA603943	41555	286	1.446009	4.13558574	Cystobacter fuscus	43	Bacteria	Bacteria	204	6.899999999999999e-48	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g41363	i0	80.827	4.98601398601399	266	46	92	4	17	278	11595078	11594814	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	1426	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
20979696	20979696	PRJNA603943_P_NODE_4777_length_687_cov_2.338762_g4597_i0	PRJNA603943	4777	687	2.338762	16.06729494	Labilithrix luteola	1391654	Bacteria	Bacteria	815	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4597	i0	88.227	124.672489082969	688	74	99	6	4	687	3942500	3941816	Labilithrix luteola strain DSM 27648, complete genome	blastn	85650	815	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23530423	23530423	PRJNA603943_P_NODE_63719_length_245_cov_0.895349_g63527_i0	PRJNA603943	63719	245	0.895349	2.19360505	Labilithrix luteola	1391654	Bacteria	Bacteria	150	7.62e-32	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g63527	i0	85.235	1.06938775510204	149	19	60	3	1	148	8255082	8255228	Labilithrix luteola strain DSM 27648, complete genome	blastn	262	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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