contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax_clade = "Amoebozoa"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7061747 | 7061747 | PRJNA700095_P_NODE_28586_length_318_cov_1.840816_g27322_i0 | PRJNA700095 | 28586 | 318 | 1.840816 | 5.85379488 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 327 | 4.42e-85 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g27322 | i0 | 85.58 | 76.2358490566038 | 319 | 39 | 99 | 5 | 1 | 317 | 2065 | 2378 | Phalansterium solitarium 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 | 24243 | 327 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 8336284 | 8336284 | PRJNA700095_P_NODE_18587_length_414_cov_1.665689_g17324_i0 | PRJNA700095 | 18587 | 414 | 1.665689 | 6.89595246 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 449 | 1.2099999999999998e-121 | NTclustered | gi|2651357789|gb|PP174304.1| | 1892891 | g17324 | i0 | 86.288 | 9.13285024154589 | 423 | 46 | 100 | 8 | 1 | 414 | 3835 | 3416 | Amoebozoa sp. isolate 114_WLI 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 | 3781 | 449 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. | |||||||
| 8336286 | 8336286 | PRJNA700095_P_NODE_18887_length_410_cov_1.593472_g17624_i0 | PRJNA700095 | 18887 | 410 | 1.593472 | 6.5332352 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|831766037|ref|XM_012896213.1| | 1410327 | g17624 | i0 | 100 | 0.0707317073170732 | 29 | 0 | 7 | 0 | 247 | 275 | 522 | 550 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8336512 | 8336512 | PRJNA700095_P_NODE_62287_length_243_cov_0.905882_g61023_i0 | PRJNA700095 | 62287 | 243 | 0.905882 | 2.20129326 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 62.1 | 3.64e-5 | NTclustered | gi|470405280|ref|XM_004335798.1| | 1257118 | g61023 | i0 | 100 | 0.135802469135802 | 33 | 0 | 14 | 0 | 22 | 54 | 162 | 130 | Acanthamoeba castellanii str. Neff RNA binding motif containing protein (ACA1_076860), partial mRNA | blastn | 33 | 62.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11387838 | 11387838 | PRJNA700095_P_NODE_69609_length_222_cov_5.046980_g68344_i0 | PRJNA700095 | 69609 | 222 | 5.04698 | 11.2042956 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 411 | 2.8199999999999996e-110 | NTclustered | gi|1776318159|gb|MN700286.1| | 5755 | g68344 | i0 | 100 | 100 | 222 | 0 | 100 | 0 | 1 | 222 | 232 | 11 | Acanthamoeba castellanii isolate PD8-B17 small subunit ribosomal RNA gene, partial sequence | blastn | 22200 | 411 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13938104 | 13938104 | PRJNA700095_P_NODE_17071_length_438_cov_2.150685_g15808_i0 | PRJNA700095 | 17071 | 438 | 2.150685 | 9.4200003 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|330791506|ref|XM_003283786.1| | 5786 | g15808 | i0 | 92.5 | 1.13013698630137 | 40 | 3 | 9 | 0 | 237 | 276 | 6288 | 6327 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA | blastn | 495 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 15985730 | 15985730 | PRJNA700095_P_NODE_18813_length_411_cov_1.905325_g17550_i0 | PRJNA700095 | 18813 | 411 | 1.905325 | 7.83088575 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 58.4 | 8.49e-4 | NTclustered | gi|66801572|ref|XM_629710.1| | 352472 | g17550 | i0 | 100 | 0.420924574209246 | 31 | 0 | 8 | 0 | 113 | 143 | 462 | 492 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0292330) mRNA, complete cds | blastn | 173 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20310493 | 20310493 | PRJNA700095_P_NODE_18336_length_418_cov_1.759420_g17073_i0 | PRJNA700095 | 18336 | 418 | 1.75942 | 7.3543756 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|23953894|gb|AY159040.1| | 44689 | g17073 | i0 | 94.444 | 0.643540669856459 | 36 | 2 | 9 | 0 | 1 | 36 | 7832 | 7867 | Dictyostelium discoideum LvsD (lvsD) gene, partial cds | blastn | 269 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 21085558 | 21085558 | PRJNA700095_P_NODE_29277_length_314_cov_1.858921_g28013_i0 | PRJNA700095 | 29277 | 314 | 1.858921 | 5.83701194 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 259 | 1.6100000000000002e-64 | NTclustered | gi|66817509|ref|XM_637516.1| | 352472 | g28013 | i0 | 81.587 | 42.3089171974522 | 315 | 56 | 100 | 2 | 1 | 314 | 604 | 917 | Dictyostelium discoideum AX4 vacuolar H+ ATPase B subunit (vatB) mRNA, complete cds | blastn | 13285 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 21085717 | 21085717 | PRJNA700095_P_NODE_60557_length_244_cov_1.385965_g59293_i0 | PRJNA700095 | 60557 | 244 | 1.385965 | 3.3817546 | Physarum sp. AMFD-2018a | 2498839 | Evosea | other_Eukaryota | 429 | 8.699999999999998e-116 | NTclustered | gi|1543031424|gb|MK336179.1| | 2498839 | g59293 | i0 | 98.755 | 92.7008196721311 | 241 | 3 | 99 | 0 | 1 | 241 | 1998 | 2238 | Physarum sp. AMFD-2018a voucher BW2014 small subunit ribosomal RNA gene, partial sequence | blastn | 22619 | 429 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum sp. AMFD-2018a |
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);;