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

9 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
1999066	1999066	PRJNA744060_P_NODE_19262_length_368_cov_1.830508_g18933_i0	PRJNA744060	19262	368	1.830508	6.73626944	Nannocystis punicea	2995304	Bacteria	Bacteria	318	3.119999999999999e-82	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g18933	i0	86.598	74.3342391304348	291	36	79	3	34	323	5377565	5377277	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	27355	318	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
3274443	3274443	PRJNA744060_P_NODE_22183_length_344_cov_1.701107_g21854_i0	PRJNA744060	22183	344	1.701107	5.85180808	Polyangium aurulentum	2567896	Bacteria	Bacteria	58.4	6.99e-4	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g21854	i0	92.5	1.86337209302326	40	3	12	0	295	334	6813482	6813443	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	641	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
5827152	5827152	PRJNA744060_P_NODE_50885_length_242_cov_2.343195_g50556_i0	PRJNA744060	50885	242	2.343195	5.6705319	Myxococcales bacterium	2026763	Bacteria	Bacteria	331	2.5e-86	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g50556	i0	91.322	145.111570247934	242	21	100	0	1	242	1308383	1308624	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	35117	331	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10927331	10927331	PRJNA744060_P_NODE_34989_length_279_cov_1.514563_g34660_i0	PRJNA744060	34989	279	1.514563	4.22563077	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	313	1.07e-80	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g34660	i0	87.143	112.046594982079	280	30	99	4	3	279	9677907	9678183	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	31261	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12202370	12202370	PRJNA744060_P_NODE_13610_length_435_cov_1.773481_g13281_i0	PRJNA744060	13610	435	1.773481	7.71464235	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g13281	i0	96.875	0.0735632183908046	32	0	7	1	285	315	1202832	1202863	Sorangium cellulosum 'So ce 56' complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13952426	13952426	PRJNA744060_P_NODE_22491_length_342_cov_1.089219_g22162_i0	PRJNA744060	22491	342	1.089219	3.72512898	root	1	Root_unresolved	Root_unresolved	62.1	5.37e-5	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g22162	i0	97.222	2.13157894736842	36	1	11	0	3	38	10828107	10828142	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	729	62.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15227030	15227030	PRJNA744060_P_NODE_31752_length_291_cov_2.357798_g31423_i0	PRJNA744060	31752	291	2.357798	6.86119218	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g31423	i0	100	0.680412371134021	29	0	10	0	113	141	8469173	8469201	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	198	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
22876035	22876035	PRJNA744060_P_NODE_52358_length_237_cov_2.890244_g52029_i0	PRJNA744060	52358	237	2.890244	6.84987828	Pendulispora	3375062	Bacteria	Bacteria	305	1.48e-78	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g52029	i0	92.13	284.472573839662	216	17	91	0	1	216	7287322	7287107	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	67420	305	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24949642	24949642	PRJNA744060_P_NODE_23100_length_337_cov_2.893939_g22771_i0	PRJNA744060	23100	337	2.893939	9.75257443	Myxococcus landrumensis	2813577	Bacteria	Bacteria	163	1.41e-35	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g22771	i0	82.447	15.3709198813056	188	31	55	2	151	337	8666235	8666421	Myxococcus landrumus strain SCHIC003 chromosome	blastn	5180	163	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis

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