metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_phylum = "Chordata"

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
642993	642993	PRJNA674048_P_NODE_19881_length_198_cov_1.046980_g19678_i0	PRJNA674048	19881	198	1.04698	2.0730204	Canis lupus	9612	Chordata	Chordata	355	1.17e-93	NTclustered	gi\|125658997\|gb\|EF377413.1\|	9615	g19678	i0	98.99	14.6868686868687	198	2	100	0	1	198	566	369	Canis familiaris clone CSac26 satellite sequence	blastn	2908	355	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
1919205	1919205	PRJNA674048_P_NODE_16942_length_216_cov_1.556886_g16739_i0	PRJNA674048	16942	216	1.556886	3.36287376	Mus musculus	10090	Chordata	Chordata	52.8	0.019	NTclustered	gi\|49615225\|gb\|AC115787.6\|	10090	g16739	i0	100	0.12962962962963	28	0	13	0	167	194	55060	55087	Mus musculus chromosome 16, clone RP23-212P1, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1919253	1919253	PRJNA674048_P_NODE_22542_length_185_cov_1.529412_g22339_i0	PRJNA674048	22542	185	1.529412	2.8294122	Meleagris gallopavo	9103	Chordata	Chordata	337	3.89e-88	NTclustered	gi\|2721460845\|emb\|HG999683.4\|	9103	g22339	i0	99.459	1029.41621621622	185	1	100	0	1	185	41843766	41843950	Meleagris gallopavo genome assembly, chromosome: Z	blastn	190442	337	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
2441189	2441189	PRJNA674048_P_NODE_14002_length_241_cov_1.083333_g13799_i0	PRJNA674048	14002	241	1.083333	2.61083253	Lampetra	13103	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2815005712\|emb\|OZ078592.2\|	7748	g13799	i0	100	1.05809128630705	29	0	12	0	74	102	1260541	1260513	Lampetra fluviatilis genome assembly, chromosome: 24	blastn	255	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
3717715	3717715	PRJNA674048_P_NODE_23803_length_180_cov_1.587786_g23600_i0	PRJNA674048	23803	180	1.587786	2.8580148	root	1	Root_unresolved	Root_unresolved	54.7	0.004	NTclustered	gi\|2805716437\|emb\|OZ078423.1\|	7748	g23600	i0	100	0.961111111111111	29	0	16	0	95	123	4441210	4441238	Lampetra fluviatilis genome assembly, chromosome: 20	blastn	173	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
5746516	5746516	PRJNA674048_P_NODE_16605_length_218_cov_3.266272_g16402_i0	PRJNA674048	16605	218	3.266272	7.12047296	Polypterus senegalus	55291	Chordata	Chordata	270	4.89e-68	NTclustered	gi\|1993937637\|ref\|XM_039741126.1\|	55291	g16402	i0	90.385	16.1284403669725	208	17	94	3	13	218	1173	1379	PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA	blastn	3516	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
5746541	5746541	PRJNA674048_P_NODE_19185_length_202_cov_1.019608_g18982_i0	PRJNA674048	19185	202	1.019608	2.05960816	Phaenicophaeus curvirostris	33595	Chordata	Chordata	137	4.72e-28	NTclustered	gi\|2852309334\|ref\|XM_069881719.1\|	33595	g18982	i0	90.385	39.1138613861386	104	10	51	0	1	104	293	190	PREDICTED: Phaenicophaeus curvirostris small ribosomal subunit protein uS17 (LOC138734140), mRNA	blastn	7901	137	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Cuculiformes	Cuculidae	Phaenicophaeus	Phaenicophaeus curvirostris
8296515	8296515	PRJNA674048_P_NODE_9167_length_315_cov_1.406015_g8964_i0	PRJNA674048	9167	315	1.406015	4.42894725	Mus musculus	10090	Chordata	Chordata	560	3.96e-155	NTclustered	gi\|2904934826\|gb\|PQ737751.1\|	10090	g8964	i0	98.73	99.4666666666667	315	4	100	0	1	315	358	44	Mus musculus lncRNA161 lncRNA, complete sequence	blastn	31332	560	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10847271	10847271	PRJNA674048_P_NODE_32669_length_162_cov_0.920354_g32466_i0	PRJNA674048	32669	162	0.920354	1.49097348	Gallus gallus	9031	Chordata	Chordata	278	2.04e-70	NTclustered	gi\|160358550\|gb\|AC202841.3\|	9031	g32466	i0	97.531	308.654320987654	162	4	100	0	1	162	131458	131619	Gallus gallus BAC clone CH261-25J3 from chromosome z, complete sequence	blastn	50002	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
13397268	13397268	PRJNA674048_P_NODE_31091_length_164_cov_0.904348_g30888_i0	PRJNA674048	31091	164	0.904348	1.48313072	Mus musculus	10090	Chordata	Chordata	303	3.42e-78	NTclustered	gi\|257743036\|ref\|NM_010699.2\|	10090	g30888	i0	100	98.8231707317073	164	0	100	0	1	164	805	968	Mus musculus lactate dehydrogenase A (Ldha), transcript variant 1, mRNA	blastn	16207	303	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15945844	15945844	PRJNA674048_P_NODE_31113_length_164_cov_0.904348_g30910_i0	PRJNA674048	31113	164	0.904348	1.48313072	Rattus norvegicus	10116	Chordata	Chordata	303	3.42e-78	NTclustered	gi\|57670\|emb\|X62528.1\|	10116	g30910	i0	100	98.3536585365854	164	0	100	0	1	164	1010	847	R.rattus mRNA for ribonuclease inhibitor	blastn	16130	303	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
18495533	18495533	PRJNA674048_P_NODE_31935_length_163_cov_0.912281_g31732_i0	PRJNA674048	31935	163	0.912281	1.48701803	Meleagris gallopavo	9103	Chordata	Chordata	291	2.64e-74	NTclustered	gi\|2721460913\|emb\|HG999695.4\|	9103	g31732	i0	98.773	2.01226993865031	163	2	100	0	1	163	9298439	9298601	Meleagris gallopavo genome assembly, chromosome: 15	blastn	328	291	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
19017668	19017668	PRJNA674048_P_NODE_22415_length_186_cov_1.145985_g22212_i0	PRJNA674048	22415	186	1.145985	2.1315321	Mus	10088	Chordata	Chordata	333	5.069999999999999e-87	NTclustered	gi\|2415279407\|emb\|OX389814.1\|	10090	g22212	i0	99.454	98.3655913978495	183	1	98	0	1	183	3400	3582	Mus musculus genome assembly, organelle: mitochondrion	blastn	18296	333	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20292563	20292563	PRJNA674048_P_NODE_32896_length_162_cov_0.920354_g32693_i0	PRJNA674048	32896	162	0.920354	1.49097348	Ovis	9935	Chordata	Chordata	265	1.5899999999999998e-66	NTclustered	gi\|2587918875\|tpg\|BK064708.1\|	9940	g32693	i0	96.296	423.697530864198	162	5	100	1	1	162	2400818	2400658	TPA: Ovis aries breed Rambouillet TRA/TRD locus	blastn	68639	265	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
22320394	22320394	PRJNA674048_P_NODE_20218_length_196_cov_1.414966_g20015_i0	PRJNA674048	20218	196	1.414966	2.77333336	Hippopotamus amphibius	9833	Chordata	Chordata	58.4	3.64e-4	NTclustered	gi\|2528695967\|ref\|XM_057737740.1\|	575201	g20015	i0	94.595	0.627551020408163	37	2	19	0	10	46	825	861	PREDICTED: Hippopotamus amphibius kiboko RNA-binding protein with multiple splicing 2-like (LOC130854856), mRNA	blastn	123	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Hippopotamidae	Hippopotamus	Hippopotamus amphibius
23595911	23595911	PRJNA674048_P_NODE_18719_length_204_cov_2.774194_g18516_i0	PRJNA674048	18719	204	2.774194	5.65935576	Xenopus tropicalis	8364	Chordata	Chordata	56.5	0.001	NTclustered	gi\|1785334630\|ref\|XM_031897942.1\|	8364	g18516	i0	90.698	1.40686274509804	43	2	21	2	95	136	3531	3490	PREDICTED: Xenopus tropicalis family with sequence similarity 172 member A (fam172a), transcript variant X1, mRNA	blastn	287	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
24869219	24869219	PRJNA674048_P_NODE_12600_length_257_cov_1.572115_g12397_i0	PRJNA674048	12600	257	1.572115	4.04033555	Diceros bicornis	9805	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2555147908\|ref\|XM_058568239.1\|	77932	g12397	i0	100	1.69649805447471	30	0	12	0	201	230	324	353	PREDICTED: Diceros bicornis minor sterol regulatory element binding transcription factor 2 (SREBF2), mRNA	blastn	436	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Diceros	Diceros bicornis
24869327	24869327	PRJNA674048_P_NODE_27020_length_169_cov_0.866667_g26817_i0	PRJNA674048	27020	169	0.866667	1.46466723	Bos taurus	9913	Chordata	Chordata	313	5.859999999999999e-81	NTclustered	gi\|2587647260\|ref\|XR_009491241.1\|	9913	g26817	i0	100	1492.87573964497	169	0	100	0	1	169	5770	5938	PREDICTED: Bos taurus uncharacterized lncRNA (LOC101902458), transcript variant X2, ncRNA	blastn	252296	313	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
24869361	24869361	PRJNA674048_P_NODE_31160_length_164_cov_0.904348_g30957_i0	PRJNA674048	31160	164	0.904348	1.48313072	Alectoris rufa	9079	Chordata	Chordata	231	1.6399999999999998e-56	NTclustered	gi\|2919602046\|emb\|OZ238769.1\|	9079	g30957	i0	92.121	285.15243902439	165	12	100	1	1	164	27492666	27492502	Alectoris rufa genome assembly, chromosome: 4	blastn	46765	231	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Alectoris	Alectoris rufa

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