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

10 rows where analysis = "blastn", bioproject = "PRJNA1129273" 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
283257	283257	PRJNA1129273_P_NODE_4681_length_330_cov_1.202335_g4401_i0	PRJNA1129273	4681	330	1.202335	3.9677055	Labilithrix luteola	1391654	Bacteria	Bacteria	492	1.54e-134	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4401	i0	93.617	144.445454545455	329	21	99	0	1	329	7090462	7090134	Labilithrix luteola strain DSM 27648, complete genome	blastn	47667	492	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2833912	2833912	PRJNA1129273_P_NODE_2403_length_501_cov_3.703271_g2127_i0	PRJNA1129273	2403	501	3.703271	18.55338771	Sorangium cellulosum	56	Bacteria	Bacteria	542	2.38e-149	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g2127	i0	86.444	122.61876247505	509	52	99	14	1	499	4849408	4849909	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	61432	542	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5386421	5386421	PRJNA1129273_P_NODE_10065_length_244_cov_1.040936_g9785_i0	PRJNA1129273	10065	244	1.040936	2.53988384	Labilithrix luteola	1391654	Bacteria	Bacteria	265	2.6e-66	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9785	i0	86.42	371.295081967213	243	32	99	1	2	243	7089278	7089036	Labilithrix luteola strain DSM 27648, complete genome	blastn	90596	265	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7936305	7936305	PRJNA1129273_P_NODE_6807_length_275_cov_3.554455_g6527_i0	PRJNA1129273	6807	275	3.554455	9.77475125	Labilithrix luteola	1391654	Bacteria	Bacteria	331	2.9000000000000006e-86	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6527	i0	88.489	18.6945454545455	278	26	99	4	2	275	7915569	7915844	Labilithrix luteola strain DSM 27648, complete genome	blastn	5141	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9211308	9211308	PRJNA1129273_P_NODE_9808_length_245_cov_1.790698_g9528_i0	PRJNA1129273	9808	245	1.790698	4.3872101	Cystobacter fuscus	43	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g9528	i0	82.192	2.12244897959184	219	39	89	0	2	220	7100432	7100650	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	520	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
9959771	9959771	PRJNA1129273_P_NODE_2848_length_447_cov_2.874332_g2569_i0	PRJNA1129273	2848	447	2.874332	12.84826404	Pseudomonadati	3379134	Bacteria	Bacteria	507	7.68e-139	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g2569	i0	89.383	161.780760626398	405	40	90	3	2	404	857	1260	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	72316	507	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11761865	11761865	PRJNA1129273_P_NODE_5390_length_305_cov_1.099138_g5110_i0	PRJNA1129273	5390	305	1.099138	3.3523709	Sorangium cellulosum	56	Bacteria	Bacteria	339	1.95e-88	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g5110	i0	86.928	82.7672131147541	306	34	99	5	2	304	610	912	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	25244	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13785001	13785001	PRJNA1129273_P_NODE_1591_length_648_cov_4.833043_g1327_i0	PRJNA1129273	1591	648	4.833043	31.31811864	Polyangiaceae	49	Bacteria	Bacteria	761	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1327	i0	88.18	124.873456790123	643	70	98	6	2	639	1422	2063	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	80918	761	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
13785019	13785019	PRJNA1129273_P_NODE_7271_length_268_cov_1.753846_g6991_i0	PRJNA1129273	7271	268	1.753846	4.70030728	Myxococcaceae	31	Bacteria	Bacteria	327	3.64e-85	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g6991	i0	88.806	189.026119402985	268	28	99	2	1	267	837	571	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	50659	327	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
20158107	20158107	PRJNA1129273_P_NODE_9836_length_245_cov_1.389535_g9556_i0	PRJNA1129273	9836	245	1.389535	3.40436075	Stigmatella	40	Bacteria	Bacteria	394	3.189999999999999e-105	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g9556	i0	95.885	248.367346938776	243	10	99	0	2	244	838	1080	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	60850	394	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca

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