metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA753704" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2006984	2006984	PRJNA753704_P_NODE_1442_length_909_cov_10.529904_g1137_i0	PRJNA753704	1442	909	10.529904	95.71682736	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	765	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g1137	i0	82.77	587.1100110011	888	124	96	26	33	909	2827196	2828065	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	533683	765	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
3282270	3282270	PRJNA753704_P_NODE_1343_length_943_cov_5.255172_g1043_i0	PRJNA753704	1343	943	5.255172	49.55627196	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	689	0	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g1043	i0	81.85	437.42948038176	865	115	89	34	101	943	239295	240139	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	412496	689	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4559662	4559662	PRJNA753704_P_NODE_8684_length_396_cov_4.396285_g8323_i0	PRJNA753704	8684	396	4.396285	17.4092886	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	532	1.11e-146	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g8323	i0	91.667	528.752525252525	384	32	97	0	6	389	3497867	3497484	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	209386	532	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
5834729	5834729	PRJNA753704_P_NODE_28805_length_239_cov_10.246988_g28444_i0	PRJNA753704	28805	239	10.246988	24.49030132	Litorilinea aerophila	1204385	Bacteria	Bacteria	359	1.13e-94	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g28444	i0	94.068	686.556485355649	236	14	99	0	4	239	5050	5285	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	164087	359	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
8384464	8384464	PRJNA753704_P_NODE_4507_length_532_cov_4.191721_g4148_i0	PRJNA753704	4507	532	4.191721	22.29995572	uncultured Anaerolineales bacterium	444458	Bacteria	Bacteria	763	0	NTclustered	gi\|1494623956\|gb\|MK077662.1\|	444458	g4148	i0	95.287	90.8609022556391	488	11	90	12	1	477	487	1	Uncultured Anaerolineales bacterium clone OTU3240-CR 16S ribosomal RNA gene, partial sequence	blastn	48338	763	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			uncultured Anaerolineales bacterium
9659652	9659652	PRJNA753704_P_NODE_3508_length_597_cov_7.650763_g3152_i0	PRJNA753704	3508	597	7.650763	45.67505511	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	492	2.939999999999999e-134	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g3152	i0	82.444	100.509212730318	581	84	96	16	26	597	2202583	2202012	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	60004	492	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
12210637	12210637	PRJNA753704_P_NODE_30310_length_224_cov_12.993377_g29949_i0	PRJNA753704	30310	224	12.993377	29.10516448	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	254	5.08e-63	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g29949	i0	87.168	16.5446428571429	226	25	100	3	1	224	2924	2701	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	3706	254	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
13484929	13484929	PRJNA753704_P_NODE_291_length_1812_cov_6.902243_g182_i0	PRJNA753704	291	1812	6.902243	125.06864316	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	1519	0	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g182	i0	82.131	420.007726269316	1830	273	99	44	13	1808	672577	670768	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	761054	1519	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13955972	13955972	PRJNA753704_P_NODE_15111_length_308_cov_3.327660_g14750_i0	PRJNA753704	15111	308	3.32766	10.2491928	Caldilinea	233191	Bacteria	Bacteria	359	1.51e-94	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g14750	i0	87.702	296.042207792208	309	37	100	1	1	308	2622	2930	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	91181	359	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17309084	17309084	PRJNA753704_P_NODE_134_length_2416_cov_43.332480_g75_i0	PRJNA753704	134	2416	43.33248	1046.9127168	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1670	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g75	i0	82.488	118.554635761589	1953	297	99	34	478	2408	3496359	3494430	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	286428	1670	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
22408392	22408392	PRJNA753704_P_NODE_16598_length_295_cov_2.689189_g16237_i0	PRJNA753704	16598	295	2.689189	7.93310755	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	298	3.19e-76	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g16237	i0	85.274	124.810169491525	292	39	99	3	5	295	241178	241466	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	36819	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;