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

20 rows where analysis = "blastn", bioproject = "PRJNA900028" 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
874487	874487	PRJNA900028_P_NODE_11941_length_327_cov_33.154676_g11193_i0	PRJNA900028	11941	327	33.154676	108.41579052	Sorangium cellulosum	56	Bacteria	Bacteria	424	5.66e-114	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g11193	i0	89.97	372.082568807339	329	31	100	2	1	327	3451537	3451865	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	121671	424	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
875103	875103	PRJNA900028_P_NODE_181421_length_162_cov_0.902655_g180672_i0	PRJNA900028	181421	162	0.902655	1.4623011	Polyangium aurulentum	2567896	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g180672	i0	90.854	240.493827160494	164	12	99	2	1	161	444056	444219	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	38960	217	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
2150154	2150154	PRJNA900028_P_NODE_162522_length_164_cov_0.886957_g161773_i0	PRJNA900028	162522	164	0.886957	1.45460948	Cystobacter fuscus	43	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g161773	i0	88.199	101.567073170732	161	17	98	2	5	164	9110156	9110315	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	16657	191	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
2150329	2150329	PRJNA900028_P_NODE_180862_length_162_cov_0.902655_g180113_i0	PRJNA900028	180862	162	0.902655	1.4623011	Labilithrix luteola	1391654	Bacteria	Bacteria	132	1.68e-26	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g180113	i0	83.333	0.888888888888889	144	22	88	2	8	150	8619477	8619619	Labilithrix luteola strain DSM 27648, complete genome	blastn	144	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2151333	2151333	PRJNA900028_P_NODE_84442_length_183_cov_1.216418_g83693_i0	PRJNA900028	84442	183	1.216418	2.22604494	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	180	6.85e-41	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g83693	i0	85.549	1.90710382513661	173	23	94	2	12	183	3152753	3152582	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	349	180	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
2520682	2520682	PRJNA900028_P_NODE_191282_length_161_cov_0.910714_g190533_i0	PRJNA900028	191282	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	111	2.18e-20	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g190533	i0	81.481	55.5714285714286	135	25	84	0	1	135	8487163	8487029	Corallococcus sp. EGB chromosome, complete genome	blastn	8947	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
3425734	3425734	PRJNA900028_P_NODE_169803_length_163_cov_0.894737_g169054_i0	PRJNA900028	169803	163	0.894737	1.45842131	Myxococcus stipitatus	83455	Bacteria	Bacteria	134	4.72e-27	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g169054	i0	81.928	68.8527607361963	166	23	99	6	3	163	5293654	5293491	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	11223	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
4704137	4704137	PRJNA900028_P_NODE_4064_length_533_cov_12.758264_g3339_i0	PRJNA900028	4064	533	12.758264	68.00154712	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	483	1.57e-131	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g3339	i0	83.457	654.313320825516	538	69	99	17	1	532	8617642	8617119	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	348749	483	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7623516	7623516	PRJNA900028_P_NODE_62926_length_194_cov_1.275862_g62177_i0	PRJNA900028	62926	194	1.275862	2.47517228	Corallococcus	83461	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g62177	i0	100	290.252577319588	194	0	100	0	1	194	145144	145337	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	56309	359	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
9802175	9802175	PRJNA900028_P_NODE_103068_length_174_cov_1.632000_g102319_i0	PRJNA900028	103068	174	1.632	2.83968	Archangium violaceum	83451	Bacteria	Bacteria	202	1.3699999999999998e-47	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g102319	i0	88.166	4.54022988505747	169	20	97	0	6	174	2263056	2262888	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	790	202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
11078008	11078008	PRJNA900028_P_NODE_131049_length_166_cov_0.871795_g130300_i0	PRJNA900028	131049	166	0.871795	1.4471797	Polyangium aurulentum	2567896	Bacteria	Bacteria	62.1	2.31e-5	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g130300	i0	92.857	9.14457831325301	42	3	25	0	105	146	3594345	3594304	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1518	62.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
13628256	13628256	PRJNA900028_P_NODE_120891_length_167_cov_0.864407_g120142_i0	PRJNA900028	120891	167	0.864407	1.44355969	Cystobacter fuscus	43	Bacteria	Bacteria	117	4.900000000000001e-22	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g120142	i0	81.081	0.88622754491018	148	26	88	2	16	162	8829456	8829602	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	148	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
13628476	13628476	PRJNA900028_P_NODE_14231_length_306_cov_1.346304_g13483_i0	PRJNA900028	14231	306	1.346304	4.11969024	Pendulispora rubella	2741070	Bacteria	Bacteria	361	4.17e-95	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13483	i0	88.026	334.944444444444	309	32	100	5	1	306	7289697	7290003	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	102493	361	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13628649	13628649	PRJNA900028_P_NODE_160751_length_164_cov_0.886957_g160002_i0	PRJNA900028	160751	164	0.886957	1.45460948	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	265	1.6199999999999998e-66	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g160002	i0	95.732	29.4024390243902	164	7	100	0	1	164	6609420	6609583	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	4822	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
13628752	13628752	PRJNA900028_P_NODE_17051_length_286_cov_3.012658_g16302_i0	PRJNA900028	17051	286	3.012658	8.61620188	Myxococcales bacterium	2026763	Bacteria	Bacteria	337	6.52e-88	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g16302	i0	87.847	191.118881118881	288	33	100	2	1	286	1310245	1310532	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	54660	337	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
14902328	14902328	PRJNA900028_P_NODE_109672_length_171_cov_1.631148_g108923_i0	PRJNA900028	109672	171	1.631148	2.78926308	Sorangium cellulosum	56	Bacteria	Bacteria	104	3.9e-18	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g108923	i0	80.597	7.44444444444444	134	26	78	0	38	171	11217555	11217688	Sorangium cellulosum So0157-2, complete genome	blastn	1273	104	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16177024	16177024	PRJNA900028_P_NODE_104633_length_173_cov_2.233871_g103884_i0	PRJNA900028	104633	173	2.233871	3.86459683	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	115	1.8300000000000003e-21	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g103884	i0	84.167	3.83236994219653	120	18	69	1	54	173	885481	885599	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	663	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19096526	19096526	PRJNA900028_P_NODE_186955_length_161_cov_1.821429_g186206_i0	PRJNA900028	186955	161	1.821429	2.93250069	Sorangium	39643	Bacteria	Bacteria	176	7.609999999999999e-40	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g186206	i0	87.662	71.3291925465839	154	15	95	3	4	156	3882080	3881930	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	11484	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19097169	19097169	PRJNA900028_P_NODE_78315_length_186_cov_1.094891_g77566_i0	PRJNA900028	78315	186	1.094891	2.03649726	Myxococcus	32	Bacteria	Bacteria	178	2.5099999999999993e-40	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g77566	i0	84.043	25.6236559139785	188	26	100	4	1	186	1755907	1756092	Myxococcus xanthus strain DK1050 chromosome	blastn	4766	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
25102207	25102207	PRJNA900028_P_NODE_98460_length_176_cov_1.606299_g97711_i0	PRJNA900028	98460	176	1.606299	2.82708624	Labilithrix luteola	1391654	Bacteria	Bacteria	276	8.090000000000001e-70	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g97711	i0	94.886	20.9204545454545	176	9	100	0	1	176	4242341	4242166	Labilithrix luteola strain DSM 27648, complete genome	blastn	3682	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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