metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA816047" 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
25600990	25600990	PRJNA816047d_S_NODE_108233_length_246_cov_2.165803_g106398_i0	PRJNA816047	108233	246	2.165803	5.32787538	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g106398	i0	81.739	2.1260162601626	230	38	93	4	17	244	7449085	7448858	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	523	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
25606232	25606232	PRJNA816047d_S_NODE_82305_length_261_cov_0.990385_g80470_i0	PRJNA816047	82305	261	0.990385	2.58490485	Myxococcales bacterium	2026763	Bacteria	Bacteria	195	3.74e-45	NTclustered	gi\|2108369872\|gb\|CP070650.1\|	2026763	g80470	i0	87.879	62.9157088122605	165	20	63	0	51	215	2610915	2611079	MAG: Myxococcales bacterium isolate bin861 chromosome	blastn	16421	195	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
25738181	25738181	PRJNA816047d_S_NODE_146842_length_217_cov_4.024390_g145007_i0	PRJNA816047	146842	217	4.02439	8.7329263	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	172	1.41e-38	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g145007	i0	85.294	14.9953917050691	170	21	77	4	19	186	962689	962522	Anaeromyxobacter paludicola DNA, complete genome	blastn	3254	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
25742437	25742437	PRJNA816047d_S_NODE_81802_length_261_cov_3.355769_g79967_i0	PRJNA816047	81802	261	3.355769	8.75855709	Pendulispora albinea	2741071	Bacteria	Bacteria	154	6.34e-33	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g79967	i0	80	5.06130268199234	220	34	82	9	11	225	6661154	6661368	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	1321	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
25869624	25869624	PRJNA816047b_S_NODE_20331_length_357_cov_2.936620_g18019_i0	PRJNA816047	20331	357	2.93662	10.4837334	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	364	3.819999999999998e-96	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g18019	i0	87.382	11.5826330532213	317	40	89	0	1	317	1964990	1965306	Anaeromyxobacter paludicola DNA, complete genome	blastn	4135	364	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
25904743	25904743	PRJNA816047a_S_NODE_22963_length_424_cov_2.549858_g20309_i0	PRJNA816047	22963	424	2.549858	10.81139792	Pseudomonadati	3379134	Bacteria	Bacteria	313	1.7e-80	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g20309	i0	91.593	18.1132075471698	226	19	53	0	199	424	11456314	11456539	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	7680	315	0.993650793650794	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
26015045	26015045	PRJNA816047d_S_NODE_96492_length_252_cov_2.723618_g94657_i0	PRJNA816047	96492	252	2.723618	6.86351736	Labilithrix luteola	1391654	Bacteria	Bacteria	215	2.75e-51	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g94657	i0	84.862	6.68650793650794	218	28	85	5	1	215	8276171	8275956	Labilithrix luteola strain DSM 27648, complete genome	blastn	1685	215	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26041105	26041105	PRJNA816047a_S_NODE_29756_length_377_cov_2.500000_g27096_i0	PRJNA816047	29756	377	2.5	9.425	Sorangium	39643	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g27096	i0	96.875	0.254641909814324	32	0	8	1	234	264	9985989	9985958	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	96	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
26044028	26044028	PRJNA816047d_S_NODE_31860_length_378_cov_3.175385_g30026_i0	PRJNA816047	31860	378	3.175385	12.0029553	Myxococcales	29	Bacteria	Bacteria	182	4.4e-41	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g30026	i0	91.111	33.015873015873	135	10	35	2	32	165	3523038	3522905	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	12480	183	0.994535519125683	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
26149573	26149573	PRJNA816047d_S_NODE_58781_length_293_cov_2.779167_g56946_i0	PRJNA816047	58781	293	2.779167	8.14295931	Archangium violaceum	83451	Bacteria	Bacteria	106	2.06e-18	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g56946	i0	83.929	4.5221843003413	112	16	38	2	105	215	8571039	8571149	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	1325	106	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
26284917	26284917	PRJNA816047d_S_NODE_47062_length_320_cov_1.426966_g45227_i0	PRJNA816047	47062	320	1.426966	4.5662912	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	399	9.3e-107	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g45227	i0	89.968	15.91875	309	31	97	0	8	316	1965504	1965812	Anaeromyxobacter paludicola DNA, complete genome	blastn	5094	399	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
26551233	26551233	PRJNA816047b_S_NODE_3424_length_813_cov_1.635135_g1337_i0	PRJNA816047	3424	813	1.635135	13.29364755	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	1013	0	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g1337	i0	90.969	90.9680196801968	753	67	92	1	1	752	1964885	1964133	Anaeromyxobacter paludicola DNA, complete genome	blastn	73957	1013	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
26553409	26553409	PRJNA816047d_S_NODE_108440_length_246_cov_1.424870_g106605_i0	PRJNA816047	108440	246	1.42487	3.5051802	Anaeromyxobacter sp. K	447217	Bacteria	Bacteria	359	1.1699999999999999e-94	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g106605	i0	93.089	33.0406504065041	246	15	99	2	2	246	2438820	2439064	Anaeromyxobacter sp. K, complete genome	blastn	8128	359	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
26553612	26553612	PRJNA816047d_S_NODE_117224_length_242_cov_2.915344_g115389_i0	PRJNA816047	117224	242	2.915344	7.05513248	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	161	3.47e-35	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g115389	i0	80.349	89.198347107438	229	31	92	13	21	242	1761247	1761026	Anaeromyxobacter paludicola DNA, complete genome	blastn	21586	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola

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