metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_phylum = "Tubulinea"

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
4770231	4770231	PRJNA966993_P_NODE_12024_length_606_cov_2.752345_g11595_i0	PRJNA966993	12024	606	2.752345	16.6792107	Chaos nobile	160822	Tubulinea	other_Eukaryota	525	2.939999999999999e-144	NTclustered	gi\|17902587\|emb\|AJ314606.1\|	160822	g11595	i0	91.429	68.2871287128713	385	29	72	4	1	382	1325	942	Chaos nobile partial 16S rRNA gene, strain CCAP 1511/2	blastn	41382	525	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos nobile
6045140	6045140	PRJNA966993_P_NODE_14345_length_554_cov_1.920998_g13910_i0	PRJNA966993	14345	554	1.920998	10.64232892	Copromyxa protea	931554	Tubulinea	other_Eukaryota	475	2.729999999999999e-129	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g13910	i0	84.842	0.857400722021661	475	68	85	4	76	548	1385	913	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	475	475	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
13696086	13696086	PRJNA966993_P_NODE_72571_length_266_cov_1.663212_g72119_i0	PRJNA966993	72571	266	1.663212	4.42414392	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	226	1.3499999999999998e-54	NTclustered	gi\|2651357777\|gb\|PP174294.1\|	1078836	g72119	i0	82.955	1.52255639097744	264	31	98	13	1	260	4437	4690	Cryptodifflugia operculata isolate 75 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	405	226	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
22619052	22619052	PRJNA966993_P_NODE_19378_length_476_cov_3.079404_g18933_i0	PRJNA966993	19378	476	3.079404	14.65796304	Amoeba leningradensis	160820	Tubulinea	other_Eukaryota	514	4.92e-141	NTclustered	gi\|17897590\|emb\|AJ314605.1\|	160820	g18933	i0	86.242	63.8319327731092	487	52	100	12	1	476	1773	1291	Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6	blastn	30384	514	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba leningradensis

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