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

10 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Chloroflexota"

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
163680	163680	PRJNA1028258_P_NODE_145801_length_232_cov_0.871166_g145238_i0	PRJNA1028258	145801	232	0.871166	2.02110512	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	257	4.1e-64	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g145238	i0	86.638	1	232	31	100	0	1	232	870740	870971	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	232	257	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
1437673	1437673	PRJNA1028258_P_NODE_101922_length_259_cov_1.447368_g101359_i0	PRJNA1028258	101922	259	1.447368	3.74868312	Chloroflexota bacterium	2026724	Bacteria	Bacteria	279	9.94e-71	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g101359	i0	86.434	539.718146718147	258	32	99	3	3	259	1474230	1473975	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	139787	279	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
5267693	5267693	PRJNA1028258_P_NODE_44725_length_379_cov_0.829032_g44162_i0	PRJNA1028258	44725	379	0.829032	3.14203128	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2893358456\|emb\|OZ220748.1\|	2026734	g44162	i0	100	0.0738786279683377	28	0	7	0	348	375	2134886	2134859	MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9090724	9090724	PRJNA1028258_P_NODE_113028_length_250_cov_1.259669_g112465_i0	PRJNA1028258	113028	250	1.259669	3.1491725	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	143	1.31e-29	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g112465	i0	84.106	69.928	151	20	60	4	83	231	1245544	1245692	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	17482	143	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
9090810	9090810	PRJNA1028258_P_NODE_117648_length_246_cov_1.491525_g117085_i0	PRJNA1028258	117648	246	1.491525	3.6691515	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	191	4.51e-44	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g117085	i0	82.051	25.739837398374	234	32	93	9	12	240	1519045	1518817	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	6332	191	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
9934201	9934201	PRJNA1028258_P_NODE_70708_length_305_cov_2.360169_g70145_i0	PRJNA1028258	70708	305	2.360169	7.19851545	Chloroflexus	1107	Bacteria	Bacteria	244	4.37e-60	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g70145	i0	81.759	121.154098360656	307	42	98	11	4	303	722	1021	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	36952	244	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
12919345	12919345	PRJNA1028258_P_NODE_83031_length_283_cov_1.233645_g82468_i0	PRJNA1028258	83031	283	1.233645	3.49121535	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	159	1.5e-34	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g82468	i0	80.769	1.15547703180212	208	36	73	4	56	261	3522302	3522097	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	327	159	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16740145	16740145	PRJNA1028258_P_NODE_116634_length_247_cov_1.286517_g116071_i0	PRJNA1028258	116634	247	1.286517	3.17769699	Tepidiforma flava	3004094	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g116071	i0	92.181	74.6032388663968	243	17	98	2	1	243	248835	249075	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	18427	342	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
20566942	20566942	PRJNA1028258_P_NODE_91277_length_270_cov_1.273632_g90714_i0	PRJNA1028258	91277	270	1.273632	3.4388064	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g90714	i0	100	0.222222222222222	30	0	11	0	155	184	1711752	1711723	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	60	56.5	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
25231876	25231876	PRJNA1028258_P_NODE_47340_length_368_cov_1.872910_g46777_i0	PRJNA1028258	47340	368	1.87291	6.8923088	Caldilinea	233191	Bacteria	Bacteria	525	1.7099999999999993e-144	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g46777	i0	92.391	572.989130434783	368	28	100	0	1	368	2555	2188	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	210860	525	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila

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