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

9 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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
4143036	4143036	PRJNA1174234_P_NODE_2624_length_794_cov_3.194175_g2456_i0	PRJNA1174234	2624	794	3.194175	25.3617495	Nannocystis punicea	2995304	Bacteria	Bacteria	357	1.51e-93	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g2456	i0	82.367	52.1448362720403	431	56	54	14	34	459	5377565	5377150	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	41403	357	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
8693900	8693900	PRJNA1174234_P_NODE_26007_length_269_cov_1.178571_g25811_i0	PRJNA1174234	26007	269	1.178571	3.17035599	Corallococcus	83461	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g25811	i0	100	240.921933085502	269	0	100	0	1	269	144314	144046	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	64808	497	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
12519616	12519616	PRJNA1174234_P_NODE_33290_length_245_cov_0.877907_g33094_i0	PRJNA1174234	33290	245	0.877907	2.15087215	Myxococcus	32	Bacteria	Bacteria	135	2.13e-27	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g33094	i0	88.393	13.7183673469388	112	13	46	0	131	242	8711847	8711736	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	3361	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
14345033	14345033	PRJNA1174234_P_NODE_14512_length_361_cov_3.138889_g14316_i0	PRJNA1174234	14512	361	3.138889	11.33138929	Pendulispora rubella	2741070	Bacteria	Bacteria	115	4.3e-21	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g14316	i0	85.981	30.0969529085873	107	15	30	0	73	179	10631087	10630981	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	10865	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
15068625	15068625	PRJNA1174234_P_NODE_2292_length_841_cov_2.667969_g2130_i0	PRJNA1174234	2292	841	2.667969	22.43761929	Sorangium	39643	Bacteria	Bacteria	819	0	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g2130	i0	84.271	123.378121284185	871	103	100	24	1	841	3449746	3448880	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	103761	822	0.996350364963504	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16893195	16893195	PRJNA1174234_P_NODE_2294_length_841_cov_2.299479_g2132_i0	PRJNA1174234	2294	841	2.299479	19.33861839	Chondromyces crocatus	52	Bacteria	Bacteria	1037	0	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g2132	i0	88.915	127.193816884661	848	85	100	8	1	841	1430422	1431267	Chondromyces crocatus strain Cm c5, complete genome	blastn	106970	1037	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
20717550	20717550	PRJNA1174234_P_NODE_35837_length_241_cov_0.916667_g35641_i0	PRJNA1174234	35837	241	0.916667	2.20916747	Corallococcus interemptor	2316720	Bacteria	Bacteria	272	1.5299999999999999e-68	NTclustered	gi\|2809283937\|gb\|CP102579.1\|	2316720	g35641	i0	88.382	20.4522821576763	241	9	100	9	1	241	6155785	6156006	Corallococcus interemptor strain YZPH-2 chromosome, complete genome	blastn	4929	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
20717556	20717556	PRJNA1174234_P_NODE_3957_length_670_cov_1.432161_g3769_i0	PRJNA1174234	3957	670	1.432161	9.5954787	Archangium gephyra	48	Bacteria	Bacteria	62.1	1.11e-4	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g3769	i0	91.304	0.0686567164179104	46	3	7	1	562	607	6450893	6450849	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	46	62.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
23993112	23993112	PRJNA1174234_P_NODE_27039_length_262_cov_1.857143_g26843_i0	PRJNA1174234	27039	262	1.857143	4.86571466	Stigmatella	40	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|343198889\|ref\|NR_043951.1\|	41	g26843	i0	99.618	112.950381679389	262	1	100	0	1	262	690	429	Stigmatella aurantiaca strain ATCC 25190 16S ribosomal RNA, partial sequence	blastn	29593	479	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);;