metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
3506822	3506822	PRJNA980587_P_NODE_89103_length_244_cov_1.906433_g88310_i0	PRJNA980587	89103	244	1.906433	4.65169652	Strongyloides papillosus	174720	Nematoda	Nematoda	87.9	6.03e-13	NTclustered	gi\|687022679\|emb\|LM525593.1\|	174720	g88310	i0	75	22.0983606557377	204	44	82	7	46	244	105508	105307	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000027	blastn	5392	87.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
4784400	4784400	PRJNA980587_P_NODE_83184_length_248_cov_0.880000_g82391_i0	PRJNA980587	83184	248	0.88	2.1824	Oscheius dolichura	473156	Nematoda	Nematoda	455	1.4600000000000002e-123	NTclustered	gi\|300379472\|gb\|HM355811.1\|	473156	g82391	i0	100	27.258064516129	246	0	99	0	3	248	2885	2640	Oscheius dolichura isolate LDY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	6760	455	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Oscheius	Oscheius dolichura
7333848	7333848	PRJNA980587_P_NODE_77726_length_252_cov_1.480447_g76933_i0	PRJNA980587	77726	252	1.480447	3.73072644	Caenorhabditis elegans	6239	Nematoda	Nematoda	220	5.919999999999999e-53	NTclustered	gi\|863015\|gb\|U27559.1\|CEU27559	6239	g76933	i0	82.54	79.3015873015873	252	42	99	2	1	251	131	381	Caenorhabditis elegans cyclophilin (cyp-7) mRNA, complete cds	blastn	19984	220	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7334075	7334075	PRJNA980587_P_NODE_92346_length_242_cov_2.349112_g91553_i0	PRJNA980587	92346	242	2.349112	5.68485104	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	135	2.1e-27	NTclustered	gi\|256709231\|gb\|GQ422268.1\|	669147	g91553	i0	80.769	3.08677685950413	182	28	73	5	33	209	10	189	Tylopharynx sp. WEM-2009 small subunit ribosomal protein 28 (rps-28) mRNA, partial cds	blastn	747	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
8609092	8609092	PRJNA980587_P_NODE_84247_length_247_cov_2.143678_g83454_i0	PRJNA980587	84247	247	2.143678	5.29488466	Caenorhabditis briggsae	6238	Nematoda	Nematoda	159	1.28e-34	NTclustered	gi\|268579656\|ref\|XM_002644765.1\|	6238	g83454	i0	84.906	27.0283400809717	159	22	64	2	21	178	1085	1242	Caenorhabditis briggsae Protein CBR-HSP-3 (Cbr-hsp-3), partial mRNA	blastn	6676	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16258833	16258833	PRJNA980587_P_NODE_65433_length_280_cov_1.410628_g64640_i0	PRJNA980587	65433	280	1.410628	3.9497584	Strongyloides ratti	34506	Nematoda	Nematoda	191	5.24e-44	NTclustered	gi\|1376154927\|ref\|XM_024651418.1\|	34506	g64640	i0	81.435	164.867857142857	237	40	84	4	34	268	1	235	Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA	blastn	46163	191	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
18807591	18807591	PRJNA980587_P_NODE_53955_length_312_cov_1.196653_g53162_i0	PRJNA980587	53955	312	1.196653	3.73355736	Caenorhabditis elegans	6239	Nematoda	Nematoda	93.5	1.72e-14	NTclustered	gi\|412984027\|emb\|FO081559.2\|	6239	g53162	i0	80.159	2.3525641025641	126	23	40	2	181	305	19739	19863	Caenorhabditis elegans Fosmid H22K11, complete sequence	blastn	734	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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