metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA703759" 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
1960973	1960973	PRJNA703759_P_NODE_7742_length_496_cov_1.843972_g7266_i0	PRJNA703759	7742	496	1.843972	9.14610112	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	473	8.719999999999999e-129	NTclustered	gi\|2531976038\|emb\|OY282376.1\|	2614250	g7266	i0	84.073	451.199596774194	496	74	100	5	4	496	4760574	4760081	MAG: Caldilineaceae bacterium genome assembly, chromosome: 1	blastn	223795	473	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
6289108	6289108	PRJNA703759_P_NODE_8125_length_482_cov_2.833741_g7649_i0	PRJNA703759	8125	482	2.833741	13.65863162	Caldilinea	233191	Bacteria	Bacteria	747	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g7649	i0	94.606	769.298755186722	482	26	100	0	1	482	2667	2186	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	370802	747	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
7062973	7062973	PRJNA703759_P_NODE_3026_length_943_cov_2.341379_g2577_i0	PRJNA703759	3026	943	2.341379	22.07920397	Litorilinea aerophila	1204385	Bacteria	Bacteria	1134	0	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g2577	i0	88.723	331.498409331919	940	91	99	8	1	929	4636	3701	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	312603	1134	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
12664406	12664406	PRJNA703759_P_NODE_37390_length_251_cov_0.876404_g36914_i0	PRJNA703759	37390	251	0.876404	2.19977404	PVC group	1783257	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g36914	i0	97.059	3.50199203187251	34	1	14	0	123	156	4879935	4879968	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	879	58.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
13438495	13438495	PRJNA703759_P_NODE_47371_length_244_cov_0.912281_g46895_i0	PRJNA703759	47371	244	0.912281	2.22596564	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g46895	i0	88.511	0.963114754098361	235	27	96	0	10	244	1067390	1067156	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	235	285	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
14713480	14713480	PRJNA703759_P_NODE_35252_length_253_cov_0.866667_g34776_i0	PRJNA703759	35252	253	0.866667	2.19266751	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2893358456\|emb\|OZ220748.1\|	2026734	g34776	i0	100	0.118577075098814	30	0	12	0	204	233	1045980	1046009	MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
14713494	14713494	PRJNA703759_P_NODE_35852_length_252_cov_0.871508_g35376_i0	PRJNA703759	35852	252	0.871508	2.19620016	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2893358382\|emb\|OZ220676.1\|	2614250	g35376	i0	100	0.444444444444444	28	0	11	0	87	114	1189721	1189748	MAG: Caldilineaceae bacterium isolate 6911f4b3-f793-4dac-9473-b80504ec0e1d genome assembly, chromosome: 1	blastn	112	52.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
19811080	19811080	PRJNA703759_P_NODE_2136_length_1189_cov_3.133513_g1723_i0	PRJNA703759	2136	1189	3.133513	37.25746957	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	564	1.26e-155	NTclustered	gi\|2531948656\|emb\|OY282446.1\|	3022862	g1723	i0	80.309	372.80992430614	777	128	64	20	420	1185	658878	659640	MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1	blastn	443271	564	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium

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