metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
1997443	1997443	PRJNA741997_P_NODE_34362_length_371_cov_1.033557_g33242_i0	PRJNA741997	34362	371	1.033557	3.83449647	Sorangium cellulosum	56	Bacteria	Bacteria	58.4	7.58e-4	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g33242	i0	100	0.172506738544474	31	0	8	0	316	346	14043141	14043111	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	64	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1997779	1997779	PRJNA741997_P_NODE_87842_length_242_cov_0.911243_g86722_i0	PRJNA741997	87842	242	0.911243	2.20520806	Sorangium cellulosum	56	Bacteria	Bacteria	65.8	2.8e-6	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g86722	i0	97.368	2.27272727272727	38	1	16	0	74	111	13973424	13973387	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	550	65.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7100324	7100324	PRJNA741997_P_NODE_71766_length_251_cov_0.865169_g70646_i0	PRJNA741997	71766	251	0.865169	2.17157419	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g70646	i0	100	0.111553784860558	28	0	11	0	70	97	10644720	10644747	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9650095	9650095	PRJNA741997_P_NODE_68588_length_258_cov_1.378378_g67468_i0	PRJNA741997	68588	258	1.378378	3.5562152400000002	Pendulispora albinea	2741071	Bacteria	Bacteria	63.9	1.08e-5	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g67468	i0	93.182	0.686046511627907	44	1	17	2	23	65	1505931	1505973	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	177	63.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
10925654	10925654	PRJNA741997_P_NODE_87429_length_242_cov_0.911243_g86309_i0	PRJNA741997	87429	242	0.911243	2.20520806	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g86309	i0	94.286	0.144628099173554	35	2	14	0	121	155	9831896	9831862	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	35	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
14750654	14750654	PRJNA741997_P_NODE_84152_length_244_cov_0.900585_g83032_i0	PRJNA741997	84152	244	0.900585	2.1974274	Sorangium cellulosum	56	Bacteria	Bacteria	163	9.75e-36	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g83032	i0	79.2	30.9549180327869	250	40	100	9	1	244	9864167	9864410	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	7553	163	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18573365	18573365	PRJNA741997_P_NODE_73835_length_250_cov_0.870056_g72715_i0	PRJNA741997	73835	250	0.870056	2.17514	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	174	4.63e-39	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g72715	i0	79.752	64.576	242	47	96	2	10	250	6357212	6357452	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	16144	174	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
21124098	21124098	PRJNA741997_P_NODE_54497_length_290_cov_1.400922_g53377_i0	PRJNA741997	54497	290	1.400922	4.0626738	Cystobacter fuscus	43	Bacteria	Bacteria	58.4	5.77e-4	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g53377	i0	97.059	0.117241379310345	34	1	12	0	257	290	4690812	4690779	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
22399235	22399235	PRJNA741997_P_NODE_90898_length_226_cov_2.013072_g89778_i0	PRJNA741997	90898	226	2.013072	4.54954272	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	65.8	2.58e-6	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g89778	i0	100	1.67256637168142	35	0	15	0	170	204	949505	949539	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	378	65.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
24948076	24948076	PRJNA741997_P_NODE_65180_length_266_cov_1.259067_g64060_i0	PRJNA741997	65180	266	1.259067	3.34911822	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g64060	i0	100	0.105263157894737	28	0	11	0	235	262	2922228	2922201	Anaeromyxobacter oryzae DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae

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