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

5 rows where analysis = "blastn", bioproject = "PRJNA576995" and tax_phylum = "Nematoda"

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
11340237	11340237	PRJNA576995_P_NODE_32769_length_262_cov_2.592593_g32177_i0	PRJNA576995	32769	262	2.592593	6.79259366	Caenorhabditis	6237	Nematoda	Nematoda	198	2.9e-46	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g32177	i0	84.5	18.3893129770992	200	31	76	0	59	258	377	178	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	4818	198	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
12615971	12615971	PRJNA576995_P_NODE_26430_length_297_cov_1.370536_g25838_i0	PRJNA576995	26430	297	1.370536	4.07049192	Metazoa	33208	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|2445375578\|ref\|XM_053730739.1\|	31234	g25838	i0	100	4.996632996633	30	0	10	0	1	30	231	260	Caenorhabditis remanei uncharacterized protein (GCK72_015262), partial mRNA	blastn	1484	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
14589698	14589698	PRJNA576995_P_NODE_40252_length_245_cov_0.895349_g39660_i0	PRJNA576995	40252	245	0.895349	2.19360505	Strongyloides ratti	34506	Nematoda	Nematoda	230	9.52e-56	NTclustered	gi\|1376154049\|ref\|XM_024646386.1\|	34506	g39660	i0	83.673	3.58775510204082	245	38	99	2	1	244	1279	1036	Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA	blastn	879	230	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
18988322	18988322	PRJNA576995_P_NODE_38175_length_247_cov_1.770115_g37583_i0	PRJNA576995	38175	247	1.770115	4.37218405	Poikilolaimus	96658	Nematoda	Nematoda	457	4.05e-124	NTclustered	gi\|209553348\|gb\|FJ040436.1\|	96659	g37583	i0	100	95.6558704453441	247	0	100	0	1	247	659	905	Poikilolaimus oxycercus isolate 788 18S small subunit ribosomal RNA gene, partial sequence	blastn	23627	457	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Poikilolaimus	Poikilolaimus oxycercus
24786785	24786785	PRJNA576995_P_NODE_22580_length_320_cov_1.186235_g21988_i0	PRJNA576995	22580	320	1.186235	3.795952	Caenorhabditis remanei	31234	Nematoda	Nematoda	191	6.1e-44	NTclustered	gi\|2445382034\|ref\|XM_003114158.2\|	31234	g21988	i0	81.702	17.909375	235	37	73	5	35	266	289	58	Caenorhabditis remanei uncharacterized protein (GCK72_018257), partial mRNA	blastn	5731	191	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei

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