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

5 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Rhodothermota"

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
6363893	6363893	PRJNA946307_P_NODE_118025_length_176_cov_1.535433_g117151_i0	PRJNA946307	118025	176	1.535433	2.70236208	Rhodothermus	29548	Bacteria	Bacteria	121	4.01e-23	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g117151	i0	80.368	2.77840909090909	163	28	91	4	12	172	1665302	1665462	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	489	121	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
16229539	16229539	PRJNA946307_P_NODE_167133_length_158_cov_4.357798_g166259_i0	PRJNA946307	167133	158	4.357798	6.88532084	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	215	1.57e-51	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g166259	i0	94.326	210.683544303797	141	7	89	1	9	149	1308679	1308540	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	33288	215	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
16563554	16563554	PRJNA946307_P_NODE_8973_length_457_cov_2.213235_g8141_i0	PRJNA946307	8973	457	2.213235	10.11448395	Rubrivirga	1434037	Bacteria	Bacteria	505	2.829999999999999e-138	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g8141	i0	87.788	236.144420131291	434	49	95	4	26	457	1307895	1308326	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	107918	505	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22937646	22937646	PRJNA946307_P_NODE_124278_length_173_cov_2.290323_g123404_i0	PRJNA946307	124278	173	2.290323	3.96225879	Rhodothermus	29548	Bacteria	Bacteria	248	1.73e-61	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g123404	i0	95.513	116.398843930636	156	6	90	1	5	159	1493	1338	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	20137	248	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
22938653	22938653	PRJNA946307_P_NODE_78998_length_195_cov_1.239726_g78124_i0	PRJNA946307	78998	195	1.239726	2.4174657	Rhodothermales	1853224	Bacteria	Bacteria	156	1.25e-33	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g78124	i0	82.632	17.1282051282051	190	19	93	11	1	181	2906396	2906580	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	3340	156	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA

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