metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax_phylum = "Gemmatimonadota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1578297	1578297	PRJNA1158727_P_NODE_127462_length_259_cov_1.290323_g120001_i0	PRJNA1158727	127462	259	1.290323	3.34193657	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	276	1.29e-69	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g120001	i0	86.154	82.976833976834	260	31	99	4	3	259	423454	423711	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	21491	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4130810	4130810	PRJNA1158727_P_NODE_138244_length_250_cov_0.870056_g130782_i0	PRJNA1158727	138244	250	0.870056	2.17514	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	270	5.74e-68	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g130782	i0	89.352	7.464	216	22	86	1	9	223	4469478	4469263	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1866	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6683271	6683271	PRJNA1158727_P_NODE_43366_length_572_cov_2.370741_g35948_i0	PRJNA1158727	43366	572	2.370741	13.56063852	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	789	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g35948	i0	92.883	390.622377622378	548	32	95	6	1	543	3043515	3042970	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	223436	789	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11781967	11781967	PRJNA1158727_P_NODE_110470_length_279_cov_1.160194_g103009_i0	PRJNA1158727	110470	279	1.160194	3.23694126	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	60.2	1.54e-4	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g103009	i0	75	0.974910394265233	136	30	48	4	26	159	1476724	1476591	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	272	60.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
12516465	12516465	PRJNA1158727_P_NODE_74790_length_356_cov_1.703180_g67329_i0	PRJNA1158727	74790	356	1.70318	6.0633208	Gemmatirosa	1706036	Bacteria	Bacteria	617	2.65e-172	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g67329	i0	98.028	209.443820224719	355	7	99	0	2	356	423413	423059	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	74562	617	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14334296	14334296	PRJNA1158727_P_NODE_42652_length_581_cov_3.850394_g35243_i0	PRJNA1158727	42652	581	3.850394	22.37078914	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	616	1.6199999999999996e-171	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g35243	i0	85.959	170.734939759036	584	73	99	9	1	579	2076556	2075977	Gemmatimonas phototrophica strain AP64, complete genome	blastn	99197	616	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
15607060	15607060	PRJNA1158727_P_NODE_155053_length_244_cov_0.900585_g147591_i0	PRJNA1158727	155053	244	0.900585	2.1974274	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	220	5.699999999999998e-53	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g147591	i0	84.211	2.62295081967213	228	34	93	2	4	230	2786647	2786873	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	640	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18156178	18156178	PRJNA1158727_P_NODE_163735_length_241_cov_0.916667_g156273_i0	PRJNA1158727	163735	241	0.916667	2.20916747	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	204	5.66e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g156273	i0	82.278	2.39419087136929	237	40	98	2	1	236	3164834	3164599	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	577	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18889346	18889346	PRJNA1158727_P_NODE_90375_length_312_cov_1.933054_g82914_i0	PRJNA1158727	90375	312	1.933054	6.03112848	Gemmatimonadaceae	219687	Bacteria	Bacteria	315	3.37e-81	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g82914	i0	84.936	68.8269230769231	312	45	99	2	2	312	402928	402618	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	21474	318	0.990566037735849	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
20705015	20705015	PRJNA1158727_P_NODE_126397_length_260_cov_1.550802_g118936_i0	PRJNA1158727	126397	260	1.550802	4.0320852	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	274	4.65e-69	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g118936	i0	88.312	39.6038461538462	231	23	88	4	32	260	3114114	3113886	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	10297	274	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20705472	20705472	PRJNA1158727_P_NODE_147477_length_246_cov_3.381503_g140015_i0	PRJNA1158727	147477	246	3.381503	8.31849738	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	226	1.2399999999999997e-54	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g140015	i0	83.75	47.7235772357724	240	37	98	2	3	242	231522	231285	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	11740	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
24530013	24530013	PRJNA1158727_P_NODE_144140_length_248_cov_0.880000_g136678_i0	PRJNA1158727	144140	248	0.88	2.1824	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	283	7.309999999999999e-72	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g136678	i0	88.235	3.43951612903226	238	26	96	2	2	238	4561924	4562160	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	853	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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