metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
549345	549345	PRJNA564013_P_NODE_229801_length_279_cov_1.665138_g226949_i0	PRJNA564013	229801	279	1.665138	4.64573502	Cystobacter fuscus	43	Bacteria	Bacteria	243	1.42e-59	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g226949	i0	82.909	87.9784946236559	275	41	97	6	2	273	10884042	10883771	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	24546	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
1132961	1132961	PRJNA564013_P_NODE_367801_length_182_cov_8.314050_g364949_i0	PRJNA564013	367801	182	8.31405	15.131571	Sorangium	39643	Bacteria	Bacteria	156	1.15e-33	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g364949	i0	84.431	27.1648351648352	167	16	88	9	22	182	1516	1678	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	4944	156	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1826948	1826948	PRJNA564013_P_NODE_338322_length_205_cov_0.902778_g335470_i0	PRJNA564013	338322	205	0.902778	1.8506949	Archangium violaceum	83451	Bacteria	Bacteria	307	3.4600000000000006e-79	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g335470	i0	93.659	1	205	13	100	0	1	205	12545845	12546049	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	205	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
1827330	1827330	PRJNA564013_P_NODE_35842_length_643_cov_2.993127_g33179_i0	PRJNA564013	35842	643	2.993127	19.24580661	Corallococcus macrosporus	35	Bacteria	Bacteria	385	5.5499999999999996e-102	NTclustered	gi\|1243045502\|gb\|CP022203.1\|	1189310	g33179	i0	81.238	42.2846034214619	517	62	76	29	16	505	3246222	3245714	Corallococcus macrosporus DSM 14697 chromosome, complete genome	blastn	27189	385	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
4374301	4374301	PRJNA564013_P_NODE_12004_length_1017_cov_20.398536_g1035_i2	PRJNA564013	12004	1017	20.398536	207.45311112	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	315	1.19e-80	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g1035	i2	85.113	20.0206489675516	309	44	30	2	27	334	990395	990702	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	20361	315	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8202198	8202198	PRJNA564013_P_NODE_226487_length_281_cov_29.840909_g223636_i0	PRJNA564013	226487	281	29.840909	83.85295429	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	243	1.4300000000000001e-59	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g223636	i0	83.588	4.93238434163701	262	39	93	4	22	281	9647301	9647042	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1386	243	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8203663	8203663	PRJNA564013_P_NODE_30407_length_689_cov_7.471338_g27834_i0	PRJNA564013	30407	689	7.471338	51.47751882	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	311	1.03e-79	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g27834	i0	79.618	1.11320754716981	471	67	65	21	47	497	1267095	1266634	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	767	311	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8204768	8204768	PRJNA564013_P_NODE_359247_length_192_cov_3.167939_g356395_i0	PRJNA564013	359247	192	3.167939	6.08244288	Stigmatella aurantiaca	41	Bacteria	Bacteria	294	2.49e-75	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g356395	i0	94.271	110.963541666667	192	11	100	0	1	192	6480074	6480265	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	21305	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8204959	8204959	PRJNA564013_P_NODE_372047_length_176_cov_5.104348_g369195_i0	PRJNA564013	372047	176	5.104348	8.98365248	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	174	3.04e-39	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g369195	i0	87.919	1.82954545454545	149	16	84	2	29	176	4352034	4351887	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	322	174	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
9477988	9477988	PRJNA564013_P_NODE_23508_length_769_cov_5.384181_g21126_i0	PRJNA564013	23508	769	5.384181	41.40435189	Labilithrix luteola	1391654	Bacteria	Bacteria	326	4.1199999999999995e-84	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g21126	i0	75.391	5.8556566970091	768	139	95	38	39	769	6136507	6137261	Labilithrix luteola strain DSM 27648, complete genome	blastn	4503	326	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10753736	10753736	PRJNA564013_P_NODE_231469_length_277_cov_4.675926_g228617_i0	PRJNA564013	231469	277	4.675926	12.95231502	Polyangium aurulentum	2567896	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g228617	i0	100	0.407942238267148	29	0	10	0	118	146	8090370	8090398	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	113	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
10753920	10753920	PRJNA564013_P_NODE_242589_length_267_cov_11.160194_g239737_i0	PRJNA564013	242589	267	11.160194	29.79771798	Sorangium cellulosum	56	Bacteria	Bacteria	91.6	5.18e-14	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g239737	i0	92.188	20.0936329588015	64	5	24	0	180	243	1441977	1441914	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	5365	91.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10755432	10755432	PRJNA564013_P_NODE_322669_length_212_cov_1.880795_g319817_i0	PRJNA564013	322669	212	1.880795	3.9872854	Corallococcus coralloides	184914	Bacteria	Bacteria	73.1	1.43e-8	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g319817	i0	84.932	0.344339622641509	73	9	34	2	108	179	3543605	3543676	Corallococcus coralloides DSM 2259, complete genome	blastn	73	73.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
10756576	10756576	PRJNA564013_P_NODE_44349_length_587_cov_6.081749_g41616_i0	PRJNA564013	44349	587	6.081749	35.69986663	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	267	1.9000000000000001e-66	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g41616	i0	76.525	1.86712095400341	541	95	89	27	22	542	6954581	6954053	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1096	267	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12026511	12026511	PRJNA564013_P_NODE_141970_length_359_cov_4.708054_g139121_i0	PRJNA564013	141970	359	4.708054	16.90191386	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	278	5.15e-70	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g139121	i0	82.029	26.6406685236769	345	44	94	14	1	339	2394023	2393691	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	9564	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12027196	12027196	PRJNA564013_P_NODE_168330_length_335_cov_5.080292_g165480_i0	PRJNA564013	168330	335	5.080292	17.0189782	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	254	8.07e-63	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g165480	i0	87.5	38.7432835820896	224	23	66	3	23	242	3162231	3162453	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	12979	254	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17125402	17125402	PRJNA564013_P_NODE_152014_length_349_cov_22.871528_g149165_i0	PRJNA564013	152014	349	22.871528	79.82163272	Pendulispora albinea	2741071	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g149165	i0	100	0.0830945558739255	29	0	8	0	255	283	10627315	10627287	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
20951267	20951267	PRJNA564013_P_NODE_218617_length_289_cov_1.140351_g215766_i0	PRJNA564013	218617	289	1.140351	3.29561439	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	176	1.52e-39	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g215766	i0	80.242	0.858131487889273	248	37	83	10	26	264	4558179	4558423	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	248	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20951593	20951593	PRJNA564013_P_NODE_237557_length_272_cov_2.398104_g234705_i0	PRJNA564013	237557	272	2.398104	6.52284288	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	235	2.31e-57	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g234705	i0	83.794	1.03308823529412	253	35	92	6	21	270	2245931	2245682	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	281	235	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23501071	23501071	PRJNA564013_P_NODE_194079_length_312_cov_1.294821_g191228_i0	PRJNA564013	194079	312	1.294821	4.03984152	Archangium violaceum	83451	Bacteria	Bacteria	488	1.88e-133	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g191228	i0	95.71	3.82371794871795	303	13	97	0	8	310	12546415	12546113	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	1193	488	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
23502264	23502264	PRJNA564013_P_NODE_257599_length_255_cov_3.448454_g254747_i0	PRJNA564013	257599	255	3.448454	8.7935577	Chondromyces crocatus	52	Bacteria	Bacteria	204	6.04e-48	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g254747	i0	89.873	0.619607843137255	158	16	62	0	23	180	9151326	9151483	Chondromyces crocatus strain Cm c5, complete genome	blastn	158	204	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
24778399	24778399	PRJNA564013_P_NODE_42760_length_596_cov_8.418692_g40031_i0	PRJNA564013	42760	596	8.418692	50.17540432	Polyangium aurulentum	2567896	Bacteria	Bacteria	279	2.48e-70	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g40031	i0	83.072	0.810402684563758	319	42	53	6	233	545	3759646	3759334	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	483	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
25358541	25358541	PRJNA564013_P_NODE_24460_length_757_cov_3.669540_g22056_i0	PRJNA564013	24460	757	3.66954	27.7784178	Corallococcus	83461	Bacteria	Bacteria	972	0	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g22056	i0	91.086	5.57859973579921	718	64	95	0	22	739	2306275	2305558	Corallococcus sp. EGB chromosome, complete genome	blastn	4223	972	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB

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