metadata: contig_metadata: 14 rows where bioproject = "PRJEB3181", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJEB3181", 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
56048	56048	PRJEB3181_P_NODE_7321_length_310_cov_4.842294_g7060_i0	PRJEB3181	7321	310	4.842294	15.0111114	Labilithrix luteola	1391654	Bacteria	Bacteria	339	1.99e-88	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7060	i0	86.624	42.0903225806452	314	32	99	7	1	307	3943154	3943464	Labilithrix luteola strain DSM 27648, complete genome	blastn	13048	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2605906	2605906	PRJEB3181_P_NODE_22103_length_173_cov_4.669014_g21838_i0	PRJEB3181	22103	173	4.669014	8.07739422	Pendulispora rubella	2741070	Bacteria	Bacteria	189	1.06e-43	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g21838	i0	88.535	129.791907514451	157	16	90	2	18	173	7287059	7287214	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	22454	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
2605987	2605987	PRJEB3181_S_NODE_12683_length_181_cov_12.000000_g12390_i0	PRJEB3181	12683	181	12	21.72	Pendulispora rubella	2741070	Bacteria	Bacteria	145	2.4699999999999997e-30	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g12390	i0	88.889	233.917127071823	117	13	65	0	54	170	7289887	7290003	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	42339	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
3539440	3539440	PRJEB3181_S_NODE_6043_length_250_cov_27.590698_g5750_i0	PRJEB3181	6043	250	27.590698	68.976745	Corallococcus	83461	Bacteria	Bacteria	228	3.4999999999999995e-55	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g5750	i0	85.268	193.508	224	30	90	3	15	236	142638	142416	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	48377	228	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
8642015	8642015	PRJEB3181_P_NODE_167_length_1041_cov_10.607921_g24_i1	PRJEB3181	167	1041	10.607921	110.42845761	Myxococcia	32015	Bacteria	Bacteria	1131	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g24	i1	86.351	123.547550432277	1055	123	100	20	1	1041	7915814	7914767	Labilithrix luteola strain DSM 27648, complete genome	blastn	128613	1131	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12467934	12467934	PRJEB3181_P_NODE_24790_length_162_cov_1.435115_g24525_i0	PRJEB3181	24790	162	1.435115	2.3248863	Pendulispora	3375062	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g24525	i0	91.304	221.666666666667	161	14	99	0	2	162	7287744	7287904	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	35910	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
12809673	12809673	PRJEB3181_S_NODE_4671_length_277_cov_58.904959_g4378_i0	PRJEB3181	4671	277	58.904959	163.16673643	Pendulispora rubella	2741070	Bacteria	Bacteria	324	4.89e-84	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g4378	i0	87.814	376.252707581227	279	30	100	4	1	277	7290030	7289754	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	104222	324	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20456709	20456709	PRJEB3181_P_NODE_12017_length_244_cov_161.647887_g11753_i0	PRJEB3181	12017	244	161.647887	394.42084428	Labilithrix luteola	1391654	Bacteria	Bacteria	283	7.17e-72	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11753	i0	88.285	49.1598360655738	239	24	97	4	8	244	3942223	3941987	Labilithrix luteola strain DSM 27648, complete genome	blastn	11995	283	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20456905	20456905	PRJEB3181_S_NODE_4057_length_292_cov_12.929961_g3764_i0	PRJEB3181	4057	292	12.929961	37.75548612	Labilithrix luteola	1391654	Bacteria	Bacteria	357	5.12e-94	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g3764	i0	89.236	203.931506849315	288	27	98	4	1	286	3942227	3941942	Labilithrix luteola strain DSM 27648, complete genome	blastn	59548	357	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21732745	21732745	PRJEB3181_P_NODE_8678_length_287_cov_1624.746094_g8415_i0	PRJEB3181	8678	287	1624.746094	4663.02128978	Pendulispora brunnea	2905690	Bacteria	Bacteria	224	5.309999999999999e-54	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g8415	i0	84.188	274.379790940767	234	33	82	2	29	261	7409500	7409270	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	78747	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
22665684	22665684	PRJEB3181_P_NODE_38_length_1465_cov_29.319386_g24_i0	PRJEB3181	38	1465	29.319386	429.5290049	Myxococcia	32015	Bacteria	Bacteria	1615	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g24	i0	86.617	157.527645051195	1487	168	100	27	1	1465	3941987	3943464	Labilithrix luteola strain DSM 27648, complete genome	blastn	230778	1615	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
29559464	29559464	PRJEB3181_P_NODE_28330_length_150_cov_1.075630_g28065_i0	PRJEB3181	28330	150	1.07563	1.613445	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	53.1	1.83e-6	NR	MBI4516666.1	2026735	g28065	i0	56.6	1.06	53	17	96	3	149	6	103	154	MBI4516666.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	159	53.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30064786	30064786	PRJEB3181_S_NODE_13972_length_173_cov_1.731884_g13679_i0	PRJEB3181	13972	173	1.731884	2.99615932	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	92.8	2.09e-21	NR	TNF00051.1	2026735	g13679	i0	88.5	1.80346820809249	52	6	90.2	0	1	156	73	124	TNF00051.1 MAG: UMP kinase [Deltaproteobacteria bacterium]	diamond	312	92.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32303291	32303291	PRJEB3181_P_NODE_23239_length_168_cov_3.277372_g22974_i0	PRJEB3181	23239	168	3.277372	5.50598496	Myxococcia	32015	Bacteria	Bacteria	59.3	4.82e-9	NR	MBL92291.1	2026763	g22974	i0	65	3.60714285714286	40	14	71.4	0	1	120	129	168	MBL92291.1 peptidylprolyl isomerase [Myxococcales bacterium]	diamond	606	59.7	0.993299832495812	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium

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