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

5 rows where analysis = "blastn", bioproject = "PRJNA702290" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4511843	4511843	PRJNA702290_P_NODE_244_length_297_cov_16.643411_g236_i0	PRJNA702290	244	297	16.643411	49.43093067	Reimeria sinuata	941921	SAR_Eukaryotes	SAR_Eukaryotes	412	1.1e-110	NTclustered	gi\|357381817\|gb\|JN790292.1\|	941921	g236	i0	92.734	97.3602693602694	289	9	97	3	8	296	7	283	Reimeria sinuata strain TCC721 18S ribosomal RNA gene, partial sequence	blastn	28916	412	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Gomphonemataceae	Reimeria	Reimeria sinuata
10113259	10113259	PRJNA702290_P_NODE_1928_length_155_cov_14.681034_g1920_i0	PRJNA702290	1928	155	14.681034	22.7556027	Coscinodiscophyceae	33836	SAR_Eukaryotes	SAR_Eukaryotes	141	2.64e-29	NTclustered	gi\|66571041\|emb\|AJ878467.1\|	29204	g1920	i0	98.734	96.258064516129	79	1	95	0	2	80	193	271	Cyclotella cryptica partial 28S rRNA gene, strain CCMP 331	blastn	14920	141	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
21086163	21086163	PRJNA702290_P_NODE_517_length_198_cov_15.610063_g509_i0	PRJNA702290	517	198	15.610063	30.90792474	Discostella sp.	2728207	SAR_Eukaryotes	SAR_Eukaryotes	348	1.95e-91	NTclustered	gi\|2632235294\|gb\|OR922676.1\|	2728207	g509	i0	98.969	97.9545454545455	194	2	98	0	3	196	3571	3764	Discostella sp. strain AGSB0027 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	19395	348	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella sp.
21086165	21086165	PRJNA702290_P_NODE_557_length_192_cov_2.882353_g549_i0	PRJNA702290	557	192	2.882353	5.53411776	uncultured stramenopile	152704	SAR_Eukaryotes	SAR_Eukaryotes	141	3.43e-29	NTclustered	gi\|385663507\|gb\|JQ782061.1\|	152704	g549	i0	100	50.0364583333333	76	0	73	0	115	190	457	532	Uncultured stramenopile clone 14H3Te6L1 18S ribosomal RNA gene, partial sequence	blastn	9607	141	1	Eukaryota	Sar						uncultured stramenopile
21586898	21586898	PRJNA702290_P_NODE_237_length_302_cov_7.619772_g229_i0	PRJNA702290	237	302	7.619772	23.01171144	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	135	2.71e-27	NTclustered	gi\|2739942905\|dbj\|LC814765.1\|	2843	g229	i0	100	122.37417218543	73	0	74	0	223	295	4059	3987	Skeletonema costatum SCHP35 chloroplast DNA, complete genome	blastn	36957	135	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema costatum

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