metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Chlorobiota"

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
1802274	1802274	PRJNA556992_P_NODE_281522_length_292_cov_3.703196_g279333_i0	PRJNA556992	281522	292	3.703196	10.81333232	Chlorobaculum tepidum	1097	Bacteria	Bacteria	224	5.42e-54	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g279333	i0	82.308	57.6095890410959	260	44	89	2	31	289	862842	863100	Chlorobium tepidum TLS, complete genome	blastn	16822	224	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
2402291	2402291	PRJNA556992_P_NODE_615302_length_257_cov_5.250000_g613113_i0	PRJNA556992	615302	257	5.25	13.4925	FCB group	1783270	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1187407156\|gb\|CP020873.1\|	1974213	g613113	i0	100	0.217898832684825	28	0	11	0	117	144	1887450	1887423	Prosthecochloris sp. HL-130-GSB chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. HL-130-GSB
17104826	17104826	PRJNA556992_P_NODE_31674_length_616_cov_1.930018_g29565_i0	PRJNA556992	31674	616	1.930018	11.88891088	uncultured Chlorobiota bacterium	156405	Bacteria	Bacteria	872	0	NTclustered	gi\|77403655\|dbj\|AB161089.1\|	156405	g29565	i0	98.196	92.8344155844156	499	9	81	0	2	500	499	1	Uncultured Chlorobi bacterium gene for 16S ribosomal RNA, partial sequence, clone:3D9	blastn	57186	872	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					uncultured Chlorobiota bacterium
20928334	20928334	PRJNA556992_P_NODE_259837_length_300_cov_6.682819_g257648_i0	PRJNA556992	259837	300	6.682819	20.048457	Prosthecochloris sp. GSB1	281093	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1227310175\|gb\|CP022571.1\|	281093	g257648	i0	100	0.1	30	0	10	0	223	252	2401761	2401732	Prosthecochloris sp. GSB1 strain TY Vent = GSB1 = Ty-1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. GSB1
22805127	22805127	PRJNA556992_P_NODE_915618_length_239_cov_3.234940_g913428_i0	PRJNA556992	915618	239	3.23494	7.7315066	Chlorobiaceae	191412	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|470483299\|ref\|NR_076584.1\|	1092	g913428	i0	100	154.384937238494	239	0	100	0	1	239	705	943	Chlorobium limicola strain DSM 245 23S ribosomal RNA gene, complete sequence	blastn	36898	442	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola

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