metadata: contig_metadata: 7 rows where bioproject = "PRJNA728642", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA728642", tax_kingdom = "Pseudomonadati" 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
11398653	11398653	PRJNA728642_P_NODE_19609_length_241_cov_0.916667_g19338_i0	PRJNA728642	19609	241	0.916667	2.20916747	Polyangiaceae	49	Bacteria	Bacteria	318	1.94e-82	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g19338	i0	90.456	87.5809128630705	241	23	100	0	1	241	865539	865299	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	21107	318	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12674686	12674686	PRJNA728642_P_NODE_6290_length_409_cov_2.663690_g6019_i0	PRJNA728642	6290	409	2.66369	10.8944921	Nannocystis	53	Bacteria	Bacteria	490	7.02e-134	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g6019	i0	88.321	145.953545232274	411	44	100	4	1	409	29	437	N.exedens 23S rRNA gene	blastn	59695	490	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
13948871	13948871	PRJNA728642_P_NODE_19811_length_238_cov_2.363636_g19540_i0	PRJNA728642	19811	238	2.363636	5.62545368	Nannocystis	53	Bacteria	Bacteria	374	4.02e-99	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g19540	i0	94.958	196.117647058824	238	12	100	0	1	238	2149	2386	N.exedens 23S rRNA gene	blastn	46676	374	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
17290970	17290970	PRJNA728642_P_NODE_4934_length_465_cov_2.326531_g4663_i0	PRJNA728642	4934	465	2.326531	10.81836915	Myxococcales bacterium	2026763	Bacteria	Bacteria	261	6.89e-65	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g4663	i0	77.854	40.6967741935484	438	86	93	11	12	442	1313763	1314196	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	18924	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
17772733	17772733	PRJNA728642_P_NODE_17154_length_247_cov_1.534483_g16883_i0	PRJNA728642	17154	247	1.534483	3.79017301	Myxococcaceae	31	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g16883	i0	99.595	248.943319838057	247	1	100	0	1	247	6007231	6007477	Myxococcus xanthus strain DK1050 chromosome	blastn	61489	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
21115555	21115555	PRJNA728642_P_NODE_6437_length_404_cov_2.105740_g6166_i0	PRJNA728642	6437	404	2.10574	8.5071896	Myxococcales bacterium	2026763	Bacteria	Bacteria	438	2.55e-118	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g6166	i0	87.306	408.279702970297	386	46	95	3	1	384	1313394	1313010	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	164945	438	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
22390295	22390295	PRJNA728642_P_NODE_17238_length_247_cov_0.885057_g16967_i0	PRJNA728642	17238	247	0.885057	2.18609079	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	110	1.31e-19	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g16967	i0	85.849	4.8582995951417	106	11	42	2	25	128	4086766	4086663	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	1200	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis

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