metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
377536	377536	PRJNA312107_P_NODE_17621_length_174_cov_0.976000_g17455_i0	PRJNA312107	17621	174	0.976	1.69824	Minicystis rosea	888845	Bacteria	Bacteria	244	2.25e-60	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g17455	i0	91.954	71.9310344827586	174	14	100	0	1	174	770373	770546	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	12516	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
377562	377562	PRJNA312107_P_NODE_20101_length_168_cov_0.873950_g19935_i0	PRJNA312107	20101	168	0.87395	1.468236	Sorangium cellulosum	56	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g19935	i0	95.833	3.95238095238095	72	3	43	0	95	166	3657972	3658043	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	664	117	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3614200	3614200	PRJNA312107_P_NODE_17863_length_172_cov_1.691057_g17697_i0	PRJNA312107	17863	172	1.691057	2.90861804	Polyangiaceae	49	Bacteria	Bacteria	252	1.33e-62	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g17697	i0	93.023	190.21511627907	172	12	100	0	1	172	2742	2571	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	32717	254	0.992125984251969	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
4204864	4204864	PRJNA312107_P_NODE_6884_length_272_cov_0.762332_g6718_i0	PRJNA312107	6884	272	0.762332	2.07354304	Labilithrix luteola	1391654	Bacteria	Bacteria	231	2.99e-56	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6718	i0	92.593	116.275735294118	162	11	83	1	65	226	3943046	3943206	Labilithrix luteola strain DSM 27648, complete genome	blastn	31627	231	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5481000	5481000	PRJNA312107_P_NODE_11865_length_211_cov_1.253086_g11699_i0	PRJNA312107	11865	211	1.253086	2.64401146	Sorangium cellulosum	56	Bacteria	Bacteria	183	6.3e-42	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g11699	i0	82.938	54.0995260663507	211	29	100	6	1	208	10339327	10339533	Sorangium cellulosum 'So ce 56' complete genome	blastn	11415	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6166385	6166385	PRJNA312107_P_NODE_17425_length_175_cov_1.095238_g17259_i0	PRJNA312107	17425	175	1.095238	1.9166665	Haliangium	162027	Bacteria	Bacteria	204	3.85e-48	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g17259	i0	88	145.988571428571	175	18	99	2	3	175	1567	1394	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	25548	204	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
6166403	6166403	PRJNA312107_P_NODE_3825_length_358_cov_3.362460_g3659_i0	PRJNA312107	3825	358	3.36246	12.0376068	root	1	Root_unresolved	Root_unresolved	449	1.0299999999999999e-121	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g3659	i0	89.415	201.432960893855	359	35	99	3	2	358	3690905	3690548	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	72113	453	0.991169977924945	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7441551	7441551	PRJNA312107_P_NODE_12306_length_207_cov_2.525316_g12140_i0	PRJNA312107	12306	207	2.525316	5.22740412	Sorangium	39643	Bacteria	Bacteria	226	1.01e-54	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g12140	i0	86.408	284.458937198068	206	28	99	0	2	207	4330536	4330741	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	58883	226	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9305584	9305584	PRJNA312107_P_NODE_13728_length_197_cov_1.628378_g13562_i0	PRJNA312107	13728	197	1.628378	3.20790466	Chondromyces crocatus	52	Bacteria	Bacteria	252	1.57e-62	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g13562	i0	90.306	140.365482233503	196	13	97	4	6	197	1429853	1430046	Chondromyces crocatus strain Cm c5, complete genome	blastn	27652	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
11856182	11856182	PRJNA312107_P_NODE_12790_length_204_cov_1.238710_g12624_i0	PRJNA312107	12790	204	1.23871	2.5269684	Labilithrix luteola	1391654	Bacteria	Bacteria	211	2.77e-50	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g12624	i0	85.366	4.62745098039216	205	28	100	2	1	204	7915773	7915570	Labilithrix luteola strain DSM 27648, complete genome	blastn	944	211	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15680441	15680441	PRJNA312107_P_NODE_7733_length_257_cov_1.634615_g7567_i0	PRJNA312107	7733	257	1.634615	4.20096055	Labilithrix luteola	1391654	Bacteria	Bacteria	309	1.26e-79	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7567	i0	88.417	185.587548638132	259	27	100	3	1	257	3942491	3942234	Labilithrix luteola strain DSM 27648, complete genome	blastn	47696	309	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22740396	22740396	PRJNA312107_P_NODE_11478_length_214_cov_1.278788_g11312_i0	PRJNA312107	11478	214	1.278788	2.73660632	Myxococcales	29	Bacteria	Bacteria	339	1.29e-88	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g11312	i0	95.305	289.415887850467	213	10	99	0	2	214	832	620	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	61935	340	0.997058823529412	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
23329592	23329592	PRJNA312107_P_NODE_13819_length_196_cov_3.537415_g13653_i0	PRJNA312107	13819	196	3.537415	6.9333334	uncultured Myxococcales bacterium	253830	Bacteria	Bacteria	351	1.49e-92	NTclustered	gi\|726973709\|gb\|KM391636.1\|	253830	g13653	i0	98.98	99.984693877551	196	2	100	0	1	196	359	164	Uncultured Myxococcales bacterium clone IIKFCBR01ER6YH 16S ribosomal RNA gene, partial sequence	blastn	19597	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured Myxococcales bacterium
24603697	24603697	PRJNA312107_P_NODE_25180_length_163_cov_0.912281_g25014_i0	PRJNA312107	25180	163	0.912281	1.48701803	Nannocystis punicea	2995304	Bacteria	Bacteria	115	1.7100000000000003e-21	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g25014	i0	80.255	22.0245398773006	157	27	95	4	5	159	12742159	12742313	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	3590	115	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
24603724	24603724	PRJNA312107_P_NODE_9480_length_233_cov_1.179348_g9314_i0	PRJNA312107	9480	233	1.179348	2.74788084	Pendulispora rubella	2741070	Bacteria	Bacteria	318	1.86e-82	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g9314	i0	91.453	188.798283261803	234	17	100	3	1	233	9852158	9852389	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	43990	318	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
25289731	25289731	PRJNA312107_P_NODE_10280_length_225_cov_1.772727_g10114_i0	PRJNA312107	10280	225	1.772727	3.98863575	Sorangium	39643	Bacteria	Bacteria	359	1.0499999999999999e-94	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g10114	i0	95.536	188.217777777778	224	10	99	0	1	224	4330578	4330801	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	42349	359	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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