metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
124600	124600	PRJEB58983_P_NODE_10961_length_379_cov_2.751634_g10546_i0	PRJEB58983	10961	379	2.751634	10.42869286	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	342	1.9099999999999994e-89	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g10546	i0	83.607	88.5646437994723	366	59	97	1	12	377	1222539	1222903	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	33566	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
124833	124833	PRJEB58983_P_NODE_2261_length_837_cov_2.278796_g1896_i0	PRJEB58983	2261	837	2.278796	19.07352252	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	688	0	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g1896	i0	81.7	456.307048984468	847	135	100	19	1	837	597513	598349	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	381929	688	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6503148	6503148	PRJEB58983_P_NODE_25046_length_265_cov_1.265625_g24631_i0	PRJEB58983	25046	265	1.265625	3.35390625	Synechococcus sp. UTEX LB 2390	2137605	Bacteria	Bacteria	448	2.6399999999999996e-121	NTclustered	gi\|1373447567\|gb\|KY979129.1\|	2137605	g24631	i0	97.004	156.166037735849	267	6	100	2	1	265	416	150	Synechococcus sp. UTEX LB 2390 23S ribosomal RNA gene, partial sequence	blastn	41384	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UTEX LB 2390
6503494	6503494	PRJEB58983_P_NODE_9866_length_397_cov_4.361111_g9452_i0	PRJEB58983	9866	397	4.361111	17.31361067	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	313	1.58e-80	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g9452	i0	81.538	231.561712846348	390	62	97	8	7	391	1223375	1222991	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	91930	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
9052265	9052265	PRJEB58983_P_NODE_30688_length_246_cov_0.901734_g30273_i0	PRJEB58983	30688	246	0.901734	2.21826564	[Synechococcus] sp. NIES-970	1827144	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|1143527503\|dbj\|AP017959.1\|	1827144	g30273	i0	84.362	23.260162601626	243	38	99	0	1	243	397881	397639	Synechococcus sp. NIES-970 DNA, complete genome	blastn	5722	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Synechococcus] sp. NIES-970
10327762	10327762	PRJEB58983_P_NODE_15589_length_324_cov_1.776892_g15174_i0	PRJEB58983	15589	324	1.776892	5.75713008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	532	8.92e-147	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15174	i0	96.296	137.148148148148	324	12	100	0	1	324	3682130	3682453	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	44436	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12878496	12878496	PRJEB58983_P_NODE_23151_length_273_cov_4.760000_g22736_i0	PRJEB58983	23151	273	4.76	12.9948	Pseudanabaenaceae cyanobacterium PMC-1017.18	2575741	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|1628791265\|gb\|MK874330.1\|	2575741	g22736	i0	98.535	99.2564102564103	273	4	100	0	1	273	378	650	Pseudanabaenaceae cyanobacterium PMC-1017.18 16S ribosomal RNA gene, partial sequence	blastn	27097	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium PMC-1017.18
15427216	15427216	PRJEB58983_P_NODE_20333_length_288_cov_1.790698_g19918_i0	PRJEB58983	20333	288	1.790698	5.15721024	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	246	1.14e-60	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g19918	i0	85.306	153.03125	245	29	84	7	33	274	511544	511304	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	44073	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
17976397	17976397	PRJEB58983_P_NODE_19495_length_293_cov_1.168182_g19080_i0	PRJEB58983	19495	293	1.168182	3.42277326	uncultured cyanobacterium	1211	Bacteria	Bacteria	501	2.24e-137	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g19080	i0	97.603	100.334470989761	292	7	99	0	2	293	1248	957	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	29398	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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