metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1031674" 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
2282011	2282011	PRJNA1031674_P_NODE_20522_length_257_cov_1.304348_g20311_i0	PRJNA1031674	20522	257	1.304348	3.35217436	Anaeromyxobacter	161492	Bacteria	Bacteria	446	9.179999999999998e-121	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g20311	i0	98.054	34.6692607003891	257	4	100	1	1	257	851	596	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	8910	446	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
2716984	2716984	PRJNA1031674_P_NODE_11023_length_290_cov_1.170507_g10812_i0	PRJNA1031674	11023	290	1.170507	3.3944703	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	392	1.39e-104	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g10812	i0	91.034	1.98965517241379	290	26	100	0	1	290	2305686	2305975	Corallococcus sp. EGB chromosome, complete genome	blastn	577	392	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
3993054	3993054	PRJNA1031674_P_NODE_10544_length_292_cov_1.808219_g10333_i0	PRJNA1031674	10544	292	1.808219	5.27999948	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	132	3.38e-26	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g10333	i0	79.891	4.47945205479452	184	33	62	4	2	183	3467052	3467233	Anaeromyxobacter oryzae DNA, complete genome	blastn	1308	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
4834784	4834784	PRJNA1031674_P_NODE_11124_length_289_cov_2.101852_g10913_i0	PRJNA1031674	11124	289	2.101852	6.07435228	Myxococcus	32	Bacteria	Bacteria	189	1.95e-43	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g10913	i0	79.286	2.90657439446367	280	50	96	8	9	284	9407538	9407263	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	840	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
6544980	6544980	PRJNA1031674_P_NODE_8706_length_310_cov_2.485232_g8495_i0	PRJNA1031674	8706	310	2.485232	7.7042192	Melittangium boletus	83453	Bacteria	Bacteria	62.1	4.81e-5	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g8495	i0	76.471	0.538709677419355	136	18	39	11	3	124	7136429	7136564	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	167	62.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
7819247	7819247	PRJNA1031674_P_NODE_14347_length_279_cov_1.888350_g14136_i0	PRJNA1031674	14347	279	1.88835	5.2684965	Minicystis rosea	888845	Bacteria	Bacteria	239	1.84e-58	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g14136	i0	82.624	24.1111111111111	282	37	100	9	1	276	2525749	2526024	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	6727	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
7819434	7819434	PRJNA1031674_P_NODE_25947_length_244_cov_1.959064_g25736_i0	PRJNA1031674	25947	244	1.959064	4.78011616	Labilithrix luteola	1391654	Bacteria	Bacteria	246	9.409999999999999e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g25736	i0	85.425	287.385245901639	247	24	99	10	4	244	3942197	3941957	Labilithrix luteola strain DSM 27648, complete genome	blastn	70122	246	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8660012	8660012	PRJNA1031674_P_NODE_25347_length_245_cov_2.186047_g25136_i0	PRJNA1031674	25347	245	2.186047	5.35581515	Myxococcaceae	31	Bacteria	Bacteria	355	1.51e-93	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g25136	i0	93.333	2.95918367346939	240	16	98	0	1	240	1998838	1998599	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	725	355	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
9094428	9094428	PRJNA1031674_P_NODE_648_length_894_cov_1.440926_g485_i0	PRJNA1031674	648	894	1.440926	12.88187844	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	1458	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g485	i0	96.085	339.887024608501	894	35	100	0	1	894	2161810	2160917	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	303859	1458	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
9934854	9934854	PRJNA1031674_P_NODE_14488_length_279_cov_1.291262_g14277_i0	PRJNA1031674	14488	279	1.291262	3.60262098	Corallococcus	83461	Bacteria	Bacteria	143	1.48e-29	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g14277	i0	86.364	1.38351254480287	132	17	47	1	124	255	7745644	7745514	Myxococcus macrosporus strain HW-1, complete genome	blastn	386	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
10369753	10369753	PRJNA1031674_P_NODE_10669_length_291_cov_2.045872_g10458_i0	PRJNA1031674	10669	291	2.045872	5.95348752	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	398	3.0099999999999996e-106	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g10458	i0	91.409	229.73883161512	291	23	99	2	1	290	9678408	9678697	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	66854	398	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
10369883	10369883	PRJNA1031674_P_NODE_18129_length_266_cov_1.549223_g17918_i0	PRJNA1031674	18129	266	1.549223	4.12093318	Labilithrix luteola	1391654	Bacteria	Bacteria	374	4.569999999999999e-99	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17918	i0	92.72	44.4285714285714	261	15	97	3	8	266	678193	677935	Labilithrix luteola strain DSM 27648, complete genome	blastn	11818	374	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11645105	11645105	PRJNA1031674_P_NODE_10010_length_296_cov_3.511211_g9799_i0	PRJNA1031674	10010	296	3.511211	10.39318456	Archangium violaceum	83451	Bacteria	Bacteria	145	4.41e-30	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g9799	i0	84.354	4.75675675675676	147	23	50	0	150	296	1679308	1679454	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	1408	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
14195397	14195397	PRJNA1031674_P_NODE_27712_length_241_cov_1.767857_g27501_i0	PRJNA1031674	27712	241	1.767857	4.26053537	Minicystis rosea	888845	Bacteria	Bacteria	106	1.64e-18	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g27501	i0	80.851	1.6804979253112	141	21	57	5	3	140	4363092	4363229	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	405	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
15469585	15469585	PRJNA1031674_P_NODE_24653_length_247_cov_0.885057_g24442_i0	PRJNA1031674	24653	247	0.885057	2.18609079	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g24442	i0	97.166	4.00404858299595	247	7	100	0	1	247	4392799	4392553	Myxococcus sp. MH1 DNA, complete genome	blastn	989	418	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
16743572	16743572	PRJNA1031674_P_NODE_17154_length_270_cov_1.167513_g16943_i0	PRJNA1031674	17154	270	1.167513	3.1522851	Corallococcus exercitus	2316736	Bacteria	Bacteria	399	7.669999999999998e-107	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g16943	i0	93.333	2.98518518518519	270	18	100	0	1	270	9159341	9159072	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	806	399	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
18018488	18018488	PRJNA1031674_P_NODE_17415_length_269_cov_1.306122_g17204_i0	PRJNA1031674	17415	269	1.306122	3.51346818	Labilithrix luteola	1391654	Bacteria	Bacteria	171	6.52e-38	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17204	i0	78.439	1	269	52	99	6	4	269	189044	188779	Labilithrix luteola strain DSM 27648, complete genome	blastn	269	171	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18018613	18018613	PRJNA1031674_P_NODE_2695_length_473_cov_1.420000_g2485_i0	PRJNA1031674	2695	473	1.42	6.7166	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	761	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g2485	i0	95.772	271.583509513742	473	19	100	1	1	473	2161042	2160571	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	128459	761	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
20133282	20133282	PRJNA1031674_P_NODE_28856_length_230_cov_2.121019_g28645_i0	PRJNA1031674	28856	230	2.121019	4.8783437	Archangium	47	Bacteria	Bacteria	364	2.319999999999999e-96	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g28645	i0	95.217	250.878260869565	230	11	100	0	1	230	5101085	5100856	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	57702	364	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
23119002	23119002	PRJNA1031674_P_NODE_24979_length_246_cov_0.890173_g24768_i0	PRJNA1031674	24979	246	0.890173	2.18982558	Corallococcus coralloides	184914	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g24768	i0	98.374	1.93089430894309	246	4	100	0	1	246	6308404	6308159	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	475	433	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides

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